Question

Scenario: Elite Video is a startup company providing concierge DVD kiosk service in Kennesaw, GA. FIGURE P8.47 THE CH08 MOVIECO ERD DETAILRENTAL MEMBERSHIP RENTAL PK MEM NUM PK,FK1 RENT NUM PK,FK2 VID NUM PK RENT NUM RENT DATE FK1 MEM_NUM MEM_FNAME MEM_LNAME MEM_STREET MEM_CITY MEM_STATE MEM_ZIP MEM_BALANCE DETAIL_FEE DETAIL_DUEDATE DETAIL_RETURNDATE DETAIL_DAILYLATEFEE MOVIE VIDEO PK MOVIE NUM PK VID NUM PRICE -0% PK PRICE CODE VID_INDATE FK1 MOVIE_NUM PRICE DESCRIPTION PRICE_RENTFEE PRICE_DAILYLATEFEE MOVIE_TITLE 0---06 MOVIE YEAR MOVIE_COST MOVIE GENRE FK1 PRICE_CODE

Answer 1

Solution

9)

SELECT Mem_FName, Mem_LName, Movie_Title FROM MEMBERSHIP

JOIN RENTAL ON MEMBERSHIP.Mem_Num = RENTAL.Mem_Num

JOIN DETAILRENTAL ON

RENTAL.Rent_Num = DETAILRENTAL.Rent_Num

JOIN VIDEO

ON DETAILRENTAL.Vid_Num = VIDEO.Vid_Num

JOIN MOVIE

ON MOVIE.Movie_Num = VIDEO.Movie_Num;

---

10)

SELECT Mem_FName, Mem_LName, Movie_Title FROM MEMBERSHIP

JOIN RENTAL ON MEMBERSHIP.Mem_Num = RENTAL.Mem_Num

JOIN DETAILRENTAL ON

RENTAL.Rent_Num = DETAILRENTAL.Rent_Num

JOIN VIDEO

ON DETAILRENTAL.Vid_Num = VIDEO.Vid_Num

JOIN MOVIE

ON MOVIE.Movie_Num = VIDEO.Movie_Num

WHERE Mem_FName = 'LEWIS'

AND Mem_LName = 'ROSALES';

---

11)

SELECT SUM(Detail_Fee), Mem_Num FROM DETAILRENTAL

JOIN RENTAL ON DETAILRENTAL.Rent_Num = RENTAL.Rent_Num

GROUP BY Mem_Num;

12)

SELECT SUM(Detail_Fee), Mem_Lname FROM DETAILRENTAL

JOIN RENTAL ON DETAILRENTAL.Rent_Num = RENTAL.Rent_Num

JOIN MEMBERSHIP

ON RENTAL.Mem_Num = MEMBERSHIP.Mem_Num

GROUP BY Mem_LName;

---

Answered all the queries

if you have any doubts, please mention, love to help

all the best