Normalisation

[kmistry]

Hi, is there anyone who could help with normalisation?
The field are:
Pupil Name, Year Group, Class, Teacher, Attendance, Absences, Subject,
Childs Comments, Head Comments.

I am learning but need some one's to check against.

Thanks

 

[Duane Hookom]

There are a number of related data models at
http://www.databaseanswers.org/data_models/index.htm. Come back if you have
some specific questions.

BTW: Pupils, classes, teachers, attendance, subjects,... should all be in
their own tables.

 

[kmistry]

I have posted another question on this subject. If you could please help i
would be most grateful.