Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
The Driver Relationship team wants to work with the active drivers using a VIEW constructed on the DRIVERS table. By creating the VIEW the team wants to eliminate extra work to keep both tables up-to-date. Create a VIEW for the drivers that has at least one travel in InstantStay. Task   Create the ACTIVE_DRIVERS VIEW for working with active drivers.

The Driver Relationship team wants to work with the active drivers using a VIEW constructed on the DRIVERS table. By creating the VIEW the team wants to eliminate extra work to keep both tables up-to-date. Create a VIEW for the drivers that has at least one travel in InstantStay. Task   Create the ACTIVE_DRIVERS VIEW for working with active drivers.

Database System Concepts
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
See similar textbooks
icon
Related questions
Question

The Driver Relationship team wants to work with the active drivers using a VIEW constructed on the DRIVERS table. By creating the VIEW the team wants to eliminate extra work to keep both tables up-to-date. Create a VIEW for the drivers that has at least one travel in InstantStay.

Task
 

Create the ACTIVE_DRIVERS VIEW for working with active drivers.

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
TRAVEL D TRAVEL START TIME TRAVEL END TIME TRAVEL START LOCATION TRAVEL END LOCATION DRIVER ID CAR D USER O TRAVEL DISCOUNT TRAVEL PRICE 2010.10ar De:1:19 A Vork Enard MChuren Lane 16.44 2001 2013-1001 :1as 47 Chure Sen gheer 2001 20.E NULL 20 n0 1R 0 201104 13:t:10 Wineear Wet r 13.3 2000 100 201-14 0s0 MII ane 7 M teat 200n 201104 16::10 11,15 2001 20 0 114 reanwy 2013-1001 11:21t so Min nat 200n 206 16063 2019-100 1654 3 Dan Anod 91 West or 441 2000 1004 3008 014 201510-03 17 1712 2019-10-03 17:37h42 37 The Drive 17 Staniey Roed 25.12 2001 1003 300 0.25 2015-10-03 216s 2019-10-03 212 7 MII Road 724 Sprngte Rad 13.55 2001 3005 NULL 201510-03 232140 2019-1003 23:391o 16 Church oad 30 North Road 25.62 2000 1002 3003 020 TRAVELS Table
Transcribed Image Text:TRAVEL D TRAVEL START TIME TRAVEL END TIME TRAVEL START LOCATION TRAVEL END LOCATION DRIVER ID CAR D USER O TRAVEL DISCOUNT TRAVEL PRICE 2010.10ar De:1:19 A Vork Enard MChuren Lane 16.44 2001 2013-1001 :1as 47 Chure Sen gheer 2001 20.E NULL 20 n0 1R 0 201104 13:t:10 Wineear Wet r 13.3 2000 100 201-14 0s0 MII ane 7 M teat 200n 201104 16::10 11,15 2001 20 0 114 reanwy 2013-1001 11:21t so Min nat 200n 206 16063 2019-100 1654 3 Dan Anod 91 West or 441 2000 1004 3008 014 201510-03 17 1712 2019-10-03 17:37h42 37 The Drive 17 Staniey Roed 25.12 2001 1003 300 0.25 2015-10-03 216s 2019-10-03 212 7 MII Road 724 Sprngte Rad 13.55 2001 3005 NULL 201510-03 232140 2019-1003 23:391o 16 Church oad 30 North Road 25.62 2000 1002 3003 020 TRAVELS Table
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
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
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
SEE MORE TEXTBOOKS