to Answer Homework of Chapter 3 CIS4271/CIS6274 Fall Quarter 2007 MULTIPLE CHOICE: Choose the one alternative that best completes the statement or answers the
question. 1. ( D ) The common types of entities are: A) strong entities. B) weak entities. 2.
C) D)
associative entities. all of the above.
( C ) Which of the following is NOT a characteristic of a good business rule? A) Declarative C) Inconsistent B) Atomic D) Expressible ( D ) Which of the following is NOT a good characteristic of a data name? A) Relates to business characteristics B) Readable C) Repeatable D) Relates to a technical characteristic of the system ( D ) Which of the following is an entity type on which a strong entity depends? A) Owner C) Attribute B) Member D) None of the above ( B ) The following figure shows an example of:
3.
4.
5.
Figure tb31 A) B) C) D) a one-to-many relationship. a strong entity and its associated weak entity. a co-dependent relationship. a double-walled relationship.
6. ( B ) A(n) _____ is the relationship between a weak entity type and its owner. A) member chain B) identifying relationship C) jump path D) chain link 7. ( A ) A person's name, birthday, and social security number are all examples of : A) attributes. C) relationships. B) entities. D) descriptors. ( A ) The following figure shows an example of:
8.
Figure tb32
A) B) a composite attribute. a relational attribute.
C) D)
a derived attribute. a multivalued attribute.
Figure tb33 9. ( C ) In Figure tb33, which attribute is multivalued? A) Years_Employed B) Employee_ID
C) D)
Skill Address
10. ( A ) In Figure tb33, which attribute is derived? A) Years_Employed B) Employee_ID C) Skill D) Address
11. ( D ) Which of the following conditions should exist if an associative entity is to be created? A) All the relationships for the participating entities are many-to-many. B) The new associative entity has independent meaning. C) The new associative entity participates in independent relationships. D) All of the above.
12. ( D ) A relationship between the instances of a single entity type is called a(n) _____ relationship. A) ternary B) primary C) binary D) unary
13. ( B ) A student can attend five classes, each with a different professor. The relationship of students to professors is a _____ relationship. A) one-to-one B) many-to-many C) one-to-many D) strong 14. ( C ) In the following diagram, what type of relationship is depicted?
Each professor has 30 students.
Figure tb34 A) B) C) D) Unary Binary Ternary Quad
15. ( D ) In the following diagram, which is true?
Figure tb35 B) A) C) D) It depicts a unary relationship. It depicts a many-to-many relationship. There is an associative entity. All of the above.
16. ( A ) In the figure shown below, which of the following is true?
Figure tb36 A) B) C) D) A person can marry at most one person. A person has to be married. A person can marry more than one person, but that person can only be married to one person. A person can marry more than one person.
17. ( D ) A relationship where the minimum and maximum cardinality are both one is a(n) _____ relationship. A) optional B) unidirectional
C) D)
mandatory link mandatory one
18. ( C ) For the relationship represented in the figure below, which of the following is true?
A) B) C) D)
An employee can work in more than one department but does not have to work for any department. A department must have at least one employee. A department can have more than one employee. An employee has to work for more than one department.
19. ( A ) In the figure shown below, which of the following business rules would apply?
A) B) C) D)
Each vendor can supply many parts to any number of warehouses, but need not supply any parts. Each part must be supplied by exactly one vendor to any number of warehouses. Each warehouse can be supplied with any number of parts from more than one vendor, and each warehouse could be supplied with no parts. None of the above.
20. ( A ) In the following diagram, which answer is true?
Figure tb310
A) B) C) D)
Each employee can supervise one to many employees. Each employee can manage many departments. Each employee works in more than one department. All of the above.
21. ( B ) A mutually exclusive relationship is one in which: A) an entity instance can participate in many different relationships. B) an entity instance can participate in only one of several alternative relationships. C) an entity instance can not participate in a relationship with another entity instance. D) none of the above.
TRUE/FALSE: Write `T' if the statement is true and `F' if the statement is false. 22. ( F ) An example of a term would be the following sentence: "A student registers for a course."
Figure tb311
23. ( F ) In Figure tb311, one might want to create a single-attribute surrogate identifier to substitute for the composite identifier. SHORT ANSWER: Write the word or phrase that best completes each statement or answers the question. 24. A _STRUCTURAL ASSERTION_ is considered a type of business rule and is an explanation of a term. 25. The _PARTICIPATION_ in a relationship may be optional or mandatory.