Data Models into Database Designs MCQs

Question 1

Intersection tables are ID-dependent on both their parent tables.

Accepted Answer

True

Answer

False

Question 2

For every relationship, there are six possible sets of minimum cardinalities.

Accepted Answer

False

Answer

True

Question 3

An intersection table is required to represent M:N relationships.

Accepted Answer

True

Answer

False

Question 4

The DBMS allows surrogate keys to be changed.

Accepted Answer

False

Answer

True

Question 5

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

Accepted Answer

False

Answer

True

Question 6

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

Accepted Answer

True

Answer

False

Question 7

Surrogate keys have much meaning for users.

Accepted Answer

False

Answer

True

Question 8

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.

Accepted Answer

True

Answer

False

Question 9

(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.

Accepted Answer

False

Answer

True