question

dimpy avatar image
dimpy asked

How to design an database for providing concession for school students

Hi all,

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

sql-server-2008
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Why is a student's religion captured? Do some religions entitle you to greater concessions? If you post the table structure for what you already have and some more detail about how you calculate the concessions, we can help you
1 Like 1 ·
JohnFx avatar image
JohnFx answered

Thanks for letting us know. If you have any questions, send them our way.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

RMorrisey avatar image
RMorrisey answered

It sounds like you need to normalize your database design. In most cases, you probably don't want to name tables after specific data category combinations.

Look for articles and tutorials on the web about Relational Database Design, and Database Normalization. If you're confused about some specific point of design, you can post a new question and the SQL development community can give you more detailed guidance. We won't design your database for you. =)

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

SubsonicLv avatar image
SubsonicLv answered

Speak for yourself. I'll design it for you for a fee.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.