Help with Database Design

[shmick25]

Hi There.

I am buildeing a database and am stumped at a certain point.
COuld anyone help?? The data-base revolves around student admissions.

Basically, the business rules of the section I am up to go along somthing like this.

1. Students can be enrolled into 1 module at a time
2. A module is comprised of 6.5 units
3. Subjects are either 1 or .5 units each
4. Subjects can be either added to or taken away from each module depending on the student's previous study

I was thinking of having a module look-up table with all the subjects in it, but how do I customize then subjects bassed upon individual students, as this would be a one-module fits all approach?

Any help would be good.

Cheers