Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Database > CHAPTER 2 > Flashcards

CHAPTER 2 Flashcards

1
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

derived

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

who can delete the data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

A simple attribute can be broken down into smaller pieces.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

It is not permissible to associate attributes with relationships.

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

Two

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

cardinality constraint

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

identifying relationship

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Customers, cars, and parts are examples of:

A

entities.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

A mutually exclusive relationship is one in which:

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

required attribute.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A

False- Weak Entity

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

A

False

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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

A

True

24
Q

A ________ defines or constrains some aspect of the business.

A

business rule

25
Q

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

A

True

26
Q

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

A

True

27
Q

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

A

False

28
Q

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

A

derived

29
Q

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

A

ternary

30
Q

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

A

unary

31
Q

Data names do not have to be unique.

A

False

32
Q

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

A

True

33
Q

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

A

False

34
Q

Relationships represent action being taken using a verb phrase.

A

True

35
Q

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

A

True

36
Q

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

A

False

37
Q

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

A

entity-relationship model.

38
Q

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

A

time stamp

39
Q

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

A

Strong

40
Q

A simple attribute can be broken down into smaller pieces.

A

False

41
Q

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

A

True

42
Q

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

A

True

43
Q

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

A

False

44
Q

Business rules are formulated from a collection of business ramblings.

A

False

45
Q

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

A

one

46
Q

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

A

derived

47
Q

Customers, cars, and parts are examples of:

A

entities

48
Q

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

A

True

49
Q

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

A

False

50
Q

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

A

entity-relationship model.

51
Q

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

A

unary

52
Q

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

A

True

53
Q

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

A

as short as possible

54
Q

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

A

Relates to a technical characteristic of the system

55
Q

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

A

mandatory one

56
Q

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

A

True

57
Q

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

A

True

Database (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions