question

1. The set of possible values for an attribute is a ____. a. set b. domain c. key d. range

answer

b. domain

question

2. In an ER diagram identifiers are indicated by ____. a. underlining b. bolding c. special font d. italics

answer

a. underlining

question

3. Which 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 and CLASS_SECTION b. CRS_CODE c. CLASS_SECTION d. there is no primary key

answer

a. CRS_CODE and CLASS_SECTION

question

4. What is the ideal number of attributes used to make up a primary key? a. 0 b. 1 c. 2 d. 6

answer

b. 1

question

5. A ____ identifier is a key that is composed of more than one attribute. a. composite b. primary c. domain d. foreign

answer

a. composite

question

6. A ____ attribute is an attribute that cannot be subdivided. a. defined b. simple c. grouped d. complex

answer

b. simple

question

7. A ____ attribute is an attribute that can have only one value. a. single-valued b. composite c. multivalued d. simple

answer

a. single-valued

question

8. ____ attributes are attributes that can have several values. a. Single-valued b. Composite c. Multivalued d. Simple

answer

c. Multivalued

question

9. Which of the following might be represented with a multivalued attribute? a. bank account balance b. person's name c. book title d. person's educational background

answer

d. person's educational background (more than one degree for instance)

question

10. Which of the following might be represented with a single-valued attribute? a. employee's educational background b. person's phone number(s) c. a serial number d. car's color

answer

c. a serial number

question

11. What type of attribute should not be implemented in a RDBMS? a. simple b. derived c. composite d. multivalued

answer

d. multivalued

question

12. The preferred way to represent multivalued attributes in a DBMS is to create a new entity composed of the original multivalued attribute's components in a(n) ____ relationship with the original entity. a. 1:M b. M:N c. weak d. 1:1

answer

a. 1:M

question

13. A derived attribute ____. a. has many values b. must be stored physically within the database c. must be based on the value of three or more attributes d. need not be physically stored within the database

answer

d. need not be physically stored within the database

question

14. Which of the following should be a derived attribute? a. person's social security number b. person's name c. person's phone number d. person's age

answer

d. person's age

question

15. How is a derived attribute indicated in the Chen model? a. circle b. single line c. double line d. dashed line

answer

d. dashed line

question

16. A relationship is an association between ____. a. databases b. objects c. fields d. entities

answer

d. entities

question

17. In the ERD, cardinality is indicated using the ____ format. a. [min ... max] b. (max, min) c. {min|max} d. (min, max)

answer

d. (min, max)

question

18. Cardinality expresses ____ number of entity occurrences associated with one occurrence of the related entity. a. an infinite b. an undetermined c. a programmed d. the minimum and maximum

answer

d. the minimum and maximum

question

19. Knowing the ____ number of entity occurrences is very useful at the application software level. a. exact b. maximum c. maximum and minimum d. minimum

answer

c. maximum and minimum

question

20. If an entity's existence depends on the existence of one or more other entities it is said to be ____-dependent. a. business b. existence c. weak d. relationship

answer

b. existence

question

21. If an entity can exist apart from one or more related entities, it is said to be ____-independent. a. business b. existence c. weak d. relationship

answer

b. existence

question

22. Connectivities and cardinalities are established by very concise statements known as ____. a. derived attributes b. business rules c. relationships d. assertions

answer

b. business rules

question

23. Another word for an existence-independent entity is a ____ entity. a. unary b. weak c. strong d. solitary

answer

c. strong

question

24. A(n) ____ relationship is also known as a non-identifying relationship. a. direct b. strong c. indirect d. weak

answer

d. weak

question

25. When the PK of a related entity does not contain a PK component of the parent entity, the relationship is ____. a. strong b. missing c. neutral d. weak

answer

d. weak

question

26. A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship. a. business b. strong c. relationship d. weak

answer

d. weak

question

27. The Crow's Foot model depicts the strong (identifying) relationship with a ____ line between the entities. a. dotted b. solid c. bold d. dashed

answer

b. solid

question

28. When loading data into two entities with a 1:M relationship, how should the data be loaded? a. if the relationship is strong the 1 side must be loaded first, if the relationship is weak, the M side must be loaded first b. the 1 side must be loaded first c. the order is irrelevant d. the M side must be loaded first

answer

b. the 1 side must be loaded first

question

29. Remember that the nature of the relationship is often determined by the ____, who must use professional judgment to determine which relationship type and strength best suit the database transaction, efficiency, and information requirements. a. end user b. RDBMS c. database designer d. ERD

answer

c. database designer

question

30. A(n) ____ entity is existence-dependent. a. undefined b. strong c. related d. weak

answer

d. weak

question

31. The term ____ is used to label any condition in which one or more optional relationships exist. a. cardinality b. participation c. connectivity d. optionality

answer

d. optionality

question

32. ____ participation means that one entity occurrence does not require a corresponding entity occurrence in a particular relationship. a. Optional b. Dependent c. Indirect d. Required

answer

a. Optional

question

33. If no ____ symbol is depicted with an entity, the entity exists in a mandatory relationship with the related entity. a. directional b. optionality c. strength d. cardinality

answer

b. optionality

question

34. Suppose that Tiny College offers several courses; each course has several classes. It is possible for the department to create the entity COURSE first and then create the CLASS entity after making the teaching assignments. In this case, what cardinality will appear for CLASS in the ERD? a. (0,1) b. (1,1) c. (0,N) d. (1,N)

answer

c. (0,N)

question

35. What cardinality is indicated by the Crow's Foot symbol that contains a line beside a crow's foot shape? a. (0,1) b. (1,1) c. (0,N) d. (1,N)

answer

d. (1,N)

question

36. A ____ relationship exists when an association is maintained within a single entity. a. binary b. unary c. weak d. ternary

answer

b. unary

question

37. A ____ relationship exists when two entities are associated. a. ternary b. unary c. weak d. binary

answer

d. binary

question

38. A ____ relationship exists when three entities are associated. a. ternary b. unary c. weak d. binary

answer

a. ternary

question

39. A ____ relationship is one in which a relationship can exist between occurrences of the same entity set. a. strong b. recursive c. weak d. dependent

answer

b. recursive

question

40. A ____ entity is composed of the primary keys of each of the entities to be connected. a. unary b. associative c. binary d. composite

answer

b. associative

question

41. The bridge entity is also known as a ____ entity. a. strong b. unary c. composite d. weak

answer

c. composite

question

42. In the Crow's Foot model, the composite entity is identified by the ____ relationship line between the parent and child entities. a. dashed b. solid c. yellow d. dotted

answer

b. solid

question

43. The process of database design is ____. a. iterative b. optional c. linear d. sequential

answer

a. iterative

question

44. Which ERD design activity comes first? 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.

answer

b. Create a detailed narrative of the organization's description of operations.

question

45. The existence of 1:1 relationships often indicates a misidentification of attributes as ____. a. optionalities b. cardinalities c. entities d. relationships

answer

c. entities

question

46. A ____ attribute is an attribute that can be further subdivided to yield additional attributes. a. single-valued b. composite c. multivalued d. simple

answer

b. composite

question

47. A database design must conform to ____ standards. a. ERD b. organizational c. notation d. design

answer

d. design

question

48. The database may have to sacrifice some of its "clean" design structures and/or some of its high transaction speed to ensure ____. a. space requirements b. uniqueness c. maximum information generation d. transaction requirements

answer

c. maximum information generation

DBMS Chapter 4 – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards