WGU C170 Objective Assessment – Edward M Burke First Normal Form – 1 Table I gleaned this table from the unstructured data contained within the order form. I made sure not to have any re... dundant 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 of a repeating group. As I mentioned earlier, in order to achieve first normal form, we must eliminate repeating groups. This requires the use of a composite key made up of Donut Order ID and Donut ID. Second Normal Form – 3 Tables In order to achieve second normal form we need to split the first table into three separate tables so that all non-key attributes are functionally 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. [Show More]
Last updated: 1 year ago
Preview 1 out of 11 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Add to cartInstant download
We Accept:
Connected school, study & course
About the document
Uploaded On
Sep 13, 2022
Number of pages
11
Written in
This document has been written for:
Uploaded
Sep 13, 2022
Downloads
0
Views
21
In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.
We're available through e-mail, Twitter, Facebook, and live chat.
FAQ
Questions? Leave a message!
Copyright © Browsegrades · High quality services·