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:
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
Get step-by-step solutions from verified subject matter experts
