User (Business) Requirements NetFlicks (NF) (not to be confused with Netflix) needs to create a database to manage the operations of their online movie streaming service. NF has the following genres of Films for streaming: Foreign, Educational. Each film is uniquely identified by a Film ID. Each film also has a title, a rating, and director(s). A film may have several directors. Each foreign film has a spoken language. Each educational film has an educational topic. A film may be both a foreign film and an educational film. To allow customers to search for films based on their preferred actors, NF also records the information about actors: ID (identifier) and name. A film may have zero to many actor. Each actor performs a role in a film. An actor may perform in many films. To be recorded in the database, an actor must perform in at least one film. NF carries one or more versions of each film (i.e. language version, directors cut, bonus features). Each film must have at least one version. Each version belongs to one film. Each version has a version number that is unique among the versions of the same film. Other information about a version includes its length, features, and language.

Conceptual Modeling

Analyze the User (Business) Requirements

Following the crow's foot notation covered in the lectures, create an ER diagram based on the User (Business) Requirements. It is highly recommended that students use Draw.io or Lucid Chart to create their ER Diagrams.