Question: Please help me and make sure to explain what each thing is (entity, attribute, relationship, etc). Mini-world A company that provides video streaming wants you
Mini-world A company that provides video streaming wants you to model a database for the company's OLTP. The information you have to do so is as follows: There are users of the platform each with a username, password, email address and credit card number. Users can be either persons or organizations (like a hotel). For an organization we will store the number of employees, and for persons their physical address. . Users can rent movies. For each movie, we know the name, description, country of origin, the movie cast, available languages (audio and subtitles), and a unique movie number within the system Each movie may have one or more genres We also know the list of preferred genres for each user. The system should store which movie was rented for each user, the rent period and the cost of that rental. A user can rent a movie more than once. For the cast, we know the actor's name and fictional name for each actor in each movie. Each user can provide a single rating for each movie the user rented. To Do 1) Using the Enhanced Entity-Relationship (EER) Model, and following the notation discussed in class, present an EER Model for the database. Include all possible structural restrictions as well as all non-structural restrictions. [40 marks 2) Translate the presented EER to Relational Model using the mappings discussed in class. Indicate the primary key, alternate keys (if any) and foreign keys. Present all major non- structural constraints for the model. [60 marks Making assumptions is acceptable as far those are well documented and do not contradict what is described in the mini-world description
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
