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$[[$sid$,$sname,rating,age$]]$

$\backslash$table$[[22,$Dustin,$7,45\mathrm{.}0],[29,$Brutus,$1,33\mathrm{.}0],[31,$Lubber,$8,55\mathrm{.}5],[32,$Andy,$8,25\mathrm{.}5],[58,$Rusty,$10,35\mathrm{.}0],[64,$Horatio,$7,35\mathrm{.}0],[71,$Zorba,$10,16\mathrm{.}0],[74,$Horatio,$9,35\mathrm{.}0],[85,$Art,$3,25\mathrm{.}5],[95,$Bob,$3,63\mathrm{.}5]]$

Sailors

$\backslash$table$[[$sid$,$bid,Day$]]$

$\backslash$table$[[22,101,\frac{10}{10}\frac{?}{98}$