CSC 455                                                  NAME:

Fall 2009

Lab 6                                                      

10 points

 

Oval: DateOval: TitleFrom the Olympic facilities description in Lab 4, a possible EER diagram is given below.  Give three possible schemas that correspond to three different ways of handling specialization (Options A, B, and C):

SPORTS COMPLEX

 
Oval: NameOval: LocationOval: Max
Occupancy
Oval: d

ONE-SPORT

 

MULTI-SPORT

 
Oval: VenueOval: Area

EVENT

 
Diamond: HostsOval: Num
Participants
Oval: Duration

1

 

M

 

Official

 
Diamond: Judges

N

 

M

 
Oval: Last nameOval: First nameOval: PhoneOval: NationalityOval: IDDiamond: Chief Organizer

1

 

M

 
(Why isn’t D an option here?)