Data Modeling with ER Model problems
- 1. Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?
Options- A. Weak entity
- B. Strong entity
- C. ID-dependent entity
- D. ID- independent entity Discuss
Correct Answer: Weak entity
- 2. An attribute that names or identifies entity instances is a(n):
Options- A. entity.
- B. attribute.
- C. identifier.
- D. relationship. Discuss
Correct Answer: identifier.
- 3. Which of the following indicates the maximum number of entities that can be involved in a relationship?
Options- A. Minimum cardinality
- B. Maximum cardinality
- C. ERD
- D. Greater Entity Count (GEC) Discuss
Correct Answer: Maximum cardinality
- 4. Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?
Options- A. Supertype entity
- B. Subtype entity
- C. Archetype entity
- D. Instance entity Discuss
Correct Answer: Subtype entity
- 5. Entities can be associated with one another in which of the following?
Options- A. Entities
- B. Attributes
- C. Identifiers
- D. Relationships Discuss
Correct Answer: Relationships
- 6. Which of the following indicates the minimum number of entities that must be involved in a relationship?
Options- A. Minimum cardinality
- B. Maximum cardinality
- C. ERD
- D. Greater Entity Count (GEC) Discuss
Correct Answer: Minimum cardinality
- 7. Which of the following refers to something that can be identified in the users' work environment, something that the users want to track?
Options- A. Entity
- B. Attribute
- C. Identifier
- D. Relationship Discuss
Correct Answer: Entity
- 8. In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.
Options- A. parent
- B. child
- C. instance
- D. subtype Discuss
Correct Answer: child
- 9. In which of the following is a single-entity instance of one type of related to a single-entity instance 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-One Relationship
- 10. Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?
Options- A. Weak entity
- B. Strong entity
- C. ID-dependent entity
- D. ID-independent entity Discuss
Correct Answer: ID-dependent entity
More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.