How to design an database for providing concession for school students

Question

Post reply

How to design an database for providing concession for school students

rajath 82072

Newbie

Points: 7
More actions
March 12, 2010 at 8:14 am

#386491

Hi all,
I am trying to develop an new database for school Fee management system. I am not able to develop database for providing concession for students.
Concession may be provided based on category,gender,religion,family income. It is difficult to use comma seperated values.
thanks in advance.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

What tables, if any have you designed so far?

What are the business rules for giving concessions?

How is the data to be added through a user interface, or?

Are the values of the concession dependent upon, gender,religion,family income.

Are the values of the concession cumulative if student is in more than a single category (gender,religion,family income)?

What output is required, printed reports, displayed through a user interface?

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

rajath 82072 Newbie Points: 7 More actions · Answer 2

Hi Ron,

I have tried to design table for concession. Data will be entered through user interface. There may be concessions with different names for example ConcessionForSCstudents, ConcessionForPoorStudents etc.

Each type of concession may have different combinations of category, gender, religion and family income. For example ConcessionForPoorStudents may require all students of Category-SC,religion-ALL,family income 0f 1000. It may also require all female students of Category-OBC,religion-Hindu,family income 0f 2000.

The main issue here is a single concession name may have different combinations of category,gender and familyincome.

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.

Thanks in advance

The Dixie Flatline SSC Guru Points: 53354 More actions · Answer 3

Please post the schema you have created so far. It is far easier for the volunteers trying to help you to deal with specific code than with general descriptions. You would profit from taking a look at this article for examples:

Forum Etiquette: How to post data/code on a forum to get the best help[/url]

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

mathewsys SSC Rookie Points: 42 More actions · Answer 4

Hi,

Your requirement as i understand.

You have to give concessions based on gender and family income and so on. Am i right?

These matters you must save at the time of student admission.

Ok

See....

Concession will be given for each Head for each student. isn't it?

for ex:

We have Tuitionfee,ExamFee and a student who is studying in Class 1

he want some concession for tution fee in the month of april.

Ok

first thing is select a student who need concession.

then select which head you want to give concession

then select in which month you want to give the concession

student id=1

Student is X

Head=Tuition

Head Amount=100 (as defined)

Concession Amount = 10 (as eligible)

Applied month=Oct

dont store data with coma separated value...

It should be inserted by each raw for each month.

check-out these ideas