Logical Database Design A transitive dependency is which of the following? A relation that is in first normal form. A functional dependency between two or more key attributes. A functional dependency between two or more nonkey attributes. A relation that is in second normal form. A relation that is in first normal form. A functional dependency between two or more key attributes. A functional dependency between two or more nonkey attributes. A relation that is in second normal form. ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design A composite attribute does not get mapped into a relation. True False True False ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design The relational model consists of: operations using non-SQL languages. data redundancy. unorganized data. data in the form of tables. operations using non-SQL languages. data redundancy. unorganized data. data in the form of tables. 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 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 subtype primary key is assigned to each supertype. 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. The supertype primary key is assigned to each subtype. There is no link between the supertype/subtype entities. ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design If a relation is in third normal form, it does not need to be in second normal form. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS