Scenario

Assume you are assisting the coaching staff by designing a database to document results for each event in the district track meets (multiple meets at multiple locations). Student athletes may participate in multiple running events and multiple field events. Your design should track information about coaches. Your database should track the student winners in first through third place for each event.

Design ALL Tables needed to build a database solution for the scenario described above. Be sure to follow principles of geed design (normalize) as you go. Describe the tables in TEXT format (identify foreign keys in some way that is clearly visible if you don’t like italics):

TABLE(PrimaryKey, attribute, attribute)

Assumptions: Make and state assumptions as needed. Be sure your design reflects these assumptions.

Draw the ERD

Go ahead and SHOW foreign keys in your entities on the ERD even though they are not technically supposed to be there. LABEL relationship lines with words, be sure to mark cardinality (min and max on both ends of each line).

Describe the Table Structure of each table.

Academic Honesty!
It is not our intention to break the school's academic policy. Projects posted are only used as a reference and should not be submitted as is. We are not held liable for any misuse of the solutions. Please see the frequently asked questions page for further questions and inquiries.
Kindly fill out the form. Please provide a valid email address and we'll get back to you in less than 24 hours. We will be sending an invoice through PayPal upon confirmation. We are a non profit organization however we need an amount to keep this organization running, and to be able to complete our research and development.