The Driver Relationship team wants to create some workshops and increase communication with the active drivers in InstantRide. Therefore, they requested a new database table to store the driver details of the drivers that have had at least one ride in the system. Create a new table, ACTIVE_DRIVERS, from the DRIVERS and TRAVELS tables which contains the following fields:DRIVER_ID CHAR(5) (Primary key)DRIVER_FIRST_NAME VARCHAR(20)DRIVER_LAST_NAME VARCHAR(20)DRIVER_DRIVING_LICENSE_ID VARCHAR(10)DRIVER_DRIVING_LICENSE_CHECKED BOOLDRIVER_RATING FLOAT DRIVER_IDDRIVER_FIRST_NAMEDRIVER_LAST_NAMEDRIVER_DRIVING_LICENSE_IDDRIVER_START_DATE DRIVER_DRIVING_LICENSE_CHECKEDDRIVER_RATING2001WillieButler18745012019-09-1214.42002JustinHoward19538532019-09-0914.82003AnthonyWalker17354872019-09-1513.52004ЕсеYilmaz17347472019-08-151 TRAVEL IDTRAVEL_START_TIMETRAVEL_END_TIMETRAVEL_START_LOCATIONTRAVEL_END_LOCATIONTRAVEL_PRICEDRIVER_IDCAR_IDUSER_IDTRAVEL_DISCOUNT50012019-10-01 04:04:552019-10-01 04:14:199614 York Road84 Church Lane15.44200110033005NULL50022019-10-01 05:57:332019-10-01 06:12:3347 Church Street68 High Street20.56200110033006NULL50032019-10-01 13:35:202019-10-01 13:45:102 Windsor Road95 West Street12.32200210013002NULL50042019-10-02 08:44:482019-10-02 09:15:289060 Mill Lane27 Main Road30.492003100230010.1350052019-10-02 16:38:542019-10-02 16:48:102 Queensway24 Mill Lane11.15200110033007NULL50062019-10-03 19:12:142019-10-03 19:23:4550 Main Road93 Broadway14.612003100230070.1050072019-10-03 16:06:362019-10-03 16:08:5639 Park Road91 West Street4.412002100430030.1450082019-10-03 17:17:122019-10-03 17:37:4237 The Drive17 Stanley Road25.122001100330010.2550092019-10-03 21:16:482019-10-03 21:26:1877 Mill Road724 Springfield Road13.55200110033005NULL50102019-10-03 23:21:402019-10-03 23:39:1016 Church Road30 North Road25.622003100230030.20

SQL query to create a new table with name, ACTIVE_DRIVERS that contains the list of specified…

Answered: The Driver Relationship team wants to…

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

Related questions

Question

The Driver Relationship team wants to create some workshops and increase communication with the active drivers in InstantRide. Therefore, they requested a new database table to store the driver details of the drivers that have had at least one ride in the system. Create a new table, ACTIVE_DRIVERS, from the DRIVERS and TRAVELS tables which contains the following fields:

DRIVER_ID CHAR(5) (Primary key)
DRIVER_FIRST_NAME VARCHAR(20)
DRIVER_LAST_NAME VARCHAR(20)
DRIVER_DRIVING_LICENSE_ID VARCHAR(10)
DRIVER_DRIVING_LICENSE_CHECKED BOOL
DRIVER_RATING FLOAT

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
1
4.4
2002
Justin
Howard
1953853
2019-09-09
1
4.8
2003
Anthony
Walker
1735487
2019-09-15
1
3.5
2004
Есе
Yilmaz
1734747
2019-08-15
1

TRAVEL ID
TRAVEL_START_TIME
TRAVEL_END_TIME
TRAVEL_START_LOCATION
TRAVEL_END_LOCATION
TRAVEL_PRICE
DRIVER_ID
CAR_ID
USER_ID
TRAVEL_DISCOUNT
5001
2019-10-01 04:04:55
2019-10-01 04:14:19
9614 York Road
84 Church Lane
15.44
2001
1003
3005
NULL
5002
2019-10-01 05:57:33
2019-10-01 06:12:33
47 Church Street
68 High Street
20.56
2001
1003
3006
NULL
5003
2019-10-01 13:35:20
2019-10-01 13:45:10
2 Windsor Road
95 West Street
12.32
2002
1001
3002
NULL
5004
2019-10-02 08:44:48
2019-10-02 09:15:28
9060 Mill Lane
27 Main Road
30.49
2003
1002
3001
0.13
5005
2019-10-02 16:38:54
2019-10-02 16:48:10
2 Queensway
24 Mill Lane
11.15
2001
1003
3007
NULL
5006
2019-10-03 19:12:14
2019-10-03 19:23:45
50 Main Road
93 Broadway
14.61
2003
1002
3007
0.10
5007
2019-10-03 16:06:36
2019-10-03 16:08:56
39 Park Road
91 West Street
4.41
2002
1004
3003
0.14
5008
2019-10-03 17:17:12
2019-10-03 17:37:42
37 The Drive
17 Stanley Road
25.12
2001
1003
3001
0.25
5009
2019-10-03 21:16:48
2019-10-03 21:26:18
77 Mill Road
724 Springfield Road
13.55
2001
1003
3005
NULL
5010
2019-10-03 23:21:40
2019-10-03 23:39:10
16 Church Road
30 North Road
25.62
2003
1002
3003
0.20

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions