Design Of Database Course

Question 10 10 points Save Answer Consider the following ER diagram. Construct a reasonable set of relation schema to implement it. For each relation, underline the primary key (PK) and list its candidate keys (CK), 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: A B b e HO D HO f 01C Question 10 10 points Save Answer Consider the following ER diagram. Construct a reasonable set of relation schema to implement it. For each relation, underline the primary key (PK) and list its candidate keys (CK), 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: A B b e HO D HO f 01C