Reservation ReservationID CustomerID VehicleID Start Date Return Date 4878 1/20/20 1/21/20 4666 1/15/20 1/27/20 4533 1/16/20 1/19/20 4202 1/18/20 1/21/20 4989 1/19/20 2/5/20 4263 1/20/20 2/6/20 798798 878899 987777 896674 849456 489898 Inventory VehicleID Make 56544 56555 56578 56577 56588 56511 Model Taurus X5 Accord Civic Prius Prius Prius Year Color 2019 Silver 2020 Black 2019 Grey 2018 Yellow 2019 Red 2020 Grey 2018 Silver 4878 Ford 4666 BMW 4533 Honda 4202 Honda 4989 Toyota 4263 Toyota 4898 Toyota 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_Seq
Reservation ReservationID CustomerID VehicleID Start Date Return Date 4878 1/20/20 1/21/20 4666 1/15/20 1/27/20 4533 1/16/20 1/19/20 4202 1/18/20 1/21/20 4989 1/19/20 2/5/20 4263 1/20/20 2/6/20 798798 878899 987777 896674 849456 489898 Inventory VehicleID Make 56544 56555 56578 56577 56588 56511 Model Taurus X5 Accord Civic Prius Prius Prius Year Color 2019 Silver 2020 Black 2019 Grey 2018 Yellow 2019 Red 2020 Grey 2018 Silver 4878 Ford 4666 BMW 4533 Honda 4202 Honda 4989 Toyota 4263 Toyota 4898 Toyota 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_Seq
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
100%
please answer with proper explanation and step by step solution.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education