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 A transitive dependency is which of the following? 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. A relation that is in first normal form. A functional dependency between two or more key attributes. 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 When mapping a regular entity into a relation which of the following is true? Three relations are created. 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. ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design When mapping a many-to-many unary relationship into a relation which of the following is true? One relation is created. Four relations are created. Two relations are created. Three relations are created. One relation is created. Four relations are created. Two relations are created. Three relations are created. ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design The relational model consists of: data redundancy. operations using non-SQL languages. unorganized data. data in the form of tables. data redundancy. operations using non-SQL languages. unorganized data. data in the form of tables. ANSWER DOWNLOAD EXAMIANS APP