WGU C170 OBJECTIVE ASSESSMENT EXAM AND PRACTICE EXAM /WGU C 170 DATA MANAGEMENT APPLICATIONS OA 300 QUESTIONS AND CORRECT DETAILED ANSWERS (VERIFIED ANSWERS) |ALREADY GRADED A+

WGUC170 ss




ss Objective
Assessment –
ss ss




Edward MBurk
ss ss ss

, First Normal Form – 1 Table
ss ss ss ss ss




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




ss order form. I made sure not to have any redundant groups, and each
ss ss ss ss ss ss ss ss ss ss ss ss




ss column in the table will contain atomic values. Donut ID, Donut
ss ss ss ss ss ss ss ss ss ss




Name, Donut Quantity, Unit Price, and Donut Description are an
ss ss ss ss ss ss ss ss ss ss




ss example of a repeating group. As I mentioned earlier, in order to
ss ss ss ss ss ss ss ss ss ss ss




ss achieve first normal form, we must eliminate
ss ss ss ss ss ss




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




Donut Order ID and Donut ID.
ss ss ss ss ss ss




Second Normal Form – 3 Tables
ss ss ss ss ss




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




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




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




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