CHAPTER 2

Question 1

The intent of a business rule is to break down business structure.

Answer 1

False

Question 2

The total quiz points for a student for an entire semester is a(n) ________ attribute.

Answer 2

derived

Question 3

A relationship instance is an association between entity instances where each relationship instance includes exactly one entity from each participating entity type.

Answer 3

False

Question 4

A good data definition will describe all of the characteristics of a data object EXCEPT:

Answer 4

who can delete the data.

Question 5

Enforcement of business rules can be automated through the use of software that can interpret the rules and enforce them.

Answer 5

True

Question 6

The E-R model is used to construct a conceptual model.

Answer 6

True

Question 7

A simple attribute can be broken down into smaller pieces.

Answer 7

False

Question 8

It is not permissible to associate attributes with relationships.

Answer 8

False

Question 9

In an E-R diagram, there are/is ________ business rule(s) for every relationship.

Answer 9

Two

Question 10

Data modeling is about documenting rules and policies of an organization that govern data.

Answer 10

True

Question 11

A ________ specifies the number of instances of one entity that can be associated with each instance of another entity.

Answer 11

cardinality constraint

Question 12

A(n) ________ is the relationship between a weak entity type and its owner.

Answer 12

identifying relationship

Question 13

Customers, cars, and parts are examples of:

Answer 13

entities.

Question 14

The name used for an entity type should never be the same in other E-R diagrams on which the entity appears.

Answer 14

False

Question 15

In an E-R diagram, strong entities are represented by double-walled rectangles.

Answer 15

False

Question 16

A mutually exclusive relationship is one in which:

Answer 16

an entity instance can participate in only one of several alternative relationships.

Question 17

Data modeling may be the most important part of the systems development process because:

Answer 17

data characteristics are important in the design of programs and other systems components.

Question 18

An attribute that must be present for every entity (or relationship) instance is a(n):

Answer 18

required attribute.

Question 19

Which of the following criteria should be considered when selecting an identifier?

Answer 19

Choose an identifier that doesn’t have large composite attributes.

Question 20

In an E-R diagram, strong entities are represented by double-walled rectangles.

Answer 20

False- Weak Entity

Question 21

The relationship between the instances of two entity types is called a binary relationship.

Answer 21

True

Question 22

Some examples of attributes are: eye_color, weight, student_id, STUDENT.

Answer 22

False

Question 23

Enforcement of business rules can be automated through the use of software that can interpret the rules and enforce them.

Answer 23

True

Question 24

A ________ defines or constrains some aspect of the business.

Answer 24

business rule

Question 25

A multivalued attribute may take on more than one value for a particular entity instance.

Answer 25

True

Question 26

A customer can order many items, and an item can be ordered by many customers is an example of a recursive relationship.

Answer 26

True

Question 27

Most systems developers believe that data modeling is the least important part of the systems development process.

Answer 27

False

Question 28

The total quiz points for a student for an entire semester is a(n) ________ attribute.

Answer 28

derived

Question 29

A simultaneous relationship among the instances of three entity types is called a ________ relationship.

Answer 29

ternary

Question 30

A relationship between the instances of a single entity type is called a ________ relationship.

Answer 30

unary

Question 31

Data names do not have to be unique.

Answer 31

False

Question 32

One reason to use an associative entity is if the associative entity has one or more attributes in addition to the identifier.

Answer 32

True

Question 33

A business rule is a statement of how a policy is enforced or conducted.

Answer 33

False

Question 34

Relationships represent action being taken using a verb phrase.

Answer 34

True

Question 35

A single occurrence of an entity type is called an entity instance.

Answer 35

True

Question 36

The purpose of data modeling is to document business rules about processes.

Answer 36

False

Question 37

The logical representation of an organization's data is called a(n):

Answer 37

entity-relationship model.

Question 38

A value that indicates the date or time of a data value is called a:

Answer 38

time stamp

Question 39

Which of the following is an entity that exists independently of other entity types?

Answer 39

Strong

Question 40

A simple attribute can be broken down into smaller pieces.

Answer 40

False

Question 41

In an E-R diagram, an associative entity is represented by a rounded rectangle.

Answer 41

True

Question 42

The relationship between a weak entity type and its owner is an identifying relationship.

Answer 42

True

Question 43

A relationship instance is an association between entity instances where each relationship instance includes exactly one entity from each participating entity type.

Answer 43

False

Question 44

Business rules are formulated from a collection of business ramblings.

Answer 44

False

Question 45

The number of entity types that participate in a Unary relationship is:

Answer 45

one

Question 46

The total quiz points for a student for an entire semester is a(n) ________ attribute.

Answer 46

derived

Question 47

Customers, cars, and parts are examples of:

Answer 47

entities

Question 48

The E-R model is used to construct a conceptual model.

Answer 48

True

Question 49

A customer can order many items, and an item can be ordered by many customers is an example of a recursive relationship.

Answer 49

False

Question 50

The logical representation of an organization's data is called a(n):

Answer 50

entity-relationship model.

Question 51

A relationship between the instances of a single entity type is called a ________ relationship.

Answer 51

unary

Question 52

An attribute whose values can be calculated from related attribute values is called a derived attribute.

Answer 52

True

Question 53

An entity type name should be all of the following EXCEPT:

Answer 53

as short as possible

Question 54

Which of the following is NOT a good characteristic of a data name?

Answer 54

Relates to a technical characteristic of the system

Question 55

A relationship where the minimum and maximum cardinality are both one is a(n) ________ relationship.

Answer 55

mandatory one

Question 56

When choosing an identifier, choose one that will not change its value often.

Answer 56

True

Question 57

A good data definition is always accompanied by diagrams, such as the entity-relationship diagram.

Answer 57

True