1. 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?   Uses CPU processing cycles
2. 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?  Uses CPU processing cycles
3. A relationship degree indicates the number of entities or participants associated with a relationship. Which is not a valid relationship that’s specifically named?   Quarterly relationship
4. A relationship degree indicates the number of entities or participants associated with a relationship. Which is not a valid relationship that’s specifically named?  Quarterly relationship
5. Database designers must often compromise design due to conflicting goals. What are examples of contradictory goals in database design?  Design standards, processing speed, and information requirements
6. Database designers must often compromise design due to conflicting goals. What are examples of contradictory goals in database design?   Design standards, processing speed, and information requirements
7. In an entity relationship model (ERM), attributes are characteristics of entities. Which of the following statements best describe an optional attribute?   An optional attribute is an attribute that does not require a value and can be left empty.
8. In an entity-relationship model (ERM), attributes are characteristics of entities. Which of the following statements best describes an optional attribute   An optional attribute is an attribute that does not require a value and can be left empty.
9. 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?   Single-valued attribute
10. 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?  Multivalued attribute
11. What element expresses the specific number of entity occurrences associated with an occurrence of a related entity?  Cardinality
12. What element expresses the specific number of entity occurrences associated with an occurrence of a related entity?   Cardinality
13. What type of attribute allows for no more than one value?  Single-valued attribute
14. What type of attribute allows for no more than one value?  Single-valued attribute
15. What type of entity can exist in the database only when it is associated with another related entity?   Existence-dependent
16. What type of entity can exist in the database only when it is associated with another related entity?   Existence-dependent
17. When working with entity relationship models (ERM), which of the following is not a valid statement regarding an entity?   In the Chen, Crow’s Foot, and UML notations, an entity is represented by a rectangle that contains the entity name.
18. When working with entity-relationship models (ERM), which of the following is not a valid statement regarding an entity?   An entity is an object of interest to the end designer.
19. While a relationship degree indicates the number of entities associated with a relationship, which relationship type is within a single entity type?  Recursive relationship
20. While a relationship degree indicates the number of entities associated with a relationship, which relationship type is within a single entity type?   Recursive relationship (aka unary)

Other Links:

Statistics Quiz

Networking Quiz

See other websites for quiz:

Check on QUIZLET

Check on CHEGG