A. True B. False Question 35 The ____ attribute(s) make up the primary key in the table definition: CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM) A. CRS_CODE B. CLASS_SECTION C. CRS_CODE and CLASS_SECTION D. There is no primary key Question 36 ____ attributes can have many values. A. Composite B. Simple C. Single-valued D. Multivalued Question 37 The Crow’s Foot model is less implementation-oriented than the Chen model. A. True B. False Question 38 The associative entity is also known as a ____ entity. A. unary B. weak C. strong D. composite Question 39 Connectivities and cardinalities are established by business rules. A. True B. False
Question 40 A ____ attribute can be further subdivided to yield additional attributes. A. composite B. simple C. single-valued D. multivalued Question 41 The word “entity” in the ER model corresponds to a table. A. True B. False Question 42 A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship. A. True B. False Question 43 Ideally, an entity identifier is composed of ____ attribute(s). A. zero B. one C. two D. six Question 44 In the original Chen model, each attribute is represented using an oval with the attribute name connected to the entity with a line. A. True B. False Question 45 Knowing the ____ number of entity occurrences is very helpful at the application software level. A. maximum B. minimum C. approximate D. maximum and minimum Question 46 The term “____” is used to label any condition in which one or more optional relationships exist. A. participation B. optionality C. cardinality D. connectivity Question 47 When the PK of one entity does not contain the PK of a related entity, the relationship is ____. A. missing B. weak C. strong D. neutral Question 48 Attributes have a domain that specifies the data type of the attribute.
A. True B. False Question 49 In both the Chen and Crow’s Foot models, an entity is represented with a rectangle containing the entity’s name. A. True B. False Question 50 The following step occurs first in the process of building an ERD: ____. A. Develop the initial ERD. B. Create a detailed narrative of the organization’s description of operations. C. Identify the attributes and primary keys that adequately describe the entities. D. Identify the business rules based on the description of operations. Question 51 A ____ relationship exists when three entities are associated. A. unary B. binary C. ternary D. weak Question 52 The set of possible values for an attribute is a ____. A. domain B. range C. set D. key Question 53 Although the conceptual model can handle ____ relationships and multivalued attributes, you should not implement them in the RDBMS. A. 1:1 B. M:N C. 1:M D. 1:N Question 54 Attributes are types of entities. A. True B. False Question 55 Software vendors have adopted the Chen representation because of its compact representation.
You've reached the end of your free preview.
Want to read all 67 pages?
- Spring '19