Transform the following data models into a relational database design. You may mark up the figures I have drawn or redraw them if necessary to transform them.

Place the foreign key(s) in proper location.

Identify the primary key(s) of all tables by placing a (PK) beside the attribute name(s).

Identify all foreign keys by placing a (FK) beside the attribute name(s).

State the referential integrity constraints for each relation

7. EMPLOYEE CAR VIN EmployeeNumber FirstName OfficeNumber OfficePhone Year Make Model RIDER RIDERIID HORSE HorseNumber FirstName Name Type Comment Age Phone Email Address RIDER RiderID SEMINAR SeminarNumber Name Phone Email Address T ime Location Description