Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw an ERD for PrimeFlix in IDEF1x format. Include all appropriate entities and relationships. Indicate primary keys and attributes for all entities. Include all ordinalities

Draw an ERD for PrimeFlix in IDEF1x format. Include all appropriate entities and relationships. Indicate primary keys and attributes for all entities. Include all ordinalities and cardinalities. PrimeFlix is a new online on-demand video service which streams specific movies and TV show episodes to its members. The company wants to set up a database to manage data related to its shows, customers, and stream orders. In order to become a PrimeFlix member, an individual must go online and register. Each customer must provide the company with their name, a credit card number, home address, e-mail address, and telephone number. Once registered, each customer will have an online profile which they can log on to if they need to update their billing data. As part of their profile, customers can also register their preferences for the types of movies or TV shows they wish to see, such as drama, comedies, documentaries, musicals, etc. PrimeFlix uses these preferences to suggest specific shows to their members. Once logged in, customers can browse listings of movies and shows and select any to view. PrimeFlix tracks the frequency by which its programs are viewed/streamed to assess the popularity of its inventory of programs. Sometimes a customer will halt a movie or TV show in mid-stream for some reason. A key feature of PrimeFlix is that the customer can on a later date return to the show and continue viewing it from the point where they previously halted it. Customers are billed to their credit cards for their subscription on a monthly basis. While the customers are not sent monthly bills or receipts, each payment is of course recorded for PrimeFlixs internal accounting purposes. This billing continues until a customer notifies PrimeFlix that they want to cancel their subscription. PrimeFlix has many corporate reporting needs. Not only do they wish to see their income from subscriptions, but they also want to look at regional differences in customer preferences for shows, the changing popularity of shows and genres over time, and - on a weekly basis - the top 5 movies and top 5 TV episodes that were streamed by their membership.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transact SQL Cookbook Help For Database Programmers

Authors: Ales Spetic, Jonathan Gennick

1st Edition

1565927567, 978-1565927568

More Books

Students also viewed these Databases questions