Overview: This assignment involves designing a database using the ER model. Below is a description of the data to be stored. Based on this description you will build an ER design for the database. Project Statement: The streamTV video streaming service wants to store information about television shows that they stream. They also want to store information about customers who have memberships and who watch the shows through the streaming service. You are in charge of designing a conceptual database schema (Entity-Relationship Diagram) that reflects the company's information needs. Data Description: The following is a list of the data that must be stored in the database. Each TV show has a title, the year it was first broadcast, the name of the show's creator, the network on which the show appeared, and the category (comedy, drama, etc). Each show is made up of several episodes. An episode has a title and original airdate. Note: for the purpose of simplicity, the database will NOT represent seasons of the TV shows. Each actor has a name, made up of a first name and a last name. Each TV show also has two types of the cast. The main cast is made up of actors who are regulars on the show. The recurring cast is made up of actors who have appeared in multiple episodes of the show. In both of the types of the cast, the role that the actor plays in the show should be represented. Customers will sign up with the streamTV service to watch episodes of the available shows. Each customer has a name, a credit card number, an email address, a date on which the customer became a member, and a date on which the customer's membership needs to be renewed. Each customer can choose one or more TV shows to add to his/her queue. The database should keep track of the date that the show was placed in the queue. Each customer can watch episodes of the TV shows. The database should keep track of the dates on which the episodes have been watched. Q3.1 10 Points Identify reasonable integrity constraints that you are unable to capture using the ER modeling constructs. State them in natural language and give a brief explanation why you could not express them in the ER schema. Enter your answer here Save Answer Q3.2 10 Points Briefly identify the relations (tables) you can derive from your ER diagram. Use thefollowing notation, underlining the key attributes: (You could also star the primary keys) Table/Relation_Name (Attribute1, Attribute2, ..., AttributeN) Enter your answer here Please select file(s) Select file(s) Save Answer Q3.3 10 Points Are there any relationship types in your ER design for which you do not need a table in the relational mapping? Why? Explain your answer. Enter your answer here
