Logical Database Design Questions

• If no multivalued attributes exist in a relation, then the relation is in what normal form?
• When mapping a many-to-many unary relationship into a relation which of the following is true?
• A foreign key is which of the following?
• A primary key is which of the following?
• Relations are:
• A relation has which of the following properties?
• When mapping a binary many-to-many relationship into a relation which of the following is true?
• The entity integrity rule states that:
• The relational model consists of:
• If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
• A transitive dependency is which of the following?
• When mapping a regular entity into a relation which of the following is true?
• When mapping a ternary relationship with an associative entity into a relation which of the following is true?
• When mapping a supertype/subtype relationship which of the following is true?
• When mapping a multivalued attribute into a relation which of the following is true?
• Weak entities do not get mapped into a relation.
• In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side.
• A primary key may be null.
• The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.
• An enterprise key is a primary key whose value is unique for a given relation.