Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Please help me and make sure to explain what each thing is (entity, attribute, relationship, etc). image text in transcribed
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

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

More Books

Students also viewed these Databases questions

Question

What key control concept was missing at Argus Productions?

Answered: 1 week ago