Hello Everyone!
My question is regarding Table Design , Please guide me what's the best way to Design Fee Table
1. School Fee have different Categories ( Transport, Hostel, Tuition, Fine, etc)
2. New Students have to pay Enrolment Fee as well
3.Tution and Transport are monthly charged others once a year
4.School has 5 classes from (1 to 5)
5.Each class has different Fee Structure
So in short 5 classes have different Fee Structures , In each class new students have to pay additional Enrolment Fee, also some students does not require Transportation and hostel
My question is regarding Table Design , Please guide me what's the best way to Design Fee Table
1. School Fee have different Categories ( Transport, Hostel, Tuition, Fine, etc)
2. New Students have to pay Enrolment Fee as well
3.Tution and Transport are monthly charged others once a year
4.School has 5 classes from (1 to 5)
5.Each class has different Fee Structure
So in short 5 classes have different Fee Structures , In each class new students have to pay additional Enrolment Fee, also some students does not require Transportation and hostel