Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

MoviesRus is an online video service that offers a selection of hit movies at moviesrus.com, and on numerous devices such as PCs , smartphones, and

MoviesRus is an online video service that offers a selection of hit movies at moviesrus.com, and on numerous devices such as PCs, smartphones, and TVs. We continue to add new devices daily. Our subscription service allows individuals to view unlimited movies for a minimal monthly fee. Our programming is provided by more than 100 studios. We bring together a large selection of videos from over 260 content companies, including Twentieth Century FOX, Disney, MGM, Lionsgate, National Geographic, Paramount, Sony Pictures, Warner Bros., and more. Users can choose from current hits such as Avatar and Transformers 2, as well as classics such as War of the Worlds, and Casablanca. You are tasked with creating a database to modernize the inventory control and distribution of content. In order to complete this task, you must first establish a complete list of the user requirements (i.e., establish business rules, use cases, build an appropriate data model, etc.). You can rely on competitors such as Netflix, Hulu.com, and Amazon Instant Video for guidance. These sites offer similar services and can provide information on things that you may want to include in your database.FINAL PAPER TOPICDatabase CreationTASKS TO BE COMPLETEDRecord all relevant business rules. Identify the Things of Interest (i.e., entities)What do we know about these Things? (i.e., attributes)How are these Things related?Draw an E-R data model for the District MoviesRus database. Use the IE Crows Foot E-R model for your E-R diagrams. Justify the decisions you make regarding minimum and maximum cardinality.Use the appropriate SQL Statements to create a database based on the E-R model created in task #5. Identify Primary and Foreign KeysEnforce Referential IntegrityEnter at least 5 records per table.Ensure that the database is normalized. Use the appropriate SQL Statements to create and execute 5 queries of your choice based on the tables and data within your database.Note: At least 2 of the queries MUST span more than 1 table.

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

Beyond Big Data Using Social MDM To Drive Deep Customer Insight

Authors: Martin Oberhofer, Eberhard Hechler

1st Edition

0133509796, 9780133509793

More Books

Students also viewed these Databases questions