Hello guys,

I am a university student and database is one of the modules we study and to be honest i don't have much experience with databases, i know the some but i don't know alot about normalization and i've been given a table to normalize.

Basically the table contains no data, just blank field and i was wondering if you guys help me normalize it to 3NF.

i had a go at it myself and the result is as follows:
http://img412.imageshack.us/img412/2139/1nfto3nf.jpg


it would be appriciated.

I've attached the given table below hope it makes sense:

Tables required for 3nf:

Client (ClientID, ClientName, ClientPhone)
Person (PersonID, ClientID, PersonName)
Location (LocationID, LocationName)
Meeting (MeetingID, LocationID, PersonID, Date, Time, Staff)

Not sure what Staff represents... hard to design a DB when you don't know what the fields represent.

Originally Posted by smoseley

Tables required for 3nf:

Client (ClientID, ClientName, ClientPhone)
Person (PersonID, ClientID, PersonName)
Location (LocationID, LocationName)
Meeting (MeetingID, LocationID, PersonID, Date, Time, Staff)

Not sure what Staff represents... hard to design a DB when you don't know what the fields represent.

thank you so much but could you please go through it from the 1NF coz right now am kinda confused as you only showing me the 3NF.

if you show me how you broke it down from the 1NF i would be very greatful.

thanks

No can do. Learn what 1NF, 2NF, and 3NF mean. Will help you in your career.

http://en.wikipedia.org/wiki/First_normal_form

http://en.wikipedia.org/wiki/Second_normal_form