troubleshooting Question

Database - Normalization

Avatar of hugonieto
hugonietoFlag for United States of America asked on
MySQL ServerMicrosoft SQL Server 2008SQL
9 Comments7 Solutions555 ViewsLast Modified:
Hi guys!

I trying to figure out how 1NF, 2NF, and 3NF works!!!! I kind of understand it with a small raw data like: one table -

Orders(OrderNum, OrderDate, PartNum, Description, NumOrdered, QuatedPrice)

But I don't know how to go from 1st to 2nd to 3rd with more data!! For example:

Employee: Employee id., SSN, First name, Last name, Middle Init., Street address, City, State, Zip, Home Telephone, Cell Telephone number, Job Code, Job description, Salary code, Salary rate, Sex, age, hire date, birth date, Marital Status, Number of dependents, names of dependents, dependents ssn, insurance code(s), insurance description(s), y-t-d gross, y-t-d net, 401k, fed. tax, state tax, ss tax, emergency contact name, emergency telephone number, emergency contact relationship

Item : Item code, item description, size, shelve location code, shelve location description, Manufacturer code, manufacturer name, distributor code, distributor name, retail price, wholesale price, sale price, vendor id, vendor name, type code, type description

Manufacturer: manufacturer code, manufacturer name, street address, city, sate, zip, telephone number, contact name, contact telephone number,

Distributor: distributor code, distributor name, street address, city, state, zip, distributor telephone number, contact name, contact telephone number

Vendor: vendor code, vendor name, street address, city, state, zip, vendor telephone number, contact name, contact telephone number  

Customer Sales Sales id number, sales date, sales time, employee id who took the order, employee id who prepared order, food item(s) id, name(s), individual item cost, tax, payment type (cash or credit card), credit card number


These are 5 different tables but they are not in any form!!! It is giving me a headache to understand how to go from form to form with these data!! specially going from 2NF to 3NF!!! Can you give me a hand? I would appreciate it!!!  


Thanks,
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 7 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 7 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros