Question: Tu points Consider the following ER diagram. Construct a reasonable set of relation schema to implement it. For each relation, underline the primary key (P)
Tu points Consider the following ER diagram. Construct a reasonable set of relation schema to implement it. For each relation, underline the primary key (P) and list its candidate keys (C). foreign keys (FK), and all attributes you know for sure that are nullable. If you create a surrogate key for a relation, indicate so. Use the following format for each relation in your answer, which you can copy and paste into your answer. 1. Relation: a. Candidate keys: b. Foreign keys: c. Nullable attributes: d. Notes: Note that the attributes a and g have been identified as the primary keys for the entities A and Drespectively, A B po 0 Tu points Consider the following ER diagram. Construct a reasonable set of relation schema to implement it. For each relation, underline the primary key (P) and list its candidate keys (C). foreign keys (FK), and all attributes you know for sure that are nullable. If you create a surrogate key for a relation, indicate so. Use the following format for each relation in your answer, which you can copy and paste into your answer. 1. Relation: a. Candidate keys: b. Foreign keys: c. Nullable attributes: d. Notes: Note that the attributes a and g have been identified as the primary keys for the entities A and Drespectively, A B po 0
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
