Database for a Race Organiser
SM Event Management Ltd organises half-marathons for various cities in the UK. It stores the following information about runners who take part in the events:
Race (entrant) number, entrant fee (paid/unpaid), personal details (name, gender, age, address, telephone etc.), next of kin details, previous race details (locations and times), estimated time (for current race), name of charity and amount sponsored. Additional information on completion of the race comprises start and finish time.
You are required to produce a system using a database to organise this information. The users of the system are not particularly computer-literate so you are required to provide a suitable interface for inputting data and produce user-friendly (printable) reports. The information should be organised in a logical form and should meet the general requirements of a database e.g. the integrity of the data.
Populate the database with some data.
Produce reports for the following:
1.A list of those who have not paid.
2.A list of those who have entered a particular half-marathon before.
3.A list of those who have not entered this particular half-marathon before.
4.A list of runners for a race categorised into bands based on estimated times
Critically appraise your data model and the use of Access in storing, handling and presenting this data.