The Area being Modelled is :-
Hi,
i have an ICT exam that requires creating a database and I was wondering, how would i start a database with this information, what tables would i need?

please help, thanks

Wallsherpool Sixth Form College is located in the North East of England and offers
students a range of A Level courses.

Enrichment activities take place on a Wednesday afternoon. One of these is a boot camp,

where students undertake fitness training. Mr McGarry, a PE teacher, runs the boot camp.

Fitness testing takes place once a month. Students complete the same exercises each

month. Some exercises test the number of repetitions a student can manage in

60 seconds, whilst others test the number of seconds for which a position can be maintained.

Mr McGarry currently maintains paper-based records of testing, so that students can see how
their fitness levels are progressing. He knows you are studying ICT and thinks you could
develop a more efficient IT-based solution to record and analyse the fitness records.

In the first instance it has been agreed that you will design and build a prototype relational
database system that will focus on four tasks.

The final system will be based on your evaluation of the prototype and your recommendations for
further functionality.

Barry has shown 'Things of Interest' in Bold.


These are the tasks.

1 Adding New Students, which involves:
� ensuring their name and date of birth are present
� the generation of a unique StudentID: a mixture of letters from their name and
  ending with a sequential four digit number
� storing the student details if all requirements are met
� providing a suitable message for Mr McGarry, so that he knows what is happening.


2 Adding a Monthly Fitness Test, which involves the generation of:
� a unique identification key
� the month of the test
� a new record for each exercise, for each student, in readiness for their fitness test
  results.


3 Recording Fitness Test Results, which involves:
� adding a student�s fitness test results for each exercise.


4 Printing Records for Identified Students � Mr McGarry needs to be able to select
  students and print records showing their best and worst result for each exercise.

  The printout will need to be clear and easy to read