A null value is assigned when no other value applies.
Select an option to see the answer and solution.
Database · all questionsLogical Database Design
Logical Database Design
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
30
Questions
2/2
Page
Pick an option on a question to see the right answer and solution.
A synonym is two or more attributes that have different names but the same meaning.
Select an option to see the answer and solution.
The primary key in a relation does not need to be underlined.
Select an option to see the answer and solution.
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.
Select an option to see the answer and solution.
Normalization is a formal process for deciding which attributes should be grouped together in a relation.
Select an option to see the answer and solution.
A candidate key must uniquely identify each row.
Select an option to see the answer and solution.
Well-structured relations encourage anomalies of data.
Select an option to see the answer and solution.
A foreign key may be null and still adhere to the referential integrity constraint.
Select an option to see the answer and solution.
If a relation is in third normal form, it does not need to be in second normal form.
Select an option to see the answer and solution.
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.
Select an option to see the answer and solution.