Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Reservation begin{tabular}{|r|r|r|r|r|} hline ReservationID & multicolumn{1}{c}{ CustomerID } & multicolumn{1}{c|}{ VehiclelD } & multicolumn{1}{c|}{ Start Date } & multicolumn{1}{c|}{ Return Date } hline 798798

image text in transcribed

Reservation \begin{tabular}{|r|r|r|r|r|} \hline ReservationID & \multicolumn{1}{c}{ CustomerID } & \multicolumn{1}{c|}{ VehiclelD } & \multicolumn{1}{c|}{ Start Date } & \multicolumn{1}{c|}{ Return Date } \\ \hline 798798 & 56544 & 4878 & 1/20/20 & 1/21/20 \\ \hline 878899 & 56555 & 4666 & 1/15/20 & 1/27/20 \\ \hline 987777 & 56578 & 4533 & 1/16/20 & 1/19/20 \\ \hline 896674 & 56577 & 4202 & 1/18/20 & 1/21/20 \\ \hline 849456 & 56588 & 4989 & 1/19/20 & 2/5/20 \\ \hline 489898 & 56511 & 4263 & 1/20/20 & 2/6/20 \\ \hline \end{tabular} Inventory \begin{tabular}{|l|l|l|l|l|} \hline \multicolumn{1}{|l|}{ MehiclelD } & Model & Year & Color \\ \hline 4878 Ford & Taurus & 2019 Silver \\ \hline 4666 BMW & X5 & 2020 Black \\ \hline 4533 Honda & Accord & 2019 Grey \\ \hline 4202 Honda & Civic & 2018 Yellow \\ \hline 4989 Toyota & Prius & 2019 Red \\ \hline 4263 Toyota & Prius & 2020 Grey \\ \hline 4898 Toyota & Prius & 2018 Silver \\ \hline \end{tabular} Please provide the SQL (or T-SQL) statements (in your preferred syntax) 1. A customer calls and asks how many Toyota Prius's the Car Rental Store has in inventory. 2. A customer calls and asks if the Car Rental Store will have any cars available on January 20th, which cars are available? 3. A customer returns VehicleID 4898 totalled and now the Car Rental Store must remove it from the inventory. 4. The corporate office sends the Car Rental Store a new car to add to its inventory, a 2020 red BMW X7. Hint: The sequence name is 'Vehicle_Se

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managing Your Information How To Design And Create A Textual Database On Your Microcomputer

Authors: Tenopir, Carol, Lundeen, Gerald

1st Edition

1555700233, 9781555700232

More Books

Students also viewed these Databases questions

Question

=+ Are there additional forms of employee representation?

Answered: 1 week ago