Logical Database Design Well-structured relations encourage anomalies of data. False True False True ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design A foreign key may be null and still adhere to the referential integrity constraint. False True False True ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design A foreign key is which of the following? Any attribute The same thing as a primary key An attribute that serves no purpose An attribute that serves as the primary key of another relation Any attribute The same thing as a primary key An attribute that serves no purpose An attribute that serves as the primary key of another relation ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design When mapping a multivalued attribute into a relation which of the following is true? One relation is created. Two relations are created. Four relations are created. Three relations are created. One relation is created. Two relations are created. Four relations are created. Three relations are created. ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design If no multivalued attributes exist in a relation, then the relation is in what normal form? Fourth normal form First normal form Second normal form Third normal form Fourth normal form First normal form Second normal form Third normal form ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design 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. 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. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS