Workshop $-$ Week $8$ MySQL Practical Exercise

Exercise $1$

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

boats$($bid:VARCHAR$(3)$ PK$,$ bname:VARCHAR $(10),$ colour:VARCHAR$(6)$

reserves$($ sid:VARCHAR$(2)$ FK$,$ bid:VARCHAR$(3)$ FK$,$ day:DATE$)$

$\backslash$table$[[\backslash$table$[[$si$],[d$