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 The entity integrity rule states that: no primary key may be equal to a value in a foreign key. no primary key can be composite. no primary key may be unique. no primary key attribute may be null. no primary key may be equal to a value in a foreign key. no primary key can be composite. no primary key may be unique. no primary key attribute may be null. ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design When mapping a supertype/subtype relationship which of the following is true? The supertype primary key is assigned to each subtype. The subtype primary key is assigned to each supertype. There is no primary key/foreign key relationship between a supertype/subtype. There is no link between the supertype/subtype entities. The supertype primary key is assigned to each subtype. The subtype primary key is assigned to each supertype. There is no primary key/foreign key relationship between a supertype/subtype. There is no link between the supertype/subtype entities. ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side. True False True False ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design The relational model consists of: data redundancy. data in the form of tables. unorganized data. operations using non-SQL languages. data redundancy. data in the form of tables. unorganized data. operations using non-SQL languages. ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design A primary key is which of the following? An attribute that uniquely identifies each row A derived attribute Any attribute An attribute that uniquely identifies each column An attribute that uniquely identifies each row A derived attribute Any attribute An attribute that uniquely identifies each column ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS