[Solved]Corner Video Small Movie Rental Company Single Store Uses Database System Track Rental Mo Q37237465
Corner Video is a small movie rental company with a single store. . It uses a database system to track the rental of movies to its members. Corner Video owns several copies (VIDEO) of each movie (MOVIE). For example, the store may have 5 copies of the movie Men in Black. In the database, Men in Black would be one MOVIE, and each copy would be a VIDEO A rental transaction (RENTAL) involves one or more videos being rented to a member (MEMBERSHIP). Each rental by a customer can include 1 or many videos and each video can be rented 0 to many times (by the same or different members), therefore, there is a M:N relationship between RENTAL and VIDEO. DETAILRENTAL is the bridge table to resolve this relationship-and each row represents a video rented by the member in a rental transaction. The complete Relationship Report is provided below DETAILRENTAL MEMBERSHIP RENTAL PK,FK1 RENT NUM PK.FK2 VİDNUM PK MEM-NUM PK RENT NUM DETAIL FEE DETAIL DUEDATE DETAIL RETURNDATE DETAIL DAILYLATEFEE RENT DATE MEM LNAME MEM STREET MEM CITY MEM STATE MEM ZIP MEM BALANCE FK1 MEM NUM MOVIE VIDEO PRICE MOVIE TITLE MOVIEYEAR MOVIE COST MOVIE GENRE VID INDATE FK1 MOVIE NUM PK PRICE CODE PRICE DESCRIPTION PRICE RENTFEE PRICE DAILYLATEFEE FK1 PRICE CODE Write a SQL to produce the result set described in the following statements. Each query is worth 2 points. Partial credit is given so include the SQL in your script file- even if it doesn’t produce a result set. Note -my screen shots are only intended to give you an idea if you are on the right track. They do not display the data properly formatted, and in many cases, on display the first 10 12 rows of data. List all members who have not made a rental. Order by last name. 8. MEM NUMMEM.FNAMEMEM INAME 1 106 MIRANDA NOGO 2 109 CLINT OCHOA 3 i 12 LUIS TRUJILLO Show transcribed image text Corner Video is a small movie rental company with a single store. . It uses a database system to track the rental of movies to its members. Corner Video owns several copies (VIDEO) of each movie (MOVIE). For example, the store may have 5 copies of the movie Men in Black. In the database, Men in Black would be one MOVIE, and each copy would be a VIDEO A rental transaction (RENTAL) involves one or more videos being rented to a member (MEMBERSHIP). Each rental by a customer can include 1 or many videos and each video can be rented 0 to many times (by the same or different members), therefore, there is a M:N relationship between RENTAL and VIDEO. DETAILRENTAL is the bridge table to resolve this relationship-and each row represents a video rented by the member in a rental transaction. The complete Relationship Report is provided below DETAILRENTAL MEMBERSHIP RENTAL PK,FK1 RENT NUM PK.FK2 VİDNUM PK MEM-NUM PK RENT NUM DETAIL FEE DETAIL DUEDATE DETAIL RETURNDATE DETAIL DAILYLATEFEE RENT DATE MEM LNAME MEM STREET MEM CITY MEM STATE MEM ZIP MEM BALANCE FK1 MEM NUM MOVIE VIDEO PRICE MOVIE TITLE MOVIEYEAR MOVIE COST MOVIE GENRE VID INDATE FK1 MOVIE NUM PK PRICE CODE PRICE DESCRIPTION PRICE RENTFEE PRICE DAILYLATEFEE FK1 PRICE CODE Write a SQL to produce the result set described in the following statements. Each query is worth 2 points. Partial credit is given so include the SQL in your script file- even if it doesn’t produce a result set. Note -my screen shots are only intended to give you an idea if you are on the right track. They do not display the data properly formatted, and in many cases, on display the first 10 12 rows of data.
List all members who have not made a rental. Order by last name. 8. MEM NUMMEM.FNAMEMEM INAME 1 106 MIRANDA NOGO 2 109 CLINT OCHOA 3 i 12 LUIS TRUJILLO
Expert Answer
Answer to Corner Video is a small movie rental company with a single store. . It uses a database system to track the rental of mov… . . .
OR
