Normalisation

Hi, is there anyone who could help with normalisation?
The field a
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

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.

--
Duane Hookom
MS Access MVP


"kmistry" wrote in message
...
Hi, is there anyone who could help with normalisation?
The field a
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

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

"Duane Hookom" wrote:

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.

--
Duane Hookom
MS Access MVP


"kmistry" wrote in message
...
Hi, is there anyone who could help with normalisation?
The field a
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