1. When working with entity relationship models (ERM), which of the following is not a valid statement regarding an entity?
A) An entity is an object of interest to the end designer.
2. In an entity relationship model (ERM), attributes are characteristics of entities. Which of the following statements best describe an optional attribute?
A) An optional attribute is an attribute that does not require a value and can be left empty.
3. What type of attribute allows for no more than one value?
A) Single-valued attribute
4. The CUSTOMER entity includes the attributes CUST_LNAME, CUST_FNAME, CUST_PHONE, and CUST_PHONE_TYPE. The CUST_PHONE_TYPE attribute stores the string “HOME, WORK, MOBILE, OTHER”. Which term best describes CUST_PHONE_TYPE?
A) Single-valued attribute
5. A derived attribute is an attribute whose value is calculated (derived) from other attributes. What is not an advantage of storing derived attributes in the database?
A) Uses CPU processing cycles
6. What type of entity can exist in the database only when it is associated with another related entity?
A) Existence-dependent
7. What element expresses the specific number of entity occurrences associated with an occurrence of a related entity?
A) Cardinality
8. A relationship degree indicates the number of entities or participants associated with a relationship. Which is not a valid relationship that’s specifically named?
A) Quarterly relationship
9. Database designers must often compromise design due to conflicting goals. What are examples of contradictory goals in database design?
A) Design standards, processing speed, and information requirements
10. While a relationship degree indicates the number of entities associated with a relationship, which relationship type is within a single entity type?
A) Recursive relationship