Question: Can anyone solve 5 until 17 ? Sailors(sid integer, sname: string, rating: integer, age: real) Boats( bid integer, bname: string, color: string) Reserves(sid integer, bid:

Can anyone solve 5 until 17 ?  Can anyone solve 5 until 17 ? Sailors(sid integer, sname: string,
rating: integer, age: real) Boats( bid integer, bname: string, color: string) Reserves(sid

Sailors(sid integer, sname: string, rating: integer, age: real) Boats( bid integer, bname: string, color: string) Reserves(sid integer, bid: integer, dax: date Create data base tables using above attributes, Note: pk represented as attribute underlined. Insert following information into those tables. lsid I sname rating 1 age 45.0 33.0 22 Dustin7 29 Brutus 31 Lubber 8 32 Andy 22101 10/10/9 22 102 10/ 10098 22 103 10/8/98 22 104 10/7/98 25.5 35.0 35.0 16.0 35.0 25.5 8 58Rusty 10 64 Horatio 7 71 Zorba 10 74 Horatio 9 85 Art 31 102 11/10/98 31 103 11/6/98 31 104 11/12/98 64 101 9/5/98 64 102 9/8/98 74 103 9/8/98 95 Bob 3635 Figure S.1 An Instance 53 of Sailors Figure 5.2 An Iastance R2 of Reserves idbname1 color 101 Interlake blue 102 Interlake red 103 Clipper green 104 Marinered Figure S.3 An Iastance BI of Boats Write the query to extract following information from above tables. I a) Find the names and ages of all sailors? b) Find the' names and ages of distinct sailors

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!