Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A start - up video / film streaming company hired you to develop a database to help company s business operation. As a first step,
A startup videofilm 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 informatiDescribe and draw an example ER model of each of the following concepts The examples should NOT be the ones in textbook or discussed in classppt posted
a a subtypesupertype structure
b a weak relationship
The companys primary business is prescriptionbased online streaming from a library of movies, including the ones produced inhouse. So far the company has over 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 collection, 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 inhouse, 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 actorsactress who played roles in these movies. The manager needs to know which actoractress is playing what role in a movie. Assuming each actoractress can only play one role in a movie but an actoractress can play in many movies. The payment to an actoractress varies depending on the role and the movie heshe plays in A role in a movie can be identifiedrecognized by the title, year of the movie and the characters name.Describe and draw an example ER model of each of the following concepts The examples should NOT be the ones in textbook or discussed in classppt posted
a a subtypesupertype structure
b a weak relationship
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started