Data Modeling with ER Model problems
- 1. 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
Correct Answer: Primary keys
- 2. 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
Correct Answer: Archetype entity
- 3. 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
Correct Answer: One-to-Many Relationship
- 4. 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
Correct Answer: parent
- 5. Properties that describe the characteristics of entities are called:
Options- A. entities.
- B. attributes.
- C. identifiers.
- D. relationships. Discuss
Correct Answer: attributes.
- 6. 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
Correct Answer: Many-to-Many Relationship
- 7. Entities of a given type are grouped into a(n):
Options- A. database.
- B. entity class.
- C. attribute.
- D. ERD. Discuss
Correct Answer: entity class.
- 8. Which type of entity represents an actual occurrence of an associated generalized entity?
Options- A. Supertype entity
- B. Subtype entity
- C. Archetype entity
- D. Instance entity Discuss
Correct Answer: Instance entity
- 9. A recursive relationship is a relationship between an entity and ________ .
Options- A. itself
- B. a subtype entity
- C. an archetype entity
- D. an instance entity Discuss
Correct Answer: itself
- 10. Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?
Options- A. Supertype entity
- B. Subtype entity
- C. Archetype entity
- D. Instance entity Discuss
Correct Answer: Supertype entity
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.