Chapter 4 (Multiple Choice CIS 3365)

Question 1

Question

1. The ERD represents the ____ database as viewed by the end user.

Answer

A) condensed
B) physical
C) logical
D) conceptual

Question 2

Question

2. Some ____ database modeling concepts can be expressed only using the Chen notation.

Answer

A) developmental
B) conceptual
C) actual
D) specific

Question 3

Question

3. Attributes may share a ____.

Answer

A) name
B) domain
C) location
D) table

Question 4

Question

4. The set of possible values for an attribute is a ____.

Answer

A) domain
B) range
C) set
D) key

Question 5

Question

5. In an ER diagram, primary keys are indicated by ____.

Answer

A) bolding
B) italics
C) underlining
D) a special font

Question 6

Question

6. Ideally, an entity identifier is composed of ____ attribute(s).

Answer

A) zero
B) one
C) two
D) six

Question 7

Question

7. A ____ identifier is composed of more than one attribute.

Answer

A) primary
B) foreign
C) composite
D) domain

Question 8

Question

8. The ____ attribute(s) make up the primary key in the table definition: CLASS (CRS_CODE, CLASS_SECTION, CLASS_TIME, CLASS_ROOM, PROF_NUM)

Answer

A) CRS_CODE
B) CLASS_SECTION
C) CRS_CODE and CLASS_SECTION
D) There is no primary key

Question 9

Question

9. A ____ attribute can be further subdivided to yield additional attributes.

Answer

A) composite
B) simple
C) single-valued
D) multivalued

Question 10

Question

10. A ____ attribute is one that cannot be subdivided.

Answer

A) composite
B) simple
C) single-valued
D) multivalued

Question 11

Question

11. A ____ attribute can have only one value.

Answer

A) composite
B) simple
C) single-valued
D) multivalued

Question 12

Question

12. ____ attributes can have many values.

Answer

A) composite
B) simple
C) single-valued
D) multivalued

Question 13

Question

13. Some attributes are classified as ____.

Answer

A) simple
B) complex
C) defined
D) grouped

Question 14

Question

14. The ____ type of attribute cannot be created in a DBMS.

Answer

A) derived
B) multivalued
C) simple
D) composite

Question 15

Question

15. A ____ should be a derived attribute.

Answer

A) person's name
B) person's age
C) person's social security number
D) person's phone number

Question 16

Question

16. A derived attribute ____.

Answer

A) must be stored physically within the database
B) need not be physically stored within the database
C) has many values
D) must be based on the value of three or more attributes

Question 17

Question

17. A derived attribute is indicated in the Chen model by a ____.

Answer

A) single line
B) dashed line
C) circle
D) double line

Question 18

Question

18. A relationship is an association between ____.

Answer

A) objects
B) entities
C) databases
D) fields

Question 19

Question

19. Knowing the ____ number of entity occurrences is very helpful at the application software level.

Answer

A) maximum
B) minimum
C) approximate
D) maximum and minimum

Question 20

Question

20. In the ERD, cardinality is indicated using the ____ notation.

Answer

A) (max,min)
B) (min, max)
C) [min ... max]
D) {min\max}

Question 21

Question

21. Another word for existence-independent is ____.

Answer

A) weak
B) alone
C) unary
D) strong

Question 22

Question

22. An entity is said to be ____-dependent if it can exist in the database only when it is associated with another related entity occurrence.

Answer

A) existence
B) relationship
C) business
D) weak

Question 23

Question

23. If an entity can exist apart from one or more related entities, it is said to be ____-independent.

Answer

A) existence
B) relationship
C) business
D) weak

Question 24

Question

24. When the PK of one entity does not contain the PK of a related entity, the relationship is ____.

Answer

A) missing
B) weak
C) strong
D) Neutral

Question 25

Question

25. A ____ entity has a primary key that is partially or totally derived from the parent entity in the relationship.

Answer

A) strong
B) weak
C) business
D) relationship

Question 26

Question

26. The term “____”is used to label any condition in which one or more optional relationships exist.

Answer

A) participation
B) optionality
C) cardinality
D connectivity

Question 27

Question

27. The existence of a(n) ____ relationship indicates that the minimum cardinality is at least 1 for the mandatory entity

Answer

A) mandatory
B) optional
C) multivalued
D) single-valued

Question 28

Question

28. The Crow’s foot symbol with two parallel lines indicates ____ cardinality.

Answer

A) (0,N)
B) (1,N)
C) (1,1)
D) (0,1)

Question 29

Question

29. A ____ relationship exists when an association is maintained within a single entity.

Answer

A) unary
B) ternary
C) binary
D) weak

Question 30

Question

30. A ____ relationship exists when two entities are associated.

Answer

A) unary
B) binary
C) ternary
D) weak

Question 31

Question

31. A ____ relationship exists when three entities are associated.

Answer

A) unary
B) binary
C) ternary
D) weak

Question 32

Question

32. ____ relationships are most common.

Answer

A) unary
B) binary
C) ternary
D) higher-degree

Question 33

Question

33. If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a ____ relationship.

Answer

A) self
B) self-referring
C) looping
D) recursive

Question 34

Question

34. A(n) ____ entity is composed of the primary keys of each of the entities to be connected.

Answer

A) associative
B) recursive
C) unary
D) binary

Question 35

Question

35. The associative entity is also known as a ____ entity.

Answer

A) unary
B) weak
C) strong
D) composite

Question 36

Question

36. The following step occurs first in the process of building an ERD: ____.

Answer

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 37

Question

37. If Tiny College had some departments that were classified as “research only,” they would not offer courses; therefore, the COURSE entity would be ____ to the DEPARTMENT entity

Answer

A) existence-dependent
B) independent
C) weak
D) optional

Question 38

Question

38. The M:N relationship between STUDENT and CLASS must be divided into two 1:M relationships through the use of the ENROLL entity; the ENROLL entity is ____.

Answer

A) weak
B) strong
C) optional
D) mandatory

Question 39

Question

39. If the focus is on data-retrieval speed, you might also be forced to include ____ attributes in the design, which would not ordinarily be done.

Answer

A) multivalued
B) composite
C) weak
D) derived

Question 40

Question

40. Complex ____ requirements may dictate data transformations, and they may expand the number of entities and attributes within the design.

Answer

A) information
B) entity
C) design
D) processing

	Created by . . over 7 years ago

Next up

Chapter 4 (Multiple Choice CIS 3365)

Description

Resource summary

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Question 26

Question 27

Question 28

Question 29

Question 30

Question 31

Question 32

Question 33

Question 34

Question 35

Question 36

Question 37

Question 38

Question 39

Question 40

Similar