Assignment 2: Normalization

User Generated

xhyhzen

Programming

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

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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.


Anonymous
Very useful material for studying!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags