Assignment 2: Normalization

Programming
Tutor: None Selected Time limit: 1 Day

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

Nov 19th, 2014

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.

Nov 19th, 2014

Studypool's Notebank makes it easy to buy and sell old notes, study guides, reviews, etc.
Click to visit
The Notebank
...
Nov 19th, 2014
...
Nov 19th, 2014
Dec 8th, 2016
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer