WGU C170 Objective Assessment – Edward M Burke
bb bb bb bb bb bb bb
First Normal Form – 1 Table
bb bb bb bb bb
I gleaned this table from the unstructured data contained within
bb bb bb bb bb bb bb bb bb
bb the order form. I made sure not to have any redundant groups,
bb bb bb bb bb bb bb bb bb bb bb
bb and each column in the table will contain atomic values. Donut ID,
bb bb bb bb bb bb bb bb bb bb bb
Donut Name, Donut Quantity, Unit Price, and Donut Description are
bb bb bb bb bb bb bb bb bb bb
bb an example of a repeating group. As I mentioned earlier, in order
bb bb bb bb bb bb bb bb bb bb bb
bb to achieve first normal form, we must eliminate
bb bb bb bb bb bb bb
repeating groups. This requires the use of a composite key made up of
bb bb bb bb bb bb bb bb bb bb bb bb
bb Donut Order ID and Donut ID.
bb bb bb bb bb
Second Normal Form – 3 Tables
bb bb bb bb bb
In order to achieve second normal form we need to split
bb bb bb bb bb bb bb bb bb bb
the first table into three separate tables so that all non-
bb bb bb bb bb bb bb bb bb bb bb
, key attributes are functionally
bb bb bb
dependent on the entire primary key.
bb bb bb bb bb bb
I took the attributes that are partially
bb bb bb bb bb bb bb
dependent on the primary key, and
bb bb bb bb bb bb
placed them into separate relations.
bb bb bb bb bb
Donut Name, Donut Description, and
bb bb bb bb bb
Unit Price depend only on Donut
bb bb bb bb bb bb
Order ID. Donut Quantity and Item
bb bb bb bb bb bb
Total depend on both Donut Order ID
bb bb bb bb bb bb bb
and Donut ID.
bb bb bb
bb bb bb bb bb bb bb
First Normal Form – 1 Table
bb bb bb bb bb
I gleaned this table from the unstructured data contained within
bb bb bb bb bb bb bb bb bb
bb the order form. I made sure not to have any redundant groups,
bb bb bb bb bb bb bb bb bb bb bb
bb and each column in the table will contain atomic values. Donut ID,
bb bb bb bb bb bb bb bb bb bb bb
Donut Name, Donut Quantity, Unit Price, and Donut Description are
bb bb bb bb bb bb bb bb bb bb
bb an example of a repeating group. As I mentioned earlier, in order
bb bb bb bb bb bb bb bb bb bb bb
bb to achieve first normal form, we must eliminate
bb bb bb bb bb bb bb
repeating groups. This requires the use of a composite key made up of
bb bb bb bb bb bb bb bb bb bb bb bb
bb Donut Order ID and Donut ID.
bb bb bb bb bb
Second Normal Form – 3 Tables
bb bb bb bb bb
In order to achieve second normal form we need to split
bb bb bb bb bb bb bb bb bb bb
the first table into three separate tables so that all non-
bb bb bb bb bb bb bb bb bb bb bb
, key attributes are functionally
bb bb bb
dependent on the entire primary key.
bb bb bb bb bb bb
I took the attributes that are partially
bb bb bb bb bb bb bb
dependent on the primary key, and
bb bb bb bb bb bb
placed them into separate relations.
bb bb bb bb bb
Donut Name, Donut Description, and
bb bb bb bb bb
Unit Price depend only on Donut
bb bb bb bb bb bb
Order ID. Donut Quantity and Item
bb bb bb bb bb bb
Total depend on both Donut Order ID
bb bb bb bb bb bb bb
and Donut ID.
bb bb bb