Discussion
Home ‣ Database ‣ The Relational Model and Normalization Comments
- Question
A tuple is a(n):
Options- A. column of a table.
- B. two dimensional table.
- C. row of a table.
- D. key of a table.
- Correct Answer
- row of a table.
- 1. If attribute A determines both attributes B and C, then it is also true that:
Options- A. A ? B.
- B. B ? A.
- C. C ? A.
- D. (B,C) ? A. Discuss
- 2. A relation is in this form if it is in BCNF and has no multivalued dependencies:
Options- A. second normal form.
- B. third normal form.
- C. fourth normal form.
- D. domain/key normal form. Discuss
- 3. One solution to the multivalued dependency constraint problem is to:
Options- A. split the relation into two relations, each with a single theme.
- B. change the theme.
- C. create a new theme.
- D. add a composite key. Discuss
- 4. A relation in this form is free of all modification anomalies.
Options- A. First normal form
- B. Second normal form
- C. Third normal form
- D. Domain/key normal form Discuss
- 5. The different classes of relations created by the technique for preventing modification anomalies are called:
Options- A. normal forms.
- B. referential integrity constraints.
- C. functional dependencies.
- D. None of the above is correct. Discuss
- 6. 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:
Options- A. A ? B.
- B. A ? C.
- C. A ? (B,C).
- D. (B,C) ? A. Discuss
- 7. Which of the following is a group of one or more attributes that uniquely identifies a row?
Options- A. Key
- B. Determinant
- C. Tuple
- D. Relation Discuss
- 8. A key:
Options- A. must always be composed of two or more columns.
- B. can only be one column.
- C. identifies a row.
- D. identifies a column. Discuss
- 9. An attribute is a(n):
Options- A. column of a table.
- B. two dimensional table.
- C. row of a table.
- D. key of a table. Discuss
- 10. If attributes A and B determine attribute C, then it is also true that:
Options- A. A ? C.
- B. B ? C.
- C. (A,B) is a composite determinant.
- D. C is a determinant. Discuss
The Relational Model and Normalization problems
Search Results
Correct Answer: A ? B.
Correct Answer: fourth normal form.
Correct Answer: split the relation into two relations, each with a single theme.
Correct Answer: Domain/key normal form
Correct Answer: normal forms.
Correct Answer: A ? B.
Correct Answer: Key
Correct Answer: identifies a row.
Correct Answer: column of a table.
Correct Answer: (A,B) is a composite determinant.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.