WGU C170 – Objective Assessment with Complete and
Verified Solutions | Latest Update
WGU C170 Objective Assessment
Ƒirst Normal Ƒorm – 1 Table
I gleaned this table ƒrom the unstructured data contained within the
order ƒorm. I made sure not to have any redundant groups, and each
column in the table will contain atomic values. Donut ID, Donut Name,
Donut Quantity, Unit Price, and Donut Description are an example oƒ a
repeating group. As I mentioned earlier, in order to achieve ƒirst normal
ƒorm, we must eliminate repeating groups. This requires the use oƒ a
composite key made up oƒ Donut Order ID and Donut ID.
Second Normal Ƒorm – 3 Tables
In order to achieve second normal ƒorm we need to split the
ƒirst table into three separate tables so that all non-key
attributes are ƒunctionally dependent on the entire primary
key. I took the attributes that are partially dependent on the
primary key, and placed them into separate relations. Donut
Name, Donut Description, and Unit Price depend only on
Donut Order ID. Donut Quantity and Item Total depend on
both Donut Order ID and Donut ID.
, Third Normal Ƒorm – 4 Tables
In order to achieve third normal ƒorm we need to eliminate any transitive dependency, meaning an attribute
depends on another attribute that is not the primary key. Ƒor example, looking at our second normal ƒorm
tables, Customer Last Name is dependent on Donut Order ID. (Each Donut Order ID has only one Customer Last
Name value associated with it) To transƒorm into third normal ƒorm we simply move any transitively
dependent attributes to their own relation where they depend on only the primary key.
Verified Solutions | Latest Update
WGU C170 Objective Assessment
Ƒirst Normal Ƒorm – 1 Table
I gleaned this table ƒrom the unstructured data contained within the
order ƒorm. I made sure not to have any redundant groups, and each
column in the table will contain atomic values. Donut ID, Donut Name,
Donut Quantity, Unit Price, and Donut Description are an example oƒ a
repeating group. As I mentioned earlier, in order to achieve ƒirst normal
ƒorm, we must eliminate repeating groups. This requires the use oƒ a
composite key made up oƒ Donut Order ID and Donut ID.
Second Normal Ƒorm – 3 Tables
In order to achieve second normal ƒorm we need to split the
ƒirst table into three separate tables so that all non-key
attributes are ƒunctionally dependent on the entire primary
key. I took the attributes that are partially dependent on the
primary key, and placed them into separate relations. Donut
Name, Donut Description, and Unit Price depend only on
Donut Order ID. Donut Quantity and Item Total depend on
both Donut Order ID and Donut ID.
, Third Normal Ƒorm – 4 Tables
In order to achieve third normal ƒorm we need to eliminate any transitive dependency, meaning an attribute
depends on another attribute that is not the primary key. Ƒor example, looking at our second normal ƒorm
tables, Customer Last Name is dependent on Donut Order ID. (Each Donut Order ID has only one Customer Last
Name value associated with it) To transƒorm into third normal ƒorm we simply move any transitively
dependent attributes to their own relation where they depend on only the primary key.
