Question: Please make an ER Diagram for this problem!! A smaller content film streaming company hired you to develop a database to help companys business operation.
Please make an ER Diagram for this problem!!
A smaller content film streaming company hired you to develop a database to help companys business operation. As a first step, you need to create an ER model to reflect the information requirements of this database based on the following information:
The companys primary business is prescription-based online streaming from a library of movies, including the ones produced in-house. So far the company has over 2 million subscribers. The company needs to keep track of each subscribers information such as account number, name, email address, credit card number, location, etc. It is important for the company to keep track of streaming activities for each subscriber (account). Because the company wants to know what movies a subscriber streamed in the past for analytics purpose. The company needs to keep track of the information of all movies in its library, such as title of the movie, description, names of director and producer, year of production, etc. In recent years, the company produced some movies by itself. For each movie produced in-house, the company needs to know who are investors, if there is any, including their contact information, and amount of money they invested in a movie. The company also needs to keep track of the contact information (name, email, phone, etc.) of all actors/actress who played roles in the movies. The manager needs to know which actor/actress is playing what role in a movie. Assuming each actor/actress can only play one role in a movie but an actor/actress can play in many movies. The payment to an actor/actress varies depending on the role and the movie he/she plays in. A role in a movie can be recognized by the characters name and type of character (main or supporting character).
Again, I need an ER diagram for this problem and please give explanation! thanks! Will give like!
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
