Logical Database Design MCQs with Explanations

no primary key attribute may be null. is the correct answer to “The entity integrity rule states that:”. This question is standard in competitive examination syllabi for Logical Database Design.

Two relations are created. is the correct answer to “When mapping a many-to-many unary relationship into a relation which of the following is true”. This question is standard in competitive examination syllabi for Logical Database Design.

Second normal form is the correct answer to “If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form”. This question is standard in competitive examination syllabi for Logical Database Design.

An attribute that serves as the primary key of another relation is the correct answer to “A foreign key is which of the following”. This question is standard in competitive examination syllabi for Logical Database Design.

A functional dependency between two or more nonkey attributes. is the correct answer to “A transitive dependency is which of the following”. This question is standard in competitive examination syllabi for Logical Database Design.

Two relations are created. is the correct answer to “When mapping a multivalued attribute into a relation which of the following is true”. This question is standard in competitive examination syllabi for Logical Database Design.

Second normal form is the correct answer to “If no multivalued attributes exist in a relation, then the relation is in what normal form”. This question is standard in competitive examination syllabi for Logical Database Design.

An attribute that uniquely identifies each row is the correct answer to “A primary key is which of the following”. This question is standard in competitive examination syllabi for Logical Database Design.

data in the form of tables. is the correct answer to “The relational model consists of:”. This question is standard in competitive examination syllabi for Logical Database Design.

Three relations are created. is the correct answer to “When mapping a binary many-to-many relationship into a relation which of the following is true”. This question is standard in competitive examination syllabi for Logical Database Design.

Each relation has a unique name. is the correct answer to “A relation has which of the following properties”. This question is standard in competitive examination syllabi for Logical Database Design.

Four relations are created. is the correct answer to “When mapping a ternary relationship with an associative entity into a relation which of the following is true”. This question is standard in competitive examination syllabi for Logical Database Design.

One relation is created. is the correct answer to “When mapping a regular entity into a relation which of the following is true”. This question is standard in competitive examination syllabi for Logical Database Design.

The supertype primary key is assigned to each subtype. is the correct answer to “When mapping a supertype/subtype relationship which of the following is true”. This question is standard in competitive examination syllabi for Logical Database Design.

two-dimensional tables. is the correct answer to “Relations are:”. This question is standard in competitive examination syllabi for Logical Database Design.

False is the correct answer to “An enterprise key is a primary key whose value is unique for a given relation.”. This question is standard in competitive examination syllabi for Logical Database Design.

True is the correct answer to “A composite attribute does not get mapped into a relation.”. This question is standard in competitive examination syllabi for Logical Database Design.

False is the correct answer to “Weak entities do not get mapped into a relation.”. This question is standard in competitive examination syllabi for Logical Database Design.

False is the correct answer to “A primary key may be null.”. This question is standard in competitive examination syllabi for Logical Database Design.

True is the correct answer to “A null value is assigned when no other value applies.”. This question is standard in competitive examination syllabi for Logical Database Design.

True is the correct answer to “A synonym is two or more attributes that have different names but the same meaning.”. This question is standard in competitive examination syllabi for Logical Database Design.

False is the correct answer to “The primary key in a relation does not need to be underlined.”. This question is standard in competitive examination syllabi for Logical Database Design.

True is the correct answer to “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.”. This question is standard in competitive examination syllabi for Logical Database Design.

True is the correct answer to “Normalization is a formal process for deciding which attributes should be grouped together in a relation.”. This question is standard in competitive examination syllabi for Logical Database Design.

True is the correct answer to “A candidate key must uniquely identify each row.”. This question is standard in competitive examination syllabi for Logical Database Design.

False is the correct answer to “Well-structured relations encourage anomalies of data.”. This question is standard in competitive examination syllabi for Logical Database Design.

True is the correct answer to “A foreign key may be null and still adhere to the referential integrity constraint.”. This question is standard in competitive examination syllabi for Logical Database Design.

False is the correct answer to “If a relation is in third normal form, it does not need to be in second normal form.”. This question is standard in competitive examination syllabi for Logical Database Design.

True is the correct answer to “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.”. This question is standard in competitive examination syllabi for Logical Database Design.