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
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.
Content will be erased after question is completed.
Enter the email address associated with your account, and we will email you a link to reset your password.
Forgot your password?