Database Normalisation

[neoone]

I have some fiedls and i woant to know what they will be like in 1st and 2nd normal form?
I can do them in 3rd.

thanks

here are the fields:

Student Middle Name
Student Date of Birth
Student ID
Student Address
Student Address 2
Student City/Town
Student County
Student Postcode
Student Parent name
Student Telephone
Student Parent Mobile
Student Parent 2 Name
Student Parent 2 Address
Student Parent 2 Address 2
Student Parent 2 City/Town
Student Parent 2 County
Student Parent 2 Post Code
Student Parent 2 Telephone
Student Parent 2 Mobile
Emergency Contact Name Relationship
Address
Address 2
City/Town
County
Postcode
Telephone
Mobile
Student previous school
Student Form Tutor
Student Subjects taken
Student Subject groups
Student subject sets
Tutor First Name
Tutor Initials
Tutor Surname

Thanks

 

[neoone]

does anyone know hoe to do normalisation?

thanks

 

[superprogrammer]

What do you need exactly?

 

[col]

Why do you need them in 1st or 2nd normal form?

1NF:
"A Relation in which the intersection of each row and column contains one and only one value"


2NF:
"A relation that is in the first normal form and every non-primary-key attribute is fully functionally dependent on the primary key"

 

[adam_uk]

your tables wont be normalised unless you move the tutor info to a new table

one of the factors of normalisation is that you atomise the data and that it doesnt repeat. your tutor information will repeat.

move the tutor feilds to a new table
give each tutor an id
make "tutor ID" feild in data table
and link to them there it saves having your data replicated and when it comes to change details etc for tutors you wont be required to go through each row on the table

you could probably do the same for these as well

Student previous school
Student Form Tutor
Student Subjects taken
Student Subject groups
Student subject sets

others students in the same dbase will obviously be in the same sets, groups etc etc so use a unique id to indentify these

also is your student id going to be a unique number that can idenfify each row on the table?

also just a little nit pick i guess but your making the asumtion that everyone has a parent, not everyone does it might be an idea to replace "parent" to guardian or something similar.

 

[neoone]

Thanks a lots
I will update you with what i come up with

thanks

 

[neoone]

Here is what i have come up with, tell me if it can be improved or something.

Student ID
Student First Name
Student Middle Name
Student Surname
Student Date of Birth
Previous School ID
Teacher ID
Student Address
Student Address 2
Student City/Town
Student County
Student Post Code
Telephone
Mobile
Contact Name
Relationship ID

Contact ID
Contact Student ID
Contact Relationship ID
Contact Name
Contact Address
Contact Address 2
Contact City/Town
Contact County
Contact Post Code
Contact Telephone
Emergency Contact
Mobile

Student Previous ID
Student previous school

Student ID
Student Subjects taken ID
Student Subject groups
Student Subject sets ID


Teacher ID
Teacher Form
Teacher First Name
Teacher Initials
Teacher Surname

Relationship ID
Relationship Name

Report ID
Subject ID
Comment
Completed

Report ID
Student ID
Term

Subject Set ID
Subject Set name

Subject ID
Subject Name

Subject Group ID
Subject ID
Subject Set ID
Teacher ID
Class


Thanks

 

[neoone]

Just wondering if anyone know how to check if the above is normalised to around 3rd normal form?and if it is.


thanks