Discussion
Home ‣ Database ‣ The Relational Model and Normalization Comments
- Question
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.
- Correct Answer
- The columns must be ordered.
- 1. 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
- 2. Table is synonymous with the term:
Options- A. record.
- B. relation.
- C. column.
- D. field. Discuss
- 3. 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
- 4. The primary key is selected from the:
Options- A. composite keys.
- B. determinants.
- C. candidate keys.
- D. foreign keys. Discuss
- 5. 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
- 6. A functional dependency is a relationship between or among:
Options- A. tables.
- B. rows.
- C. relations.
- D. attributes. Discuss
- 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):
Options- A. transitive dependency.
- B. insertion anomaly.
- C. referential integrity constraint.
- D. normal form. Discuss
- 8. Which of the following is NOT a basic element of all versions of the E-R model?
Options- A. Entities
- B. Attributes
- C. Relationships
- D. Primary keys Discuss
- 9. Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?
Options- A. Supertype entity
- B. Subtype entity
- C. Archetype entity
- D. Instance entity Discuss
- 10. In which of the following is a single-entity instance of one type related to many entity instances of another type?
Options- A. One-to-One Relationship
- B. One-to-Many Relationship
- C. Many-to-Many Relationship
- D. Composite Relationship Discuss
The Relational Model and Normalization problems
Search Results
Correct Answer: modification anomalies.
Correct Answer: relation.
Correct Answer: foreign keys.
Correct Answer: candidate keys.
Correct Answer: (A,B) is a composite determinant.
Correct Answer: attributes.
Correct Answer: referential integrity constraint.
Correct Answer: Primary keys
Correct Answer: Archetype entity
Correct Answer: One-to-Many Relationship
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.