Implement the belongs$\_$to and works$\_$at relationships as foreign keys:

belongs$\_$to becomes an address$\_$id foreign key in person with data type SMALLINT UNSIGNED.

works$\_$at becomes a store$\_$id foreign key in staff with data type TINYINT UNSIGNED$\mathrm{.}4\mathrm{.}5$ LAB $-$ Implement supertype and subtype entities $($Sakila$)$

Similar entities have many common attributes and relationships. Similar entities are often converted into subtypes of a supertype entity, as

illustrated in this lab.

In the Sakila database, the customer and staff tables have several common columns. Convert these tables into subtypes of person.

Specifically, write CREATE TABLE statements for person, customer, and staff that implement this ER diagram:

address

belor

Follow Sakila conventions for table and column names:

All lower case

Underscore separator between root and suffix

Foreign keys have the same name as referenced primary key

Implement attributes as columns:

The primary key of all three tables is person$\_$id with data type SMALIINT UNSIGNED.

The last$\_$update and create$\_$date columns have data type TIMESTAMP.

The picture column has data type BLOB.

All other columns have data type VARCHAR $(20).$

Implement the belongs$\_$to and works$\_$at relationships as foreign keys: