Answered step by step
Verified Expert Solution
Question
1 Approved Answer
All columns are NOT NULL. The person _ id columns have data type SMALLINT UNSIGNED. The last _ update and create _ date columns have
All columns are NOT NULL. The personid columns have data type SMALLINT UNSIGNED. The lastupdate and createdate columns have data type TIMESTAMP. The picture column has data type BLOB. All other columns have data type VARCHAR Implement the dependency relationships between subtype and supertype entities as foreign keys: The personid columns of customer and staff become foreign keys referring to person. Specify CASCADE actions for both relationships. Implement the belongsto and worksat relationships as foreign keys: belongsto becomes an addressid foreign key in person referring to address. worksat becomes a storeid foreign key in staff referring to store. Specify RESTRICT actions for both relationships. The address and store tables, with primary keys addressid and storeid are predefined in the zyLab environment. Foreign keys must have the same data types as the referenced primary keys: addressid has data type SMALLINT UNSIGNED. storeid 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: ALTER TABLE payment DROP CONSTRAINT fkpaymentcustomer, DROP CONSTRAINT fkpaymentstaff; ALTER TABLE rental DROP CONSTRAINT fkrentalcustomer, DROP CONSTRAINT fkrentalstaff; ALTER TABLE store DROP CONSTRAINT fkstorestaff; DROP TABLE customer, staff;All columns are NOT NULL. The personid columns have data type SMALLINT UNSIGNED. The lastupdate and createdate columns have data type TIMESTAMP. The picture column has data type BLOB. All other columns have data type VARCHAR Implement the dependency relationships between subtype and supertype entities as foreign keys: The personid columns of customer and staff become foreign keys referring to person. Specify CASCADE actions for both relationships. Implement the belongsto and worksat relationships as foreign keys: belongsto becomes an addressid foreign key in person referring to address. worksat becomes a storeid foreign key in staff referring to store. Specify RESTRICT actions for both relationships. The address and store tables, with primary keys addressid and storeid are predefined in the zyLab environment. Foreign keys must have the same data types as the referenced primary keys: addressid has data type SMALLINT UNSIGNED. storeid 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: ALTER TABLE payment DROP CONSTRAINT fkpaymentcustomer, DROP CONSTRAINT fkpaymentstaff; ALTER TABLE rental DROP CONSTRAINT fkrentalcustomer, DROP CONSTRAINT fkrentalstaff; ALTER TABLE store DROP CONSTRAINT fkstorestaff; DROP TABLE customer, staff;
All columns are NOT NULL.
The personid columns have data type SMALLINT UNSIGNED.
The lastupdate and createdate columns have data type TIMESTAMP.
The picture column has data type BLOB.
All other columns have data type VARCHAR
Implement the dependency relationships between subtype and supertype entities as foreign keys:
The personid columns of customer and staff become foreign keys referring to person.
Specify CASCADE actions for both relationships.
Implement the belongsto and worksat relationships as foreign keys:
belongsto becomes an addressid foreign key in person referring to address.
worksat becomes a storeid foreign key in staff referring to store.
Specify RESTRICT actions for both relationships.
The address and store tables, with primary keys addressid and storeid are predefined in the zyLab environment. Foreign keys must have the same data types as the referenced primary keys:
addressid has data type SMALLINT UNSIGNED.
storeid 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:
ALTER TABLE payment
DROP CONSTRAINT fkpaymentcustomer,
DROP CONSTRAINT fkpaymentstaff;
ALTER TABLE rental
DROP CONSTRAINT fkrentalcustomer,
DROP CONSTRAINT fkrentalstaff;
ALTER TABLE store
DROP CONSTRAINT fkstorestaff;
DROP TABLE customer, staff;All columns are NOT NULL.
The personid columns have data type SMALLINT UNSIGNED.
The lastupdate and createdate columns have data type TIMESTAMP.
The picture column has data type BLOB.
All other columns have data type VARCHAR
Implement the dependency relationships between subtype and supertype entities as foreign keys:
The personid columns of customer and staff become foreign keys referring to person.
Specify CASCADE actions for both relationships.
Implement the belongsto and worksat relationships as foreign keys:
belongsto becomes an addressid foreign key in person referring to address.
worksat becomes a storeid foreign key in staff referring to store.
Specify RESTRICT actions for both relationships.
The address and store tables, with primary keys addressid and storeid are predefined in the zyLab environment. Foreign keys must have the same data types as the referenced primary keys:
addressid has data type SMALLINT UNSIGNED.
storeid 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:
ALTER TABLE payment
DROP CONSTRAINT fkpaymentcustomer,
DROP CONSTRAINT fkpaymentstaff;
ALTER TABLE rental
DROP CONSTRAINT fkrentalcustomer,
DROP CONSTRAINT fkrentalstaff;
ALTER TABLE store
DROP CONSTRAINT fkstorestaff;
DROP TABLE customer, staff;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started