Study Set Content:
The column’s range of permissible values
domain
an attribute or combination of attributes that uniquely identifies any given row.
primary key
consists of one or more attributes that determine other attributes.
key
the state in which knowing the value of one attribute makes it possible to determine the value of another.
determination
means that the value of one or more attributes determines the value of one or more other attributes.
functional dependence
the attribute whose value determines another is called the
determinant
The attribute whose value is determined by the other attribute
dependent
a key that is composed of more than one attribute.
composite key
a key that can uniquely identify any row in the table
superkey
a minimal superkey—that is, a superkey without any unnecessary attributes.
candidate key
the condition in which each row (entity instance) in the table has its own unique identity. T
entity integrity
the primary key of one table that has been placed into another table to create a common attribute
foreign key
the condition in which every reference to an entity instance by another entity instance is valid
referential integrity
s defined as a key that is used strictly for data retrieval purposes.
secondary key
provides a detailed description of all tables in the database created by the user and designer.
data dictionary
