entity definition
represents ONE real world object of importance in a DB
relationship definition
describes how entities can be connected
attribute definition
describes characteristics of an entity
domain definition
set of all possible values an attribute can take
table definiton
collection of records and fields
record definition
a unique instance of data
tuple definition
set of related data points in a unique instance
primary key definition
single attribute used to uniquely identify a record
candidate key
unique key that can be chosen as the primary key
surrogate key
system generated unique id used as primary key