Figure 4-36 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-36

Transcribed Image Text:

TEAM DRIVER Belongs To Driver D Team ID Team Name Team Manager Driver Age Driver Name PARTICIPATION Points Eaned FINISH Position Result RACE RACE COMPONENT RC ID Race ID Race Titie Race Location Race Date Consists OfRC Type