SQL2

Carl H. Lindner College of Business

University of Cincinnati

IS-3030 Database Design

Homework Assignment #1: Conceptual Data Modeling

Based on the following narrative description, conduct the conceptual data modeling and draw an

Entity-Relationship diagram according to the requirements. You should specify the identifier and

other non-key attributes for each entity type. For relationship types, you should specify: (1) the

(min, max) cardinality ratios (you can use any representation notation), and (2) the relationship

attributes if it is appropriate to include them.

Tokyo 2020 Summer Olympics

You have been asked by the International Olympic Committee (IOC) to design a database for the

2020 Summer Olympics in Tokyo, Japan. IOC wants to keep track of information for each

participating country such as name, population, team color, continent, nation-anthem, the contact

person and the number of participants. Each participating country consists of athletes, referees

and delegates. IOC wants to keep track of information for all delegates such as passport#, name,

gender, title, and birthday.

For each athlete, IOC wants to keep track of the A#, passport#, name, birthday, gender, height,

years of participation and weight. For each referee, IOC wants to keep track of the passport#,

referee#, name, birthday, gender, years-of-participation, and areas-of-expertise.

Several games happen during the Summer Olympics. An example of a game is the men’s 400

meter. A game has several heats. IOC needs to keep track of the details of each heat. Heat

details include heat#, game name, and the number of athletes who participate in each heat. An

athlete can participate in many heats but must participate in at least one. You must record the

results of each athlete in each heat. The details for each athlete in each heat include the athlete’s

time and rank. In addition, you must record the winners (Gold, Silver, and Bronze) of each

game.

Referees are assigned to heats. Each heat should have at least one referee and a referee can be

assigned to more than heat. Heats are held in different facilities (e.g., Track & Field Arena) on

different dates. The detailed information of each facility such as name, location, capacity, ower

and available transportation services must be recorded for reference.

Note:

The specifications given above are quite comprehensive, but of course not complete. If you need

clarification or additional information, please feel free to ask the instructor. Another option is to

make reasonable assumptions and state them to support your conceptual data modeling. None of

the assumptions you make can nullify or contradict the business rules stated above.

Deliverable:

Entity-Relationship diagram of your conceptual data modeling (I will not accept late homework.)

It is preferable to draw your ER diagram using a software tool (e.g., MS Visio).

This is an individual homework assignment.