Exercise: Transforming Data Models Into Database Designs

Questions for: Transforming Data Models Into Database Designs

An ideal primary key is short, numeric and seldom changing.
A:
True
B:
False
C:
D:
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
For every relationship, there are six possible referential integrity actions.
A:
True
B:
False
C:
D:
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
When the parent entity is required, a new parent row can always be inserted.
A:
True
B:
False
C:
D:
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
A:
True
B:
False
C:
D:
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
(STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
A:
True
B:
False
C:
D:
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz