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 An enterprise key is a primary key whose value is unique for a given relation. True False True False ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design When mapping a supertype/subtype relationship which of the following is true? There is no primary key/foreign key relationship between a supertype/subtype. The supertype primary key is assigned to each subtype. The subtype primary key is assigned to each supertype. There is no link between the supertype/subtype entities. There is no primary key/foreign key relationship between a supertype/subtype. The supertype primary key is assigned to each subtype. The subtype primary key is assigned to each supertype. There is no link between the supertype/subtype entities. ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design Normalization is a formal process for deciding which attributes should be grouped together in a relation. False True False True ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design The entity integrity rule states that: no primary key attribute may be null. no primary key may be equal to a value in a foreign key. no primary key may be unique. no primary key can be composite. no primary key attribute may be null. no primary key may be equal to a value in a foreign key. no primary key may be unique. no primary key can be composite. ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design 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. True False True False ANSWER DOWNLOAD EXAMIANS APP