Discussion
Home ‣ Database ‣ The Relational Model and Normalization Comments
- Question
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.
- Correct Answer
- referential integrity constraint.
- 1. A functional dependency is a relationship between or among:
Options- A. tables.
- B. rows.
- C. relations.
- D. attributes. Discuss
- 2. 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
- 3. 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
- 4. Table is synonymous with the term:
Options- A. record.
- B. relation.
- C. column.
- D. field. Discuss
- 5. 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
- 6. 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
- 7. 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
- 8. 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
- 9. In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
Options- A. parent
- B. child
- C. instance
- D. subtype Discuss
- 10. Properties that describe the characteristics of entities are called:
Options- A. entities.
- B. attributes.
- C. identifiers.
- D. relationships. Discuss
The Relational Model and Normalization problems
Search Results
Correct Answer: attributes.
Correct Answer: The columns must be ordered.
Correct Answer: modification anomalies.
Correct Answer: relation.
Correct Answer: foreign keys.
Correct Answer: Primary keys
Correct Answer: Archetype entity
Correct Answer: One-to-Many Relationship
Correct Answer: parent
Correct Answer: attributes.
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.