Logical Database Design A relation has which of the following properties? The order of the columns is significant. Each relation has a unique name. Each row is not unique. Attributes can have the same name within a given table. The order of the columns is significant. Each relation has a unique name. Each row is not unique. Attributes can have the same name within a given table. ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design A foreign key is which of the following? Any attribute The same thing as a primary key An attribute that serves as the primary key of another relation An attribute that serves no purpose Any attribute The same thing as a primary key An attribute that serves as the primary key of another relation An attribute that serves no purpose 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. Four relations are created. Two relations are created. Three relations are created. One relation is created. Four relations are created. Two relations are created. 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 When mapping a supertype/subtype relationship which of the following is true? There is no link between the supertype/subtype entities. There is no primary key/foreign key relationship between a supertype/subtype. The supertype primary key is assigned to each subtype. The subtype primary key is assigned to each supertype. There is no link between the supertype/subtype entities. There is no primary key/foreign key relationship between a supertype/subtype. The supertype primary key is assigned to each subtype. The subtype primary key is assigned to each supertype. 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
EXAMIANS