Discussion
Home ‣ Database ‣ The Relational Model and Normalization Comments
- Question
The primary key is selected from the:
Options- A. composite keys.
- B. determinants.
- C. candidate keys.
- D. foreign keys.
- Correct Answer
- candidate keys.
- 1. 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
- 2. 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
- 3. 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
- 4. 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
- 5. 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
- 6. In the relational model, relationships between relations or tables are created by using:
Options- A. composite keys.
- B. determinants.
- C. candidate keys.
- D. foreign keys. Discuss
- 7. Table is synonymous with the term:
Options- A. record.
- B. relation.
- C. column.
- D. field. Discuss
- 8. For some relations, changing the data can have undesirable consequences called:
Options- A. referential integrity constraints.
- B. modification anomalies.
- C. normal forms.
- D. transitive dependencies. Discuss
- 9. Which of the following is not a restriction for a table to be a relation?
Options- A. The cells of the table must contain a single value.
- B. All of the entries in any column must be of the same kind.
- C. The columns must be ordered.
- D. No two rows in a table may be identical. Discuss
- 10. A functional dependency is a relationship between or among:
Options- A. tables.
- B. rows.
- C. relations.
- D. attributes. Discuss
The Relational Model and Normalization problems
Search Results
Correct Answer: (A,B) is a composite determinant.
Correct Answer: column of a table.
Correct Answer: identifies a row.
Correct Answer: Key
Correct Answer: A ? B.
Correct Answer: foreign keys.
Correct Answer: relation.
Correct Answer: modification anomalies.
Correct Answer: The columns must be ordered.
Correct Answer: attributes.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.