var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: database schema
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
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
Tags for this Thread