You will construct an entity-relationship diagram and translate it into SQL statements, as described in lecture. We will provide you with a high-level description of the entities, their attributes, and their relationships. For each relationship, describe the type of relationship (One-to-many, many-to-one, etc) and any participation constraints. For each entity set describe any key constraints. Make sure to annotate which entity sets are weak entities, and any aggregated relationships. Using drawing programs such as Inkscape will be a big help. You may also handwrite and scan, but it must be legible for credit. For the SQL part, make sure that your SQL statements are consistent with your ER diagram and reflect all applicable constraints.

Netflix is a widely popular media distribution platform. Netflix hosts two different kinds of content, TV Shows and Movies. Each of these has a rating, a genre, and a name. Movies have a length in minutes and TV shows have a count of the number of seasons. These TV shows are composed of seasons, each season is identified by its season number and the number of episodes. These two types of content are both created by actors/actresses, writers, and production studios. Actors/Actresses are both types of people that have names, and ages. These people work with the production studios which each have an address and a number of employees.