how to create a lucid ER diagram of a movie scenario

Question

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.

1. Analyze the User (Business) Requirements
2. Following the crow's foot notation covered in the lectures, create an ER diagram based on the User (Business) Requirements.

Answer 1

Hello

I am 20 years experienced Online Tutor and Assignment Helper for Math and Computer Science. I teach PHP, MySQL, Programming in C, C++, Java, ASP, C#.NET, Visual Basic, Oracle, HTML, VBScript, JavaScript, Data Structures, MS Office. I have teaching experience of teaching IT Professionals , students from different grades, graduate and post graduate classes for more than 20 years.

Presently I am teaching students online, providing homework assignment help, provide help in online tests for the students from USA ,UK, Canada, New Zealand, Germany, Australia, Malaysia, Austria, Malta, Saudi Arab etc. Also, I am in Software Development and Web Designing. I have helped more than 1200 students from different countries in last 20 years.

I have checked the details of your assignment and I will get it done for you urgently.

For further discussion feel free to message me on Skype as I dont work on this website and id is nettuitions

Thanks