EECS 1520 Study Guide - Midterm Guide: Chris Stein, Randy Wolf

32 views2 pages
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.
_____B
CustomerId Name Address CreditCardNumber
101 Dennis Cook 789 Main 993726762357
102 Doug Nickle 456 Second 632783087764
103 Randy Wolf 12 Elm 854072657547
104 Amy Stevens Yellow Brick Road 184585788722
105 Susan Klaton 654 Lois Lane 537212603203
106 Dale Evans 987 Broadway 053118262075
107 Chris Stein 1010 Abbey Road 862175961142
_____C
CustomerId MovieId DateRented DateDue
101 102 08/11/2010 15/11/2010
103 104 07/11/2010 10/11/2010
105 1033 04/11/2010 13/11/2010
102 101 09/11/2010 11/11/2010
101 104 04/11/2010 14/11/2010
104 107 05/11/2010 10/11/2010
103 102 05/11/2010 11/11/2010
107 7442 06/11/2010 13/11/2010
dbSchemas1
Unlock document

This preview shows half of the first page of the document.
Unlock all 2 pages and 3 million more documents.

Already have an account? Log in

Get OneClass Grade+

Unlimited access to all notes and study guides.

Grade+All Inclusive
$10 USD/m
You will be charged $120 USD upfront and auto renewed at the end of each cycle. You may cancel anytime under Payment Settings. For more information, see our Terms and Privacy.
Payments are encrypted using 256-bit SSL. Powered by Stripe.