Need help designing VERY simple database...

[DublinDude]

Hi all,

I am reasonably familiar with Access but for some reason I am getting all confused when it comes to creating a simple relational database.

Basically, it is a simple database for a small school. 100 students separated into 5 groups. Some groups are doing Level 1 and some are doing Level 2. There are certain subjects they study at Level 1 and certain subjects they study at Level 2. So that much was easy to design. It can show what students are on what level, in what group etc.

However, where I seem to be confusing myself is when it comes to the actual subjects they are doing. I want to be able to show what subject a particular student is doing and what ones they have done so far and yet to do. If that makes sense?

Once the structure is in place, I can enter all the necessary data and then I want to create a launch form for people to access and view/edit info.



This is the structure I have so far. (my module I mean subject)



I would be grateful for any help on this as it is rather urgent I have it finished.

[June7]

I can't reconcile the ERD with the narrative description.

A student is assigned a level - which means what - grades 1 thru 12?

Students study subjects that are in different levels? So a student in grade 6 might study math at grade 8 level (algebra?)?

Why do subjects even need to be associated with levels?

If module means subject then why is ModuleID in Students table?

Need another table that associates students with the various subjects they study.

[DublinDude]

I can't reconcile the ERD with the narrative description.

A student is assigned a level - which means what - grades 1 thru 12?

Students study subjects that are in different levels? So a student in grade 6 might study math at grade 8 level (algebra?)?

Why do subjects even need to be associated with levels?

If module means subject then why is ModuleID in Students table?

Need another table that associates students with the various subjects they study.

Hi there, thanks for the reply.

There are only two levels. Level 1 and Level 2. (2 being more advanced subjects).
Each Level has a different set of subjects.
I think I placed the ModuleID field in the Students table to see if it would show what subject a student is currently doing. (they do one subject at a time)

[June7]

The 'current' subject can be queried from the StudentSubjects table you need to build. No need for the hassle of maintaining another field. This is assuming you want to retain history.

[DublinDude]

The 'current' subject can be queried from the StudentSubjects table you need to build. No need for the hassle of maintaining another field. This is assuming you want to retain history.

Oh yea I forgot about that. That makes it easier. Could the same be done to show what subjects a student has done so far.

[June7]

Don't really understand your question. The StudentSubjects table shows subjects students have taken.