Figure 4-35 includes an EER diagram describing a car racing league. Transform the diagram into a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema). In addition, verify that the resulting relations are in 3NF.

Figure 4-5

Figure 4-35

 

Patient # Name First Seen Social Worker | Visit Date Visit Time Reason for Visit New symptoms Severe leg pain for past 2 days Level of Pain Severe leg pain 9844 John Miler 10/1/2008 Matt Baker 10/11/2009 2:30 pm 10/18/2009 11:30 am Follow-up, also need flu shot None 2 1/3/2010 10 am Routine None 3/15/2010 10:30 am Routine None 1/3/2009 Lynn Riley 1/3/2010 Referred by Primary care physician Physical 4211 Sheryl Franz 2 pm 2/11/2010 9 am None Greater difficulties with writing & buttoning shirts 3/22/2010 4:00 pm Routine and 1 B12 Shot 8766 Juan Ortega 2/2/2009 Matt Baker 2/2/2010 9:30 am Blurred vision in right eye Follow-up 2/14/2010 9:30 am New symptoms Pins/needles in both legs; trouble with balance 3/18/2010 ???? MVCH FIGURE 4-5 MS Center patient sign-in data