Update a driver's record using the ACTIVE_DRIVERS VIEW.
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
The Driver Relationship team wants to update the driving license id of an active driver:
- Driver ID: 2003, New Driving License ID: 1735488
In addition, the team wants to do the update over the VIEW and also want to see the actual change in the DRIVERS table.
Task
Update a driver's record using the ACTIVE_DRIVERS VIEW.
![In the USERS table, information for the users are stored with their first name, last name and
email:
USER ID
USER LAST NAME
USER EMAIL
USER FIRST NAME
3001
Jack
Hill
Lhillexmal.com
3002
Ryan
Collins
r.collins@xmail.com
3003
Nursin
Yilmaz
n.atak@gmail.com
3004
Sarah
Price
s.price@xmail.com
3005
Bobby
Griffin
bgriffinexmail.com
3006
Randy
Clark
r.clark@xmail.com
3007
Jose
Thomas
j,thomas@xmail.com
3008
Nursin
Yillmaz
n.yilmaz@xmal.com
USERS Table
In the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving
license number and check and rating information:
DRIVER ID DRIVER FIRST_NAME DRIVER LAST NAME DRIVER DRIVING LICENSE ID DRIVER START DATE DRIVER DRIVING LICENSE CHECKED DRIVER RATING
2001
willie
Butler
1874501
2019-09-12
4.4
2002
Justin
Howard
1953853
2019-09-09
4.8
2003
Anthony
Walker
1735487
2019-09-15
3.5
2004
Ece
Yilmaz
1734747
2019-08-15
DRIVERS Table
In the CARS table, all the cars in the InstantRide system are kept with the license plate, model
and year:
CAR ID
CAR PLATE
CAR MODEL
CAR YEAR
1001
BB-542-AB
TOYOTA PRIUS
2018
1002
BB-883-EE
TESLA MODEL 3
2019
1003
BB-451-ZN
TOYOTA AURIS
2019
1004
BB-189-MM
MERCEDES E200
2019](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F6adf5616-718e-49bf-a967-78aa6906af2f%2F185182a6-27b2-4573-a72a-d0dce1db1baa%2F4lsrgza_processed.png&w=3840&q=75)
Transcribed Image Text:In the USERS table, information for the users are stored with their first name, last name and
email:
USER ID
USER LAST NAME
USER EMAIL
USER FIRST NAME
3001
Jack
Hill
Lhillexmal.com
3002
Ryan
Collins
r.collins@xmail.com
3003
Nursin
Yilmaz
n.atak@gmail.com
3004
Sarah
Price
s.price@xmail.com
3005
Bobby
Griffin
bgriffinexmail.com
3006
Randy
Clark
r.clark@xmail.com
3007
Jose
Thomas
j,thomas@xmail.com
3008
Nursin
Yillmaz
n.yilmaz@xmal.com
USERS Table
In the DRIVERS table, all the drivers in the InstantRide are stored with their name, driving
license number and check and rating information:
DRIVER ID DRIVER FIRST_NAME DRIVER LAST NAME DRIVER DRIVING LICENSE ID DRIVER START DATE DRIVER DRIVING LICENSE CHECKED DRIVER RATING
2001
willie
Butler
1874501
2019-09-12
4.4
2002
Justin
Howard
1953853
2019-09-09
4.8
2003
Anthony
Walker
1735487
2019-09-15
3.5
2004
Ece
Yilmaz
1734747
2019-08-15
DRIVERS Table
In the CARS table, all the cars in the InstantRide system are kept with the license plate, model
and year:
CAR ID
CAR PLATE
CAR MODEL
CAR YEAR
1001
BB-542-AB
TOYOTA PRIUS
2018
1002
BB-883-EE
TESLA MODEL 3
2019
1003
BB-451-ZN
TOYOTA AURIS
2019
1004
BB-189-MM
MERCEDES E200
2019
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education