Task 3: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 FLOATSQL Database Test:Create a new table to store information on active driversTest Query: SELECT * FROM ACTIVE_DRIVERS Expected Results:DRIVER_IDDRIVER_FIRST_NAMEDRIVER_LAST_NAMEDRIVER_DRIVING_LICENSE_IDDRIVER_DRIVING_LICENSE_CHECKEDDRIVER_RATING2001WillieButler187450114.42002JustinHoward195385314.82003AnthonyWalker173548713.5 Task 4:The Driver Relationship team wants to have quick search options for the active drivers. The team specifically mentioned that they are using first name, last name and driving license ID to search the drivers. Create an index called NameSearch on the ACTIVE_DRIVERS table created in task 3.SQL Database Test:Create an INDEX to search the ACTIVE_DRIVERS table.Test Query:SHOW INDEX FROM ACTIVE_DRIVERSExpected Results:TableNon_uniqueKey_nameSeq_in_indexColumn_nameCollationCardinalitySub_partPackedNullIndex_typeCommentIndex_commentVisibleExpressionACTIVE_DRIVERS0PRIMARY1DRIVER_IDA3NULLNULL BTREE YESNULLACTIVE_DRIVERS1NameSearch1DRIVER_FIRST_NAMEA3NULLNULLYESBTREE YESNULLACTIVE_DRIVERS1NameSearch2DRIVER_LAST_NAMEA3NULLNULLYESBTREE YESNULLACTIVE_DRIVERS1NameSearch3DRIVER_DRIVING_LICENSE_IDA3NULLNULLYESBTREE YESNULL

Hi .. As per my company rule i can answer to the first question. You can post task 4 as another…

Answered: Task 3: The Driver Relationship team…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Task 3:

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

SQL Database Test:

Create a new table to store information on active drivers

Test Query: SELECT * FROM ACTIVE_DRIVERS

Expected Results:

DRIVER_ID	DRIVER_FIRST_NAME	DRIVER_LAST_NAME	DRIVER_DRIVING_LICENSE_ID	DRIVER_DRIVING_LICENSE_CHECKED	DRIVER_RATING
2001	Willie	Butler	1874501	1	4.4
2002	Justin	Howard	1953853	1	4.8
2003	Anthony	Walker	1735487	1	3.5

Task 4:

The Driver Relationship team wants to have quick search options for the active drivers. The team specifically mentioned that they are using first name, last name and driving license ID to search the drivers. Create an index called NameSearch on the ACTIVE_DRIVERS table created in task 3.

SQL Database Test:

Create an INDEX to search the ACTIVE_DRIVERS table.

Test Query:

SHOW INDEX FROM ACTIVE_DRIVERS

Expected Results:

Table	Non_unique	Key_name	Seq_in_index	Column_name	Collation	Cardinality	Sub_part	Packed	Null	Index_type	Visible	Expression
ACTIVE_DRIVERS	0	PRIMARY	1	DRIVER_ID	A	3	NULL	NULL		BTREE	YES	NULL
ACTIVE_DRIVERS	1	NameSearch	1	DRIVER_FIRST_NAME	A	3	NULL	NULL	YES	BTREE	YES	NULL
ACTIVE_DRIVERS	1	NameSearch	2	DRIVER_LAST_NAME	A	3	NULL	NULL	YES	BTREE	YES	NULL
ACTIVE_DRIVERS	1	NameSearch	3	DRIVER_DRIVING_LICENSE_ID	A	3	NULL	NULL	YES	BTREE	YES	NULL

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 1 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-engineering and related others by exploring similar questions and additional content below.

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON