CSC 455 NAME:

Fall 2009

Lab 4

10 points

A simplified version of the organization of Olympic facilities is described below. Draw an EER diagram that shows entity types, attributes, relationships, and specializations.

· Olympic facilities are made up of sport complexes

· Each sports complex is either a one-sport or a multi-sport type

· A one-sport complex has a primary venue (e.g. swimming)

· Multisport complexes have areas of the complex designated for each sport (e.g. center, NE corner, etc.)

· A complex has a name, location, a maximum occupancy, and a chief organizing individual

· Each complex hosts one or more events.

· For each event there is a title, a planned date, duration, number of participants.

· A roster of officials is maintained together with the list of events each official will be involved in.

Draw the EER diagram below: