1.When looking into the extended entity relationship model (EERM), which of the following statements is not valid about entity supertypes and subtypes?
A) The entity subtype contains common characteristics.
2. In an extended entity relationship, which of the following statements is not valid about inheritance?
A) Inheriting the relationships of their supertypes means subtypes cannot have relationships of their own.
3. In the extended entity-relationship model (EERM), which of the following statements best describes the completeness constraint?
A) The completeness constraint specifies whether each entity supertype occurrence must also be a member of at least one subtype.
4. Which of the following statements is not valid when describing entity clustering?
A) An entity cluster is a permanent entity used to represent multiple entities and relationships, intended to simplify the ERD, and thus enhance its readability.
5. Which of the following statements best describes the essential characteristic of an entity’s primary key?
A) The main function of the primary key is to guarantee entity integrity, not to “describe” the entity.
6. The primary key is possibly the most essential characteristic of an entity; which of the following is not a desirable characteristic of a primary key?
A) Intelligent
7. What primary key is created by the database designer to simplify the identification of entity instances?
A) A surrogate key
8. Identify the statement that best defines time-variant data.
A) Time-variant data refers to data that changes over time; its history of data changes must be maintained.
9. Which statement from the following describes specialization and generalization?
A) Specialization is the top-down process of identifying lower-level, more specific entity subtypes from a higher-level entity supertype. Generalization is the bottom-up process of identifying a higher-level, more generic entity supertype from lower-level entity subtypes.
10. Which of the following statements describe a fan trap in ERD design?
A) A fan trap occurs when there is one entity in two 1:M relationships to other entities.