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
icon
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Procedures in SQL
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education