Convert the following conceptual schema into a relational schema. List all the tables and attributes. Clearly specify primary keys and foreign key references.

Note: Please use proper notation when listing tables in your relational schema. For example:

Instructor (InstructorID, Lname, Fname, Office)

Course (CourseID, Title, Credits, InstructorID)

InstructorID is a foreign key references Instructor.InstructorID

You could also use dash underline to represent a foreign key if the foreign key has the same name as the primary key it references to.

1.

PERFORMER Stage Name RealName Country EDUCATION Age Group FILM Film ID Title Date Distributor Director MUSICAL composer FOREIGN Subtitle Language Spoken Language PERFORMER Stage Name RealName Country EDUCATION Age Group FILM Film ID Title Date Distributor Director MUSICAL composer FOREIGN Subtitle Language Spoken Language