Chapter 2 Vocab Flashcards

1
Q

ER Model

A

a logical representation of the data for an organization or for a business area, using entities for categories of data and relationships for associations between entities

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

ER Diagram

A

a graphical representation of an ER model

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

Business Rule

A

a statement that defines or constrains some aspect of the business

it is intended to assert business structure or to control or influence the behavior of the business

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

Term

A

a word or phrase that has a specific meaning for the business

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

Fact

A

an association between two or more terms

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

Entity

A

a person, place, object, or concept in the user environment about which the organization wishes to maintain data

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

Entity Type

A

a collection of entities that share common properties or characteristics

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

Entity Instance

A

A single occurrence of an entity type

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

Strong Entity Type

A

an entity that exists independently of other entity types

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

Weak Entity Type

A

an entity type whose existence depends on another entity type

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

Identifying Owner

A

the entity type on which the weak entity type depends

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

Identifying Relationship

A

the relationship between a weak entity type and its owner

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

Attribute

A

a property or characteristic of an entity or relationship type that is of interest to the organization

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

Required Attribute

A

an attribute that must have a value for every entity (or relationship) instance with which it is associated

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

Optional Attribute

A

an attribute that may not have a value for every entity (or relationship) instance with which it is associated

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

Composite Attribute

A

an attribute that has meaningful component parts (attributes)

17
Q

Simple (Atomic) Attribute

A

an attribute that cannot be broken down into smaller down into smaller components that are meaningful to the organization

18
Q

Multivalued Attribute

A

an attribute that may take on more than one value for a given entity or relationship instance

19
Q

Derived Attribute

A

an attribute whose values can be calculated from related attribute values

20
Q

Identifier

A

an attribute (or combination of attributes) whose value distinguishes instances of an entity type

21
Q

Composite Identifier

A

an identifier that consists of a composite attribute

22
Q

Relationship Type

A

a meaningful association between (or among) entity types

23
Q

Relationship Instance

A

an association between or among entity instances where each relationship instance associates exactly one entity instance from each participating entity type

24
Q

Associative Entity

A

an entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances

25
Q

Degree

A

the number of entity types that participate in a relationship

26
Q

Unary Relationship

A

a relationship between instances of a single entity type

27
Q

Binary Relationship

A

a relationship between instances of two entity types

28
Q

Ternary Relationship

A

a simultaneous relationship among the instances of three entity types

29
Q

Cardinality Constraint

A

a rule that specifies the number of instances of one entity that can (or must) be associates with each instance of another entity

30
Q

Minimum Cardinality

A

the minimum number of instances of one entity that may be associated with each instance of another entity

31
Q

Maximum Cardinality

A

the maximum number of instances of one entity that may be associated with each instance of another entity

32
Q

Time Stamp

A

a time value that is associated with a data value