Database Management > EXAM > WGU C170 Objective Assessment – Edward M Burke (All)

WGU C170 Objective Assessment – Edward M Burke

Document Content and Description Below

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 redundant groups, and each column in the table will contai... n 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. Third Normal Form – 4 Tables In order to achieve third normal form we need to eliminate any transitive dependency, meaning an attribute depends on another attribute that is not the primary key. For example, looking at our second normal form 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 transform into third normal form we simply move any transitively dependent attributes to their own relation where they depend on only the primary key. [Show More]

Last updated: 1 year ago

Preview 1 out of 11 pages

Add to cart

Instant download

We Accept:

We Accept
document-preview

Buy this document to get the full access instantly

Instant Download Access after purchase

Add to cart

Instant download

We Accept:

We Accept

Reviews( 0 )

$11.00

Add to cart

We Accept:

We Accept

Instant download

Can't find what you want? Try our AI powered Search

OR

REQUEST DOCUMENT
50
0

Document information


Connected school, study & course


About the document


Uploaded On

Oct 16, 2022

Number of pages

11

Written in

Seller


seller-icon
Junenjeschamp

Member since 2 years

2 Documents Sold


Additional information

This document has been written for:

Uploaded

Oct 16, 2022

Downloads

 0

Views

 50

Document Keyword Tags

Recommended For You

Get more on EXAM »

$11.00
What is Browsegrades

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 are here to help

We're available through e-mail, Twitter, Facebook, and live chat.
 FAQ
 Questions? Leave a message!

Follow us on
 Twitter

Copyright © Browsegrades · High quality services·