Database Management > QUESTIONS & ANSWERS > WGU C175 - Data Management - Foundations - Lesson 5, Questions section coverage, graded A (All)

WGU C175 - Data Management - Foundations - Lesson 5, Questions section coverage, graded A

Document Content and Description Below

WGU C175 - Data Management - Foundations - Lesson 5, Questions section coverage, graded A+ atomic attribute - ✔✔-An attribute that cannot be further subdivided to produce meaningful componen... ts. For example, a person's last name attribute cannot be meaningfully subdivided. atomicity - ✔✔-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. denormalization - ✔✔-A process by which a table is changed from a higher-level normal form to a lowerlevel normal form, usually to increase processing speed. dependency diagram - ✔✔-A representation of all data dependencies (primary key, partial, or transitive) within a table. determinant - ✔✔-Any attribute in a specific row whose value directly determines other values in that row. 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 ke [Show More]

Last updated: 2 years ago

Preview 1 out of 2 pages

Buy Now

Instant download

We Accept: