Logical Database Design 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 functional dependency between two or more nonkey attributes. A relation that is in first normal form. A functional dependency between two or more key attributes. A relation that is in second normal form. A functional dependency between two or more nonkey attributes. A relation that is in first normal form. 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. True False True False ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design A foreign key is which of the following? 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 Any attribute The same thing as a primary key An attribute that serves no purpose ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design An enterprise key is a primary key whose value is unique for a given relation. False True False True ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design A primary key may be null. False True False True ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design The entity integrity rule states that: no primary key may be unique. no primary key may be equal to a value in a foreign key. no primary key can be composite. no primary key attribute may be null. no primary key may be unique. no primary key may be equal to a value in a foreign key. no primary key can be composite. no primary key attribute may be null. ANSWER DOWNLOAD EXAMIANS APP