Assignment 2: Normalization

label Programming
account_circle Unassigned
schedule 1 Day
account_balance_wallet $5

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

Oct 21st, 2017

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

Did you know? You can earn $20 for every friend you invite to Studypool!
Click here to
Refer a Friend
...
Oct 21st, 2017
...
Oct 21st, 2017
Oct 21st, 2017
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