Transform the diagram below into a relational schema the sho

Transform the diagram below into a relational schema the shows referential integrity constraints

Click open image in new tab.

TEAM eam ID Team Name (Color) Competitor MEET Meet ID Meet Name Location Date Captain Member PARTICIPATION Place Points Time SWIMMER Swimmer ID Swimmer Name (First Name, Last Name) Email DOB ZA Phone EVENT Event ID Event Name Event Description

Solution

Relational schema

TEAM

TEAM ID

DRIVER

PARTICIPATION

RACE

FINISH

DriverID

RACE COMPONENT

TEAM ID

TEAM NAME

TEAM MANAGER