Answered step by step
Verified Expert Solution
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 studios. We bring together a large selection of videos from over 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 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 ie 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 ie entitiesWhat do we know about these Things? ie attributesHow are these Things related?Draw an ER data model for the District MoviesRus database. Use the IE Crows Foot ER model for your ER diagrams. Justify the decisions you make regarding minimum and maximum cardinality.Use the appropriate SQL Statements to create a database based on the ER model created in task # Identify Primary and Foreign KeysEnforce Referential IntegrityEnter at least records per table.Ensure that the database is normalized. Use the appropriate SQL Statements to create and execute queries of your choice based on the tables and data within your database.Note: At least of the queries MUST span more than table.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started