All possible foreign key references

Legal set of values and attribute format

Datatype and size constraints

Only datatype

They are used only in many-to-many associations

They specialize an association by introducing identifying attributes

They reduce attributes of an entity

They turn an attribute into a secondary key

Identify relationship types

Check model for redundancy

Identify entity types

Determine attribute domains

A composite attribute

A derived attribute of Repair Job

An entity attribute

A relationship attribute of Mechanic–Repair Job

A table enforces automatic PK creation

A table cannot contain NULL values

A relation is a mathematical set; duplicates are not allowed

A relation allows ordering of tuples

Value unknown

Value does not apply

Value equals zero

Value exists but not available

FK attributes must be superkeys in R1

FK must always reference a composite key

FK must reference a primary key in R2

FK must reference a unique attribute but cannot be NULL

Degree = 10, Cardinality = 3

Degree = Number of candidate keys, Cardinality = Number of domains

Degree = 3, Cardinality = 10

Degree = r(A,B,C), Cardinality = dom(A)

A first normal form attribute

A composite attribute

A domain

A minimal superkey

A candidate key containing duplicate values

A primary key containing a NULL value

A foreign key referencing a nonexistent tuple

A domain mismatch between FK and PK