A list of those who have entered a particular half-marathon

Assignment Help Other Subject

Reference no: EM13541182

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.

Reference no: EM13541182

Questions Cloud

What forces do you think would make the collapse : There are current news reports about the European Monetary Union being in substantial trouble – even that the Euro as a currency may collapse. If this were to be the case, what forces do you think would make the collapse of the union and the Euro pos..

Case deals with the issues of statue law and case law : Case deals with the issues of statue law and case law. Due to breach of directors' duties, Groovy George Ltd (GG) placed into liquidation.

How did presidential addresses and supreme court rulings : Conduct an Internet search to answer the following question: How did Presidential addresses and Supreme Court rulings begin to change the lives of the American people beginning in the mid-20th century?

How does human consciousness play out in the individual : How does human consciousness play out in the individual's life in terms of self concept, behavior, and self care? What influences are most significant in your life? How does your consciousness influence the decisions you make?

A list of those who have entered a particular half-marathon : 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:

Enright is not a very conscientious individual : Enright is not a very conscientious individual.

Several reputable institutions have determined : Several reputable institutions have determined that marijuana may have legitimate medical use

Case study - arc flash is an hazard cause problems : Case study of incident where arc flash is an hazard cause problems, damage in NON oil gas industry - what is learnt from the incident, hazard prevention steps taken to overcome.

Describe how the presence of myelin affects an action poten : Professor Freeman calls on his student Maya to describe how the presence of myelin affects an action potential. Maya should respond with which of the following statements?

User Account

All Pages