• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Anyone willing to help me with some database normalization?

S

spartacus321

Senior member
Long story short i'm supposed to create some tables in a database for a small class project.

I totally suck at normalization.

I have my un-normalized data, and need to show it normalized in stages up to the 3rd normal form.

If anyone here is willing to give me some help, please PM me and i'll send you the data, it's not very long.

I'll gladly repay once I get it done properly, thank you 🙂
 
Originally posted by: spartacus321
Long story short i'm supposed to create some tables in a database for a small class project.

I totally suck at normalization.

I have my un-normalized data, and need to show it normalized in stages up to the 3rd normal form.

If anyone here is willing to give me some help, please PM me and i'll send you the data, it's not very long.

I'll gladly repay once I get it done properly, thank you 🙂
Click to expand...

Don't tell the girls that !
 
I believe 3rd normal form is used to get rid of all attributes in a table that are not dependent on the primary key of that table.

I know the definitions for the 1st, 2nd and 3rd normal forms but I can't get around to actually sorting out the data right 🙁
 
Duplicate data strings.

Such as addresses with the city and state repeated multiple times.
More efficient to have a seperate table for the City and State each containing unique names and a unique index.
Then in the address table, use an index to the City and State tables.

Some database packages will provide tools to assist in normalization of your data.
 
Edit the data/schema a bit and post it here. It would be fun to do a group thing but I'm not going to just look at it on my own.
 
Ok here I go...

Just to give a short background, i'd like to store info. on products, customers, suppliers and employees. So far i've come up with a table for each like this:

Supplier Table
Sid
Sname
Saddress
Stelephone
Sfax
Semail

Employee Table
Eid
Efirstname
Elastname
Eaddress
Etelephone
Email
Esex
Edob
Eposition
Epositiondesc
Ehiredate
Epayate


Customer Table
Cid
Cname
Caddress
Ctelephone
Cfax
Cemail

Products Table
Pid
Pdescription
Pcategory
Punitprice
Pquantity

Would I be correct in saying that everything above (without being in tables) is un-normalized and with it in table format as i've listed is 1st normal form?
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top