Exercise: Logical Database Design And The Relational Model

Questions for: Logical Database Design And The Relational Model

A transitive dependency is which of the following?
A:
A functional dependency between two or more key attributes.
B:
A functional dependency between two or more nonkey attributes.
C:
A relation that is in first normal form.
D:
A relation that is in second normal form.
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
A foreign key is which of the following?
A:
Any attribute
B:
The same thing as a primary key
C:
An attribute that serves as the primary key of another relation
D:
An attribute that serves no purpose
Answer: C
No answer description is available. Let's discuss.
📖
📝
💬
👁️
If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
A:
First normal form
B:
Second normal form
C:
Third normal form
D:
Fourth normal form
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
When mapping a many-to-many unary relationship into a relation which of the following is true?
A:
One relation is created.
B:
Two relations are created.
C:
Three relations are created.
D:
Four relations are created.
Answer: B
No answer description is available. Let's discuss.
📖
📝
💬
👁️
The entity integrity rule states that:
A:
no primary key attribute may be null.
B:
no primary key can be composite.
C:
no primary key may be unique.
D:
no primary key may be equal to a value in a foreign key.
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz