Description
Assignment 2: Normalization
Due Week 6 and worth 100 points
Suppose that you are the database developer for a local college. The Chief Information Officer (CIO) has asked you to provide a summary of normalizing database tables that the IT staff will use in the upcoming training session
Explanation & Answer
3 tipes of NF will be used.
1st is 1NF In this Item,price and tax will be calculated that what items are needed, and how many are needed, and what will be their cost after adding the taxes also,
points to be kept in mind are : no repeating items , duplicate items should be removed.
Than comes the 2NF
In this, a check should be done so as to see whether these all are related to the item or not, such as price and tax should be associated with primary key which is Item.
Than comes the 3NF
In this all the three columns should be made in such way that how they are depending upon each other, such as item is related to price and price is related to tax.
Now this could be maintained in an excel file , joining each IT field with their corresponding fields.
This is how the normalization is done.
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
To the Lighthouse
by Virginia Woolf
The Great Gatsby
by Francis Scott Key Fitzgerald
The Iliad
by Homer
Treasure Island
by Robert Louis
The Restless Wave
by John McCain
Good Kids Bad City
by Kyle Swenson
The Subtle Art of Not Giving a F*ck
by Mark Manson
And Then There Were None
by Agatha Christie
The Nightingale
by Kristin Hannah