Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

We have this relation Movie (Title, Year, Length, Actor, Genre, Studio, Rating, City_Studio) Title Year Length Actor Genre Studio Rating City_Studio Jaws Horror Universal R

image text in transcribed

image text in transcribed

We have this relation Movie (Title, Year, Length, Actor, Genre, Studio, Rating, City_Studio) Title Year Length Actor Genre Studio Rating City_Studio Jaws Horror Universal R Hollywood Jaws 1975 1975 1975 124 124 124 Roy Schneider Robert Shaw Richard Dreyfus Horror Universal R Hollywood Jaws Horror Hollywood Universal Fox Alien Sigourney Weaver Sci-Fi Hollywood Mary Poppins Musical Disney Buena Vista Buena Vista Mary Poppins Ben Hur Ben Hur 1979 1964 1964 1959 1959 1984 1984 117 139 139 212 212 105 105 Julie Andrews Dick Van Dyke Charlton Heston Martha Scott Sigourney Weaver Bill Murray Musical History History Fantasy Fantasy Disney MGM MGM Columbia Columbia Hollywood Hollywood PG-13 PG-13 PG PG Ghostbusters Culver City Ghostbusters Culver City Where: - A movie can have different versions in different years but not with the same actor - Example, you can have Jaws in 1975 and Jaws in 2019 but Roy Schneider can't be in both . The rating can be different in the different versions of the same movie - So Jaws 1975 can be R and Jaws 2019 can be PG-13 - A movie can have only one Genre - Example, Alien is just sci-fi - A movie can not have different versions in the same year. . Example, we can't have two Jaws in 1975 - An actor can be in more than a movie the same year . Example: Charlton Heston can be in Ben Hur in 1959 and in Harry Potter in 1959 too (I know...I know... it is just an example) There is not any Studio with the headquarters in more than one city, but we can have 2 studios in the same city. . So, Universal can not be in Hollywood and in any other place, and MGM can be in Hollywood too. . An actor can work with more than one studio. . Example: Bill Murray can work in a Columbia's Movie and for MGM's movie QUESTIONS A, Use: Title - T, Year - Y, Length - L, Genre - G, Studio - S, City_Studio-C, Actor Rating R 3) a- Is Movie in 1NF? Is Movie in 2NF? Is it in 3NF? Is it in BCNF? Explain why in each case. (5p) b- If it is not in BCNF, design it in a way that is in BCNF. Go step by step and explain all the steps, the reasons to take them and the functional dependencies involved in the decisions. (20p)

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

Successful Keyword Searching Initiating Research On Popular Topics Using Electronic Databases

Authors: Randall MacDonald, Susan MacDonald

1st Edition

0313306761, 978-0313306761

More Books

Students also viewed these Databases questions