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