Figure 4-36 includes an EER diagram describing a scenario where groups of institutes organizes workshops. 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.

lisher specializing in large edited works. Transform the FIGURE 4-36 EER diagram for a car racing league ORGANISING INSTITUTES WORKSHOP WorkshopID Theme/Technology Start Date End Date PARTICIPANT ParticipantiD InstitutelD Affiliatinglnstitute ContactNo Email Designation ContactNo Address PAYMENT PaymentlD Charges DateOfPayment ModeOfPayment CHARGES Designation Rate