Data Models into Database Designs – True or False

1. A foreign key is used to implement relationships between tables.

A. True
B. False

Correct Answer:  A. True
Advertisement

2. The terms alternate key and candidate key means the same thing.

A. True
B. False

Correct Answer:  A. True
Advertisement

3. In 1:N relationships, which entity becomes the parent entity is arbitrary.

A. True
B. False

Correct Answer:  B. False
Advertisement

4. When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.

A. True
B. False

Correct Answer:  A. True
Advertisement

5. In a 1:1 relationship, the primary key placement is arbitrary.

A. True
B. False

Correct Answer:  A. True
Advertisement

Leave A Comment?