Logical Database Design When mapping a supertype/subtype relationship which of the following is true? 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. 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. 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
Logical Database Design A synonym is two or more attributes that have different names but the same meaning. False True False True ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design A relation has which of the following properties? Each row is not unique. Attributes can have the same name within a given table. Each relation has a unique name. The order of the columns is significant. Each row is not unique. Attributes can have the same name within a given table. Each relation has a unique name. The order of the columns is significant. ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design A primary key is which of the following? A derived attribute An attribute that uniquely identifies each column An attribute that uniquely identifies each row Any attribute A derived attribute An attribute that uniquely identifies each column An attribute that uniquely identifies each row Any attribute 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. False True False True ANSWER DOWNLOAD EXAMIANS APP