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

Question

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

Explanation / Answer

Please find the below table structure based on the above diagram.

PERFORMER(StageName,RealName,Country)
Stage Name is Primary Key Here.

A performer performs a fim so to keep that relation, FilmPerformer table.
FilmPerformed(FilmId,StageName)
Primary Key(FilmId,StageName)
FilmId is foreign key to Film table.
Stage name is foreign key to Performer table.

FILM(FilmID, Title,Date,Distributor,Director,genreType)
FilmId is primary key.
generType is a foreign key references to Genertype table to get the details on each genre.

A film can belong to any genre, so there would be GenreType Table
Genertype(ZenreType, ZenreTypeId)
Primary key is ZenreType
Foreign Key is ZenreTypeId references to Education,Musical and Foreign table Primary key.

EDUCATION(E_ZenerTypeId,AgeGroup)
Primary Key:E_ZenerTypeId

MUSICAL(M_ZenerTypeId,Coposer)
Primary Key:M_ZenerTypeId

FOREIGN(F_ZenerTypeId,SubTitleLanguage,SpokenLanguage)
Primary Key:F_ZenerTypeId

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.