When mapping a supertype/subtype relationship which of the following is true? The subtype primary key is assigned to each supertype. There is no link between the supertype/subtype entities. The supertype primary key is assigned to each subtype. There is no primary key/foreign key relationship between a supertype/subtype. TRUE ANSWER : ? YOUR ANSWER : ?
A primary key is which of the following? A derived attribute An attribute that uniquely identifies each row Any attribute An attribute that uniquely identifies each column 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. False True TRUE ANSWER : ? YOUR ANSWER : ?
Normalization is a formal process for deciding which attributes should be grouped together in a relation. True False TRUE ANSWER : ? YOUR ANSWER : ?
The relational model consists of: operations using non-SQL languages. data redundancy. data in the form of tables. unorganized data. TRUE ANSWER : ? YOUR ANSWER : ?
A relation has which of the following properties? The order of the columns is significant. Each relation has a unique name. Attributes can have the same name within a given table. Each row is not unique. TRUE ANSWER : ? YOUR ANSWER : ?
When mapping a ternary relationship with an associative entity into a relation which of the following is true? One relation is created. Two relations are created. Three relations are created. Four relations are created. TRUE ANSWER : ? YOUR ANSWER : ?
When mapping a multivalued attribute into a relation which of the following is true? One relation is created. Three relations are created. Two relations are created. Four relations are created. TRUE ANSWER : ? YOUR ANSWER : ?
A foreign key may be null and still adhere to the referential integrity constraint. True False TRUE ANSWER : ? YOUR ANSWER : ?