Subject: University Gymnastics
Question: A university gymnastics team is interested in maintaining information about its
current schedule and meet performance.

The team is made up of 10 gymnasts.

Gymnast information includes name, major, and hometown.

The team competes in meets many times during the season.

Meet information includes date, location, and score.

Meets consist of four events: vault, beam, floor, and uneven bars.

The final team score is an aggregation of event scores, and event scores are aggregated
individual gymnast scores.

A Meet can have one or more opponents.

The team faces each opponent only once during the season.

A gymnast can compete in all or some of the events, though the team is limited to 5
participants in each event.

Gymnasts can only compete in events for which they are trained.

Barry says the Things of Interest are :-
   A.1 Competitors
   A.2 Competitions
   A.3 Teams
   A.4 Universities
   A.5 Others to be determined

B. How are they related ?
   B.1 A Competitor can be in zero,one or many Teams.
   B.2 A Team can take part in zero,one or many competitions.
   B.3 Others to be determined.




Barry Williams

June 7th. 2011

Principal Consultant

Database Answers