Build a database to store the below information and answer the below questions.

Question

Build a database to store the below information and answer the below questions.

Identify entities and attributes.

Ensure database is normalized.

Runner

Runner #

Runner First Name

Runner Last Name

Runner Phone #

Runner Address

Runner City

Runner Zip Code

Time Race Completed

Money Raised

Place Finished

Race Name (may be more than one)

Donated

Donor

First Name

Last Name

Phone #

Runner Number

Amount Donated ($)

Race

Race ID

Name of Race

Runner ID

Place Finished (#)

Runner Time

Amount raised ($)

Order of race in schedule

To answer these questions:

List place runners finished/all first place for certain race/time ran?

How much was pledged for certain race/by certain runner/total?

Name/ID of runner?

Contact information for runner?

Time finished?

How many races? Name of races? Order?

Who donated? To which runner?

Emergency contact for runner?

Fastest time?

Explanation / Answer

List place runners finished/all first place for certain race/time ran?

select Runner.firstName, Race.runnerTime * from Runner INNER JOIN Race ON Runner.runnerID = Race.raceID AND Runner.placeFinished=1;

How much was pledged for certain race/by certain runner/total?

select Runner.firstName, Race.amountRaised * from Runner INNER JOIN Race ON Runner.runnerID = Race.raceID;

Name/ID of runner?

select runnerID, firstName from Runner;

Contact information for runner?

select runnerID, firstName, phone, address, city, zipcode from Runner;

Time finished?

select runnerID, firstName , timeRaceCompleted from Runner;

How many races? Name of races? Order?

select name, count(*),order from Race;

Who donated? To which runner?

select Donor, firstName , runnerNumber from Donated;

Emergency contact for runner?

select phone from Runner;

Fastest time?

select MIN(timeRaceCompleted) from Runner;

Related Questions

Navigate

• Browse (All)
• Browse B
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.