Help come up with a good db design for student

[samvb]

Hey,

am developing a database for college that stores student information. I have come up with one design and seemed to be mistaken.

I have included an attachment of the database. THe program is in NET. 2010 but it is easier to attach access db.

Now the problem is the college works this way and I am not sure how to best handle them:

Academic Year( e.g. 2011) have 3 terms. New students can register at any term. Each term contains 2 semesters. Credit hour fee is the same for each course and can be changed at SEMESTER level.

A student can pay full course fee (that is until he graduates). Any fee changes must not affect him later on.

A student may take entrance exam. If he fails the exam, he is auto entered to freshman course with the following credit style: For payment purpose, all credits become 4 while in transcript the subjects are rated out of 3 for him.

A student can select courses to study in a semester. And he can pay any amount he can at one time. Like if the total fee for his total study is 10000, he can pay that by installments.

A student can pass from a certificate program to a diploma program. He joins to ceriticate but can pass to diploma program (e.g. ICT Certificate to ICT diploma).

I know it is confusing and it is even more confusing if gone in detail.

P.S. HOW CAN I ATTACH MDB FILE HERE?

[TheSmileyCoder]

Setting up a good design for such a case is no simple task that can be solved in any reasonable time frame for volunteers. Id estimate 5-10 hours to setup a good design PROTOTYPE.

When it involves this amount of money (tuition fees), it sounds to me like you should look around for a finished program. There must be dozens of programs that can solve this for you, and with less risk of error.

This is just my oppinion, and you are free to choose to go your own ways.

[Mr Key]

What you are asking is impossible!!
You have to do it first, if u fail to acomplish a certain task than you may ask!
Dont give us the details from your boss

[Frank Kahn]

I would like to make the effort to help solve your dilema. Information is insufficient though. I have viewed your table designs and have some questions. You use number type fields for nationalid and countryid. You also use a number type for marital status. Why are these numbers? I dont see any lookup tables for the number to find a country or marital status. If you want to persue this please attach a data definition document to help me understand the requirements.