➨ Database The Realtional Model And Normalisation

1. 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:

A. A → B. B. A → C. C. A → (B,C). D. (B,C) → A. - Answer&Explanation Answer:Option A Explanation : No answer description available for this question. View Answer

2. The different classes of relations created by the technique for preventing modification anomalies are called:

A. normal forms B. referential integrity constraints. C. functional dependencies. D. None of the above is correct. - Answer&Explanation Answer:Option A Explanation : No answer description available for this question. View Answer

3. A relation is in this form if it is in BCNF and has no multivalued dependencies:

A. second normal form. B. third normal form. C. fourth normal form. D. domain/key normal form. - Answer&Explanation Answer:Option C Explanation : View Answer

4. Row is synonymous with the term:

A. record. B. relation C. column. D. field. - Answer&Explanation Answer:Option A Explanation : No answer description available for this question. View Answer

5. The primary key is selected from the:

A. composite keys. B. determinants. C. candidate keys D. foreign keys. - Answer&Explanation Answer:Option C Explanation : No answer description available for this question View Answer

6. Which of the following is a group of one or more attributes that uniquely identifies a row?

A. Key B. Determinant C. Tuple D. Relation - Answer&Explanation Answer:Option A Explanation : No answer description available for this question View Answer

7. 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):

A. transitive dependency. B. insertion anomaly. C. referential integrity constraint D. normal form. - Answer&Explanation Answer:Option C Explanation : No answer description available for this question View Answer

8. A relation is considered a:

A. Column. B. one-dimensional table. C. two-dimensional table. D. three-dimensional table. - Answer&Explanation Answer:Option C Explanation : No answer description available for this question. View Answer

9. In the relational model, relationships between relations or tables are created by using:

A. composite keys. B. determinants. C. candidate keys. D. foreign keys. - Answer&Explanation Answer:Option D Explanation : No answer description available for this question. View Answer

10. A functional dependency is a relationship between or among:

A. tables. B. rows. C. relations. D. attributes. - Answer&Explanation Answer:Option D Explanation : No answer description available for this question. View Answer