Term
|
Definition
An error that results when user attempts to update table that contains redundant data
Types: Insertion, Deletion, Modification |
|
|
Term
|
Definition
| Attribute or combo of attributes that uniquely identify a row in a relation |
|
|
Term
|
Definition
| A primary key that consists of more than one attribute |
|
|
Term
|
Definition
| The attribute on the left side of the arrow in a functional dependency |
|
|
Term
|
Definition
| A rule that states that no primary key attribute may be null |
|
|
Term
|
Definition
| A relation that has a primary key and in which there are no repeating groups |
|
|
Term
|
Definition
| An attribute in a relation that serves as a primary key for a different relation in the same database |
|
|
Term
|
Definition
| A constraint in which the value of one attribute is determined by the value of another attribute |
|
|
Term
|
Definition
| An attribute that may have more than one meanings |
|
|
Term
|
Definition
A state of a relation that requires that certain rules
regarding relationships between attributes are satisfied |
|
|
Term
|
Definition
| The process of decomposing relations with anomalies into multiple well structured relations |
|
|
Term
|
Definition
A value that may be assigned to an attribute
when no other value applies or is unknown |
|
|
Term
| Partial Functional Dependency |
|
Definition
| A functional dependency in which one or more nonkey attributes are dependent on part of the primary key (but not all) |
|
|
Term
|
Definition
| An attribute or combo of attributes in a relation that identify each row in a relation |
|
|
Term
| Referential Integrity Constraint |
|
Definition
| A rule that states that either each foreign key must match a primary key value in another relation or the foregin key value must be null |
|
|
Term
|
Definition
| A named two-dimensional table of data |
|
|
Term
|
Definition
Relation in first normal form in which every nonkey attribute is fully functionally dependent on the
primary key |
|
|
Term
|
Definition
| A serial number assigned primary key for a relation |
|
|
Term
|
Definition
Two or more attributes that have different
names but the same meaning |
|
|
Term
|
Definition
A relation that is in second normal form and
has no transitive dependencies |
|
|
Term
|
Definition
| A functional dependency in which one or more nonkey attributes are dependent on the primary key via another nonkey attribute |
|
|
Term
|
Definition
| A relation that has minimal redundancy and allows users to insert, modify, and dete rows in a table without errors or inconsistencies |
|
|
