Logical Database Design A primary key is which of the following? 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 A derived attribute ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design A relation has which of the following properties? Each row is not unique. The order of the columns is significant. Each relation has a unique name. Attributes can have the same name within a given table. Each row is not unique. The order of the columns is significant. Each relation has a unique name. 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? 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 When mapping a supertype/subtype relationship which of the following is true? The subtype primary key is assigned to each supertype. There is no link between the supertype/subtype entities. The supertype primary key is assigned to each subtype. There is no primary key/foreign key relationship between a supertype/subtype. The subtype primary key is assigned to each supertype. There is no link between the supertype/subtype entities. The supertype primary key is assigned to each subtype. There is no primary key/foreign key relationship between a supertype/subtype. ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design A primary key may be null. True False True False ANSWER DOWNLOAD EXAMIANS APP
Logical Database Design If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form? Second normal form Third normal form Fourth normal form First normal form Second normal form Third normal form Fourth normal form First normal form ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS