MoviesRus is an online video service that offers a selection of hit movies at mo

Question

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.

Database Creation

TASKS TO BE COMPLETED

1. Record all relevant business rules.

2. Identify the Things of Interest (i.e., entities)

3. What do we know about these Things? (i.e., attributes)

4. How are these Things related?

5. Draw an E-R data model for the District MoviesRus database. Use the IE Crow’s Foot E-R model for your E-R diagrams. Justify the decisions you make regarding minimum and maximum cardinality.

6. Use the appropriate SQL Statements to create a database based on the E-R model created in task #5.

          a. Identify Primary and Foreign Keys

          b. Enforce Referential Integrity

          c. Enter at least 5 records per table.

          d. Ensure that the database is normalized.

7. 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.

Explanation / Answer

Business rules:

1. There are users which subscribe to watch movies at moviesrus.com

2. Users can view videos as per their device

3. Videos are available in portal from vaiours content companies like Twentieth Century FOX, Disney, MGM, Lionsgate, National Geographic, Paramount, Sony Pictures, Warner Bros.etc.

They can be categorized into Classics, Current hits based on the year of release

4. Videos can be sourced from either TV Shows or they can be Movies or others, any video can belong to only one category

5. User can add rating to each video as per their feedback, and average rating is stored in the database

6. Videos can be categorized on the basis of genre as well, one video can belong to only one genre

Part 2: Entities

a. Users: Individuals who are going to use the system

b. Subscriptions: Subscriptions available and their information

c. Devices: Devices supported

d. Genre: All the genre for which videos are available

e. VideoType: Classic or current

f. Video: All information with regards to a video

g. ContentCompanies: Details of content company which own the videos

h. PaymentDetails: Information used in purchasing a subscription

Part 3: Attributes

User: UserID, UserName, Address, PhoneNumber

Subscription:SubscriptionID, SubscriptionName, Subscription details

Devices: DeviceID, DeviceName, Resolution

Genre: GenreID, GenreName

VideoType: TypeID, CategoryName, YearRange

Video: VideoID, VideoName, VideoLink/Referencelocation, TypeID, GenreID, Resolution, ContentCompanyID, AvgRating

ContentCompany: ContentCompanyID, Company name

PaymentDetails: CardNumber, Bank Name, User ID

Part 4: Relationships

USer views videos: UserID->VideoID (Many to many)

Video belongs to a Genre (VideoID->GenreID)

Video has a video type (VideoID -> TypeID)

User has Payment information (UserID->CardNumber)

Video belongs to a contentcompany (VideoID-> ContentCompanyID)

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.