Chapter 8 Flashcards

1
Q

The entity-relationship model is a _______ data modeling used to capture the overall structure of data in an organization.

A

conceptual

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

In the ER model, a person, place, object, event or concept in the user environment about
which data is to be maintained is called a(n) _______.

A

Entity

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

In the ER model, a named propety or characteistic of an entity that is of interest to the
organization is refered to as a(n) _______.

A

Attribute

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

The number of entity types that paticipate in a relationship is refered to as the _______.

A

Degree

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

The _______ is the number of instances of one entity that can be associated with each
instance of another entity.

A

Cardinality

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

In a data model for a hospital, a patient is descibed either as an outpatient or a resident
patient. In this model the patient represents a _______.

A

Super-Type

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

In the previous hospital data model case, each patient must be either a outpatient or a
resident patient. This illustrates a case of _______ specialization

A

Total and disjoint

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

The _______ is the set of all data types and values that an attibute can assume.

A

domain

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