Chapter 2

Question 1

Derived Attribute

Answer 1

An attribute whose values can be calculated from related attribute values

Question 2

Identifying Owner

Answer 2

The entity type on which the weak entity type depends

Question 3

Weak entity type

Answer 3

An entity type whose existence depends on some other entity type

Question 4

Relationship Instance

Answer 4

An association between (or among) entity instances here each relationship instance associates exactly one entity type

Question 5

Attribute

Answer 5

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

Question 6

Strong Entity type

Answer 6

An entity that exists independently of other entity types

Question 7

Relationship Type

Answer 7

A meaningful association between (or among) entity types; association between entity types

Question 8

Fact

Answer 8

An association between two or more terms

Question 9

Composite attribute

Answer 9

An attribute that has meaningful component parts (attributes); can be broken into component parts

Question 10

Time Stamp

Answer 10

A time value that is associated with a data value, often indicating when some event occurred that affected the data value

Question 11

Optional attribute

Answer 11

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

Question 12

Required attribute

Answer 12

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

Question 13

Binary relationship

Answer 13

A relationship between the instances of two entity types

Question 14

Maximum Cardinality

Answer 14

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

Question 15

Ternary relationship

Answer 15

A simultaneous relationship among the instances of three entity types

Question 16

Composite identifier

Answer 16

An identifier that consists of a composite attribute

Question 17

Entity type

Answer 17

A collection of entities that share common properties or characteristics

Question 18

Term

Answer 18

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

Question 19

urnary relationship

Answer 19

relates instances of a single entity type

Question 20

Cardinality constraint

Answer 20

specifies maximum and minimum number of instances

Question 21

associative entity

Answer 21

relationship modeled as an entity type

Question 22

degree

Answer 22

number of participating entity types in relationship

Question 23

ternary

Answer 23

relationship of degree three