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
