Section 11
(Answer all questions in this section)

  1. When mapping supertypes, relationships at the supertype level transform as usual. Relationships at subtype level are implemented as foreign keys, but the foreign key columns all become optional. True or False?

  True 

False



  2. When translating an arc relationship to a physical design, you must turn the arc relationships into foreign keys. What additional step must you take with the created foreign keys to ensure the exclusivity principle of arc relationships? (Assume that you are implementing an Exclusive Design) (Choose Two)

(Choose all correct answers)

Make all relationships mandatory

  Make all relationships optional 

  Create an additional check constraint to verify that one foreign key is populated and the others are not

All the above



  3. Which of the following are reasons you should consider when using a Subtype Implementation?

(Choose all correct answers)

When the common access paths for the subtypes are similar.

  When the common access paths for the subtypes are different. 

Business functionality and business rules are similar between subtypes.

  Most of the relationships are at the subtype level 



  4. The "Arc Implementation" is a synonym for what type of implementation?

Supertype Implementation

Subtype Implementation

Cascade Implementation

  Supertype and Subtype Implementation