database design $2\mathrm{.}11$ LAB $-$ Implement supertype and subtype entities $($Sakila$)$ Refer to the customer and staff tables of the Sakila database. These tables have many columns in common and represent simile entities. Convert the customer and staff entities into subtypes of a new supertype person person address person id first$\_$name belongs to last$\_$name email $1(1)$ MOJ active tast$\_$update staff person id picture username password works$\_$at MO $1/1)$ store customer person id create, date The diagram uses Sakita naming conventions. Follow the Sakila conventions for your table and column names All lower case Underscore separator between root and suffix Foreign keys have the same name as referenced primary key Implement supertype and subtype entities as person, customer and staff tables with primary key person$\_$id Implement attributes as columns All columns are NOT NULL The person id columns have data type SMALLINT UNSIGNEDAll columns are NOT NULL The person$\_$id columns have data type SMALLINT 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 dependency relationships between subtype and supertype entities as foreign keys: The person$\_$id columns of customer and staff become foreign keys referring to person Specify CASCADE actions for both relationships. Implement the belongs to and works$\_$at relationships as foreign keys: belongs$\_$to becomes an address$\_$id foreign key in person referring to address. works$\_$at becomes a store$\_$id foreign key in staff referring to store Specify RESTRICT actions for both relationships The address and store tables with primary keys address$\_$id and store$\_$id$,$ are pre$-$defined in the zyLab environment Foreign keys must have the same data types as the referenced primary keys: address$\_$id has data type SMALLINT UNSIGNED store$\_$id has data type TINYINT UNSIGNED If you execute your solution with the Sakila database, you must first drop customer, staff, and all constraints that refer to these tables Use the following statements with Sakila only, not in the zyLab environment DROP TABLE customer, staff; ALTER TABLE payment DROP CONSTRAINT fk payment customer, DROP CONSTRAINT $[$k$\_$payment$\_$staff: ALTER TABLE rentalDROP TABLE customer, staff ALTER TABLE payment DROP CONSTRAINT Ek$\_$payment customer, DROP CONSTRAINT Ek$\_$payment$\_$staff; ALTER TABLE rental DROP CONSTRAINT fk$\_$rental$\_$customer, DROP CONSTRAINT fk$\_$rental staff; ALTER TABLE Store DROP CONSTRAINT fk$\_$store$\_$staff: LAB ACTIVITY $2\mathrm{.}11\mathrm{.}1$: LAB $-$ Implement supertype and subtype entities $($Sakila$)0/10$ Main.sql Load default template $1-$ Your CREATE TABLE statements go here $2$