Relational Model of Data

Question 1

Entity

Answer 1

Person, place, thing, or event about which data will be collected. Represents a particular type of object in the real world (customer, flight route, concert).

Question 2

Attribute

Answer 2

Column in a table
Characteristic of an entity.
All rows conform to same format
Physical concept is field

Question 3

Attribute Domain

Answer 3

Range of values for a column

Attribute in one entity can inherit domain from another (e.g. address)

Question 4

Relationship

Answer 4

Association among entities. Entities are known as participants.

Question 5

Participant

Answer 5

An entity that participates in a relationship with another.

Question 6

Connectivity

Answer 6

Describes the relationship classification. Established in business rules.

Question 7

Cardinality

Answer 7

Expresses the min and max number of entity occurrences associated with one occurrence of the related entity. Established in business rules.