Given the Sailor, Boat, and Reservation tables. Sailor Table Reservation Table ID (PK) NAME RATING AGE SID (FK) BID (FK) DAY 22 Dustin 7 45 31 Lubber 8. 65,5 22 101 10.10.2006 58 Rusty 10 35 58 103 11.12.2011 59 Smith 41 31 104 4.02.2007 31 103 5.02.2007 Boat Table 58 103 6.02.2007 ID (PK) ΝΑΜΕ COLOUR Interlake Interlake 101 blue 31 102 15.02.2007 102 red 59 102 5.01.2008 103 Clipper green red 104 Marine 31 101 5.01.2008 Write the appropriate SQL queries c) List those sailors who have reserved only red boats. d) For which boat are there the most reservations?

I want to write the SQL to create the tables for the ERD attached, but I also want to add this to the tables: rental date, due date, and return date so that I can support overdue queries. I also want it so each table has primary keys and foreign keys. I want it so the tables have at least 4 rows of data. How can I do this? Thank you for your help as I learn more about SQL and table creation.

answer with proper explanation and step by step solution. Question write a PL/ SQL program to display the number of products whose price is 100 dh more or less than the price defined the for substitution variable use the define command to specify the price pass this value to the PL/SQL black using a substitution variable

PLZ hlp with the following: In SQL If you add the PRIMARY KEY constraint to a column, you must also add a UNIQUE constraint to it. Select one: True False