Hey Guys,

I want to create a database which i want to track pupils for a period of years for a particular school.

I have the fields hence i need the schema. The fields are

Division,District,District Code,Zonecode,zone,School,SchoolCode,Surname,first name,Year, Code(district,school,pupil),Pupil code, Sex,Age,Repetition,Class,Number


Repetition Level
Class New Entrant First Repeater Second Repeater
1 2012 2011 2010
2 2011 2010 2009
3 2010 2009 2008
4 2009 2008 2007
5 2008 2007 2006

The logic is a Class 1 pupil in 2012 is a new entrant, a Class 1 pupil in 2011 is a first repeater, a class 1 pupil in 2010 is a second repeater.

Would you please help me with the database schema