Question: Using Figure 5.7 on Page 164 from your text, for each table in the schema, identify the key attributes, and foreign key attributes. Also give
Using Figure 5.7 on Page 164 from your text, for each table in the schema, identify the key attributes, and foreign key attributes. Also give an example of one key constraint, one domain constraint, and one existence (or referential integrity) constraint. When you refer to an attribute, be sure to also mention the table name, for example, use EMPLOYEE.Ssn (Essn) instead of Ssn.

Using Figure 5.7 on Page 164 from your text, for each table in the schema, identify the key attributes, and foreign key attributes. Also give an example of one key constraint, one domain constraint, and one existence (or referential integrity) constraint. When you refer to an attribute, be sure to also mention the table name, for example, use EMPLOYEE.Ssn (Essn) instead of Ssn. Figure 5.7 Referential integrity constraints displayed on the COMPANY relational database schema
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
