I am trying to develop an new database for school Fee management system. I am not able to develop datatable for providing concession for students.
Concession may be provided based on category,gender,religion,family income. It is difficult to use comma seperated values. Data will be entered through user interface. There may be concessions with different names for example ConcessionForSCstudents, ConcessionForPoorStudents etc.
I have already got master tables containing all available category,religion names.
category,religion and family income of a particular student is also available in student details table.
The main issue here is a single concession name may have different combinations of category,gender and familyincome.
thanks in advance