Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Scenario: Elite Video is a startup company providing concierge DVD kiosk service in Kennesaw, GA. FIGURE P8.47 THE CH08_MOVIECO ERD DETAILRENTAL MEMBERSHIP PK MEM NUM
Scenario: Elite Video is a startup company providing concierge DVD kiosk service in Kennesaw, GA. FIGURE P8.47 THE CH08_MOVIECO ERD DETAILRENTAL MEMBERSHIP PK MEM NUM RENTAL RENT NUM PK,FK1 RENT NUM PK,FK2 VID 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 PK MOVIE NUM VIDEO VID NUM PK PRICE PK PRICE CODE VID INDATE FK1 MOVIE_NUM - 0--- PRICE_DESCRIPTION PRICE_RENTFEE PRICE_DAILYLATEFEE MOVIE_TITLE MOVIE_YEAR MOVIE COST MOVIE GENRE FK1 PRICE_CODE 9) List all information for members that are located in TN and have a balance greater than $10. (w3schools -> SQL And & Or) 10) List the title of the movies that are either action or drama. (w3schools -> SQL And & Or) 11) List only those members whose last names start with the letter 'M'. (w3schools -> SQL Like and SQL Wildcards) 12) List all return dates but do not display the column label (Detail. ReturnDate) - instead display a label of 'Returned' (w3schools -> SQL Alias) 13) Return the total of rent fee and daily late fee AS TOTALOne DayLate for every price code (w3schools -> SQL Alias) 14) List all video numbers for movie numbers 1235, 1237 and 1245 - use the IN keyword (w3schools -> IN) 15) List the member number for all members who rented a video on March 2, 2018. {Working with dates can be very tricky. In this database, the date datatype is simple - month-day- year. In Oracle, you will search using this format: 'dd-mmm-yyyy quote marks required: = '02-Mar-2018 In Access, you use the #key: = #02-Mar-2018# {Access will also allow #3/2/2018#} OPTIONAL: List all video numbers for videos returned between 01-Mar-18 and 05-Mar-18 (w3schools -> SQL between - the keyword between only works in Oracle - in Access you have to use >=#3/1/2018# AND
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started