Question

MySQL data model:

Netflix would like for you to build them a data model that tracks the following information:

Netflix would like to track the television shows that are watched by subscribers to the service. Subscribers of the service may watch more than one TV show. Shows may be watched by more than one subscriber. For television shows, they would like to track the episodes that comprise the show. Subscribers to the Netflix service watch episodes of various shows and Netflix would like to store and track their watching of episodes. Shows may belong to a variety of categories/genres and Netflix would like to represent that relationship as well.

About the subscriber, Netflix would like to store, customer pertinent information such as name, home address, billing address, card information, contact information (you can be as specific as you like). Netflix would like to track the show’s name, MPAA rating, number of seasons and genres. Netflix would like to track information for episodes (related to a show) such as the episode name, episode description and run time for an episode and the percentage of the episode a user may have watched.

Draw a data model in MySQL workbench that tracks all this information. Make sure you include all relevant information in the data model for instance attributes, entities, keys, datatypes, relationships, etc

USE ANY SOFTWARE OR JUST SKETCH IT.

Answer 1

Underlined attributes are primary keys, and attributes with # in the beginning describe foreign key references.

One subscriber can watch multiple episode of different TV shows at a time and one episode can be watched by multiple subscribers at the same time. So here we have many to many relationship. In case of a many to many relationship, a new table will be maintained to describe the relationship, i.e. we would require a table for watches relationship.

One genre can have many TV shows, so it has many to one relationship

One TV show can have many episodes, so many to one relationship in that case.