Test 1 version 2 part a

2 Pages
Unlock Document

Electrical Engineering and Computer Science
EECS 1520
Heather Jenkins

Part D [5 points] The following schemas describe relations in the sample database in CS:I. A) Movie (MovieId:key, Title, Genre, Rating) B) Customer (CustomerId:key, Name, Address, CreditCardNumber) C) Rents (CustomerId, MovieId, DateRented, DateDue) D) NEW ← SELECT from MOVIE where RATING = “PG” E) PGmovies ← PROJECT MovieId, Title from NEW F) TEMP1 ← JOIN CUSTOMER and RENTS where CUSTOMER.CustomerId = RENTS.CustomerId G) RENTALS ← PROJECT Name, Address, MovieId from TEMP1 H) PGrenters ← JOIN RENTALS and PGmovies where RENTALS.MovieId = PGmovies.MovieId For each relation below, select its schema from the list above. _____A MovieId Title Genre Rating 101 Sixth Sense, The thriller, horror PG-13 102 Back to the Future comedy adventure PG 1033 Monsters, Inc. animation, comedy G 104 Field of Dreams fantasy drama PG 105 Alien sci-fi horror 107 X-Men action, sci-fi PG-13 ... 7442 Platoon action drama war R _____C CustomerId MovieId DateRented DateDue 101
More Less

Related notes for EECS 1520

Log In


Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.