School Database system

[wabamdo]

I am developing a simple school database system,how can i arrange my tables better to be able to include monthly fees in my transaction form?I mean please give me a better table structure

 

[jdraw]

There are a number of free data models here.
Some of these apply to Schools and students --see Education and Student categories..

 

[plog]

I second jdraw's link. Here are the issues I see with your database:

1. 'Year' and 'Form' are a reserved words (http://support.microsoft.com/kb/286335) and shouldn't be used as an object name (Table/Query/Field etc.)

2. [Balance] shouldn't be a field in a table, instead it should be calculated. You shouldn't store caclulated values, instead you calculate them.

3. I don't think you relationship among tblFees, TransDetails, FeeMaster is correct. You need all your amounts (credits and debits) in one field in one table. That way you can easily calculate your balance.

 

[Mile-O]

I'd add to be consistent with naming conventions. Why have some tables prefixed 'tbl' and not others? Prefix them all.