WGU C170 Objective Assessment Edward M Burke

WGU C170 Objective Assessment – Edward M
gg gg gg gg gg gg




Burke gg




First Normal Form – 1 Table
gg gg gg gg gg




I gleaned this table from the unstructured data contained within the
gg gg gg gg gg gg gg gg gg gg


ggorder form. I made sure not to have any redundant groups, and each
gg gg gg gg gg gg gg gg gg gg gg gg


ggcolumn in the table will contain atomic values. Donut ID, Donut Name,
gg gg gg gg gg gg gg gg gg gg gg


ggDonut Quantity, Unit Price, and Donut Description are an example of a
gg gg gg gg gg gg gg gg gg gg gg


ggrepeating group. As I mentioned earlier, in order to achieve first
gg gg gg gg gg gg gg gg gg gg


ggnormal form, we must eliminate
gg gg gg gg


repeating groups. This requires the use of a composite key made up of
gg gg gg gg gg gg gg gg gg gg gg gg


ggDonut Order ID and Donut ID.
gg gg gg gg gg




Second Normal Form – 3 Tables
gg gg gg gg gg




In order to achieve second normal form we need to split the
gg gg gg gg gg gg gg gg gg gg gg


first table into three separate tables so that all non-key
gg gg gg gg gg gg gg gg gg gg


attributes are functionally dependent on the entire primary
gg gg gg gg gg gg gg gg


key. I took the attributes that are partially dependent on the
gg gg gg gg gg gg gg gg gg gg gg


primary key, and placed them into separate relations. Donut
gg gg gg gg gg gg gg gg gg


Name, Donut Description, and Unit Price depend only on
gg gg gg gg gg gg gg gg gg


Donut Order ID. Donut Quantity and Item Total depend on
gg gg gg gg gg gg gg gg gg gg


both Donut Order ID and Donut ID.
gg gg gg gg gg gg gg

, Third Normal Form – 4 Tables
gg gg gg gg gg




In order to achieve third normal form we need to eliminate any transitive dependency, meaning an attribute
gg gg gg gg gg gg gg gg gg gg gg gg gg gg gg gg


depends on another attribute that is not the primary key. For example, looking at our second normal form
gg gg gg gg gg gg gg gg gg gg gg gg gg gg gg gg gg gg


ggtables, Customer Last Name is dependent on Donut Order ID. (Each Donut Order ID has only one Customer
gg gg gg gg gg gg gg gg gg gg gg gg gg gg gg gg gg


ggLast Name value associated with it) To transform into third normal form we simply move any transitively
gg gg gg gg gg gg gg gg gg gg gg gg gg gg gg gg


ggdependent attributes to their own relation where they depend on only the primary key.
gg gg gg gg gg gg gg gg gg gg gg gg gg