Tutorial - MySQL Practical Exercise-Week 8 This exercise is similar to week 5. Students at this stage should be illustrated how to create tables, alter tables, and write complex SQL queries. Note: Use SQL commands to create the database, tables, records, and Queries. Create the database SBRCOMMANDS and the following tables Sailors, Boats, and Reserves which are reproduced as follows: Sailors(sid: VARCHAR(2) PK, sname: VARCHAR(7), rating: SMALLINT, age: DOUBLE Boatsbid: VARCHAR(3) PK, name: VARCHAR (10), colour: VARCHAR(6) Reserves(sid: VARCHAR(2) FK, bid: VARCHAR(3) FK, day: DATE) -| fo 22 Dustin 45.0 101 101010make Nos Sets 33.0 22 102 10/10/98 102 tenerlake red 30 Lahbar 33.5 23 105 108/98103 Clipper green 33 Ay 25.5 22 10 10/7/98 104 Marine od SS Rusty 03.01 102 01710198 6 HDI 109 11098 Beats Trorha Zorba 10 16.0 31 100 11/12/98 70 et 9506101598 ASLAR 13264102898 Bob SU 103.98 Sales Reserves Enter the test data for the three tables as shown above, and formulate following SOL Queries. Lecturers: The commands are JOIN queries. Explain to students the concepts of join and then help them formulate the queries. Question 1 Find the sailor ID, boat name, and colour of those boats reserved on 9/8/98 Question 2 Find the names of sailors who have reserved boat 103. Question 3 Find the names of sailors who have reserved a red boat