Tables help needed, new system!

[Nitrous]

Hi,

Im having a bit of trouble with some coursework im doing at the moment. Its a testing system for the school but I haven't a clue how to set the tables up to comply with the user requirements.

The users requirements are:

 Maximum Class Size of 25 people
 Maximum of 25 questions
 All of these questions must not be multiple choice
 There must be a variety of different question types
 Maximum of 5 answers per question, user must pick only 1 of these
 No retries, answer is either right or wrong, no second chance given

Could someone please help me with the table design, im completely baffled!

Many thanks in advance

 

[ColinEssex]

Hi - Please excuse my ignorance but I'd like to ask - How does your teacher expect you to do this? are you just given a project and told to get on with it? do you have any lessons about MS Access?

I've come across quite a few students who have no idea - yet are expected to know how to write a database

Col

 

[Nitrous]

Hi - Please excuse my ignorance but I'd like to ask - How does your teacher expect you to do this? are you just given a project and told to get on with it? do you have any lessons about MS Access?

I've come across quite a few students who have no idea - yet are expected to know how to write a database

Col

We're given a project and told to get on with it. I have done quite a few databases before, and they all worked perfectly, but this one has really stumped me.

If i cud just set up the tables, it'd be fine.

Someone please help...

 

[Rich]

How long do you have to complete the project?

 

[Nitrous]

How long do you have to complete the project?

I have until May to complete this project.

I have finished my analysis and design (although the design needs changing cos I cant think of a way to make it work)