Following the ER notations learned in class, draw an ER diagram based on thefollowing user requirements. Please draw your ER diagram using MSPowerpoint or other diagramming tools. Submit a hard copy of your solution.

Continental Palms Video (CPV) is considering creating a database to keep track of variousaspects of the store. Impressed by your database knowledge and skills, the management of CPV has decided to hire you to design a conceptual data model.

CPV has various genres (Classic, Horror, Action, Comedy, Foreign, Educational, etc.) ofFilms for rent. Each film is uniquely identified by a Film ID. Each film is also described by atitle, a rate, and director(s). A film may have several directors. For some special genres offilms, more information is recorded. Each foreign film has a spoken language and a subtitlelanguage. Each educational film has a recommended age group. A film may be both foreign film and educational film.

To allow customers to search for films based on their preferred performers, CPV also records the information about performers: ID (identifier) and name. A film may have zero to manyperformers. Each performer performs a role in a film. A performer may perform in manyfilms. To be recorded in the database, a performer must perform in at least one film.

CPV carries one or more copies of each film. Each film must have at least one copy. Eachcopy belongs to one film. Each copy has a copy number that is unique among the copies of thesame film. But multiple copies of different film may have the same copy number. Other information about a copy includes its condition (e.g., broken).