C175 - Chapter 5
Terms in this set (17)
An attribute that cannot be further subdivided to produce meaningful components. For example, a person's last name attribute cannot be meaningfully subdivided.
The transaction property that requires all parts of a transaction to be treated as a single, indivisible, logical unit of work. All parts of a transaction must be completed or the entire transaction is aborted.
Boyce-Codd normal form (BCNF)
A special type of third normal form (3NF) in which every determinant is a candidate key. A table in BCNF must be in 3NF. See also determinant.
A process by which a table is changed from a higher-level normal form to a lower-level normal form, usually to increase processing speed. Denormalization potentially yields data anomalies.
A representation of all data dependencies (primary key, partial, or transitive) within a table.
Any attribute in a specific row whose value directly determines other values in that row. See also Boyce-Codd normal form (BCNF).
first normal form (1NF)
The first stage in the normalization process. It describes a relation depicted in tabular format, with no repeating groups and a primary key identified. All nonkey attributes in the relation are dependent on the primary key.
fourth normal form (4NF)
A table is in 4NF if it is in 3NF and contains no multiple independent sets of multivalued dependencies.
The level of detail represented by the values stored in a table's row. Data stored at its lowest level of granularity is said to be atomic data.
An attribute that is not part of a key. See also nonprime attribute.
An attribute that is not part of a key. See also nonkey attribute.
A process that assigns attributes to entities so that data redundancies are reduced or eliminated.
A condition in which an attribute is dependent on only a portion (subset) of the primary key.
In a relation, a characteristic describing a group of multiple entries of the same type for a single key attribute occurrence. For example, a car can have multiple colors for its top, interior, bottom, trim, and so on.
second normal form (2NF)
The second stage in the normalization process, in which a relation is in 1NF and there are no partial dependencies (dependencies in only part of the primary key).
third normal form (3NF)
A table is in 3NF when it is in 2NF and no nonkey attribute is functionally dependent on another nonkey attribute; that is, it cannot include transitive dependencies.
A condition in which an attribute is dependent on another attribute that is not part of the primary key.
YOU MIGHT ALSO LIKE...
Academic Word Lists - AWL Sublists
CIS Ch. 6 - Normalization of Database Tables
IT Midterm Review Ch 6: Normalization
Chapter 6 - Advanced Data Modeling Chapter 5 - Normalization of Database Tables
OTHER SETS BY THIS CREATOR
Chapter 1 - Service Management as a Practice
C175 - Chapter 7
C175 - Chapter 6
C175 - Chapter 4
THIS SET IS OFTEN IN FOLDERS WITH...
C175 - Chapter 1
C175 - Chapter 2
C175 - Chapter 3