Data Models into Database Designs – True or False

11. The DBMS allows surrogate keys to be changed.

A. True
B. False

Correct Answer:  B. False
Advertisement

12. Cascading updates refer to child rows being automatically deleted when a parent row is deleted.

A. True
B. False

Correct Answer:  B. False
Advertisement

13. When transforming an entity-relationship model into a relational database design, each entity is represented as a table.

A. True
B. False

Correct Answer:  A. True
Advertisement

14. Surrogate keys have much meaning for users.

A. True
B. False

Correct Answer:  B. False
Advertisement

15. When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.

A. True
B. False

Correct Answer:  A. True
Advertisement

Leave A Comment?