Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
Select an option to see the answer and solution.
Database · all questionsThe Relational Model and Normalization
The Relational Model and Normalization
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
44
Questions
1/3
Page
Pick an option on a question to see the right answer and solution.
The different classes of relations created by the technique for preventing modification anomalies are called:
Select an option to see the answer and solution.
A relation is in this form if it is in BCNF and has no multivalued dependencies:
Select an option to see the answer and solution.
Row is synonymous with the term:
Select an option to see the answer and solution.
The primary key is selected from the:
Select an option to see the answer and solution.
Which of the following is a group of one or more attributes that uniquely identifies a row?
Select an option to see the answer and solution.
When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Select an option to see the answer and solution.
A relation is considered a:
Select an option to see the answer and solution.
In the relational model, relationships between relations or tables are created by using:
Select an option to see the answer and solution.
A functional dependency is a relationship between or among:
Select an option to see the answer and solution.
Table is synonymous with the term:
Select an option to see the answer and solution.
Which of the following is not a restriction for a table to be a relation?
Select an option to see the answer and solution.
For some relations, changing the data can have undesirable consequences called:
Select an option to see the answer and solution.
A key:
Select an option to see the answer and solution.
An attribute is a(n):
Select an option to see the answer and solution.
A relation in this form is free of all modification anomalies.
Select an option to see the answer and solution.
If attributes A and B determine attribute C, then it is also true that:
Select an option to see the answer and solution.
A tuple is a(n):
Select an option to see the answer and solution.
If attribute A determines both attributes B and C, then it is also true that:
Select an option to see the answer and solution.
One solution to the multivalued dependency constraint problem is to:
Select an option to see the answer and solution.