A transitive dependency is which of the following? A functional dependency between two or more key attributes. A relation that is in second normal form. A relation that is in first normal form. A functional dependency between two or more nonkey attributes. TRUE ANSWER : ? YOUR ANSWER : ?
The relational model consists of: data in the form of tables. unorganized data. operations using non-SQL languages. data redundancy. TRUE ANSWER : ? YOUR ANSWER : ?
When mapping a many-to-many unary relationship into a relation which of the following is true? Three relations are created. Four relations are created. One relation is created. Two relations are created. TRUE ANSWER : ? YOUR ANSWER : ?
When mapping a supertype/subtype relationship which of the following is true? The supertype primary key is assigned to each subtype. There is no link between the supertype/subtype entities. There is no primary key/foreign key relationship between a supertype/subtype. The subtype primary key is assigned to each supertype. TRUE ANSWER : ? YOUR ANSWER : ?
If no multivalued attributes exist in a relation, then the relation is in what normal form? Second normal form First normal form Third normal form Fourth normal form TRUE ANSWER : ? YOUR ANSWER : ?
A foreign key may be null and still adhere to the referential integrity constraint. False True TRUE ANSWER : ? YOUR ANSWER : ?
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. True False TRUE ANSWER : ? YOUR ANSWER : ?
When mapping a multivalued attribute into a relation which of the following is true? Four relations are created. One relation is created. Two relations are created. Three relations are created. TRUE ANSWER : ? YOUR ANSWER : ?