The InstantRide Management team founded a new team for car maintenance. The new team is responsible...

       

Transcribed Image Text:

The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the Instant Ride system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENANCE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30) ) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES. and send the table description with the column names and types to the Car Maintenance team. Ⓒ 24 ? 8 Chrome File Edit View History Bookmarks Profiles Tab Window Help с 1 hl Chapter 08 Activity 01 </> Search Results | Course Hero x (?) CENGAGE MINDTAP Courses - valenciacollege.edu X VC Chapter 01 Use It ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=6094832335509691384341050163&elSBN=9780357673126&id=16885010... Instructions Page 1 of 4 2022-10-03 21-1648 2022-10-08 23:21:40 5009 3010 TRAVELS Table 2022-10-03 21:26:18 2022-10-03 23:39:10 77 Mill Road 16 Church Road O 724 Springheld Road 30 North Road 994 < 1355 2562 FEB 27 2001 1/4 2003 10003 1002 3005 3003 You are assigned as the database administrator to collect and manage transactional data of the InstantRide operations. Your main task is to create SQL scripts to help other teams to retrieve the requested data. In the following activities, you will create the scripts, run against the database and send the result to the corresponding teams. Grading After you have completed a problem and clicked the Run Query button, mark the task as complete. Checks will run to verify your work. X NULL When all problems are completed and you are satisfied with the results, use the Submit button to record your score. 0.20 MindTap Cengage Learning 2 ↓ SQL Viewer 81% JE X + InstantRide Mon 10:28 PM Q query.sql X + 1 -- Write your query below and the click "Run Query" to execute it. save multiple queries, click the icon on the left. û ↓ 0 X + Q Search this course Run a SQL query to generate results Update: X Run WA ? A-Z بین Ⓒ ? Chrome File Edit View History Bookmarks Profiles Tab Window Help с T hl Search Results | Course Hero x Chapter 08 Activity 01 (?) CENGAGE MINDTAP Courses - valenciacollege.edu X VC Chapter 01 Use It ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=6094832335509691384341050163&elSBN=9780357673126&id=16885010... Instructions Page 1 of 4 CARS Table Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and end time with location are stored. In addition, the involved driver, car and user are listed for each drive. Price and discount information are also available in the database: TRAVEL ID 0001 5002 3003 0004 5005 0006 0008 6010 TRAVEL START TIME 2022 10:01 040455 2002-10-01 06:57:33 2022 10 01 13:35:20 2022-10-02 08:44:48 2022-10-02 14:38:54 2022-10-03 191214 2022-10431140636 2022-10-03 17:17:12 2022-10-03 21:16:45 2022-10-03 23:21:40 TRAVELS Table TRAVEL END TIME 2022-10-01 04:1419 2022-10-01 06:12:33 2022 10 01 13:45:10 2022-10-02 09:15:28 2022 10 02 16:48:10 2022-10-03 19:23:45 2022-10-00 160056 2022-10-03 17:37:42 2022-10-03 21:26:18 2022-10-03 23:39:10 TRAVEL START LOCATION 9614 York Road 47 Church Street 2 Windsor Road 9060 Mil Lane 2 Queensway 50 Main Road 39 Park Road 37 The Drive 77 Millad 16 Church Rood TRAVEL END LOCATION 84 Church Land 994 68 High Straat 95 West Stroot 27 Main Road 24 Mill Lane 93 Broadway West Str 17 Stanley Road 724 Springheld Moad 30 North Road FEB 27 TRAVEL PRICE 45.44 20.56 1/4 1232 3049 1115 1461 441 25:12 1355 25.02 DRIVER ID 2001 2001 2002 2003 2001 2003 2X12 2004 2001 2003 CAR ID USER ID TRAVEL DISCOUNT NULL NULL NULL 1003 3005 1003 3006 1001 3002 1002 3001 1003 3007 1002 3007 тохи 3003 1000 10003 1002 3001 X 3005 3003 0.13 NULL 0.20 014 0:25 You are assigned as the database administrator to collect and manage transactional data of the NULL 0.20 MindTap Cengage Learning 2 81% ↓ SQL Viewer X + Mon 10:27 PM Q InstantRide D query.sql X + 1 -- Write your query below and the click "Run Query" to execute it. save multiple queries, click the icon on the left. ☆ ☐ Q Search this course X + Update: Run a SQL query to generate results X Run WA ? A-Z بین Ⓒ ? Chrome File Edit View History Bookmarks Profiles Tab Window Help с 0 Y3 Chapter 08 Activity 01 hl & Search Results | Course Hero x (?) CENGAGE MINDTAP Courses - valenciacollege.edu X VC Chapter 01 Use It ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=6094832335509691384341050163&elSBN=9780357673126&id=16885010... Instructions Page 1 of 4 DRIVERS Table In the CARS table, all the cars in the Instant Ride system are kept with the license plate, model and year: CAR ID 1001 1002 1003 1004 CARS Table CAR PLATE en BB-542-AB S BB-883-EE BR-451-ZN BB-189-MM TRAVEL ID TRAVEL START_TIME TRAVEL END TIME An CAR MODEL TOYOTA PRIUS TESLA MODEL 3 TOYOTA AURIS 994 MERCEDES E200 TRAVEL START LOCATION Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and end time with location are stored. In addition, the involved driver, car and user are listed for each drive. Price and discount information are also available in the database: TRAVEL END LOCATION TRAVEL PRICE FEB 27 1/4 .. CAR YEAR DRIVER ID 2000 2021 2021 2021 CAR ID Love X USER ID TRAVEL DISCOUNT ZOE ait MindTap Cengage Learning 2 81% ↓ SQL Viewer X + Instant Ride D Mon 10:27 PM Q query.sql X + 1 -- Write your query below and the click "Run Query" to execute it. save multiple queries, click the icon on the left. X ☆ ☐ Q Search this course + Update: Run a SQL query to generate results X Run WA ? A-Z بین Ⓒ ? Chrome File Edit View History Bookmarks Profiles Tab Window Help с 0 Y3 Chapter 08 Activity 01 hl Search Results | Course Hero x (? CENGAGE MINDTAP Courses - valenciacollege.edu X VC Chapter 01 Use It ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=6094832335509691384341050163&elSBN=9780357673126&id=16885010... Instructions Page 1 of 4 USERS Table DRIVER ID DRIVER FIRST NAME 2001 Willie In the DRIVERS table, all the drivers in the Instant Ride are stored with their name, driving license number and check and rating information: 2002 2003 2004 CAR_ID Justin DRIVERS Table 1001 Anthony 1002 Ece DRIVER LAST NAME DRIVER DRIVING LICENSE_ID Butler 1674501 Howard Walker Yilmaz CAR PLATE RB-542-AB BB-883-EE 1953853 O 1735487 1734747 < CAR MODEL TOYOTA PRIUS TESLA MODEL 3 FEB 27 DRIVER START DATE 1/4 2022-09-12 2022-09-09 2022-09-15 In the CARS table, all the cars in the InstantRide system are kept with the license plate, model and year: DRIVER DRIVING LICENSE CHECKED 1 1 1 1 CAR YEAR X 2000 2021 DRIVER RATING 44 48 3.5 MindTap Cengage Learning 00 2 81% ↓ SQL Viewer JE X + InstantRide 3 Mon 10:27 PM Q query.sql X + 1 -- Write your query below and the click "Run Query" to execute it. save multiple queries, click the icon on the left. ☆ ☐ Q Search this course X + Update: Run a SQL query to generate results X Run WA ? A-Z بین Ⓒ ? Chrome File Edit View History Bookmarks Profiles Tab Window Help с 1 V- Chapter 08 Activity 01 Labl Search Results | Course Hero x (?) CENGAGE MINDTAP Courses - valenciacollege.edu X VC Chapter 01 Use It ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=6094832335509691384341050163&elSBN=9780357673126&id=16885010... Instructions Page 1 of 4 InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the InstantRide mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. USER_ID In the USERS table, information for the users are stored with their first name, last name and email: 3001 3002 3003 3004 3005 3006 3007 3008 USER_FIRST_NAME Jack Ryan Nursin Sarah Bobby Randy Jose Nursin 994 USER LAST NAME Hill Collins Yilmaz Price Griffin Clark Thomas Yilmaz FEB 27 X MindTap Cengage Learning 1/4 USER_EMAIL j.hill@xmail.com r.collins@xmail.com n.atak@gmail.com s.price@xmail.com b.griffin@xmail.com r.clark@xmail.com j.thomas@xmail.com n.yilmaz@xmail.com 2 81% ↓ SQL Viewer JE X + InstantRide 3 Mon 10:27 PM Q query.sql X + 1 -- Write your query below and the click "Run Query" to execute it. save multiple queries, click the icon on the left. ☆ ☐ Q Search this course X + Update: Run a SQL query to generate results X Run WA ? A-Z بین The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the Instant Ride system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENANCE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30) ) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES. and send the table description with the column names and types to the Car Maintenance team. Ⓒ 24 ? 8 Chrome File Edit View History Bookmarks Profiles Tab Window Help с 1 hl Chapter 08 Activity 01 </> Search Results | Course Hero x (?) CENGAGE MINDTAP Courses - valenciacollege.edu X VC Chapter 01 Use It ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=6094832335509691384341050163&elSBN=9780357673126&id=16885010... Instructions Page 1 of 4 2022-10-03 21-1648 2022-10-08 23:21:40 5009 3010 TRAVELS Table 2022-10-03 21:26:18 2022-10-03 23:39:10 77 Mill Road 16 Church Road O 724 Springheld Road 30 North Road 994 < 1355 2562 FEB 27 2001 1/4 2003 10003 1002 3005 3003 You are assigned as the database administrator to collect and manage transactional data of the InstantRide operations. Your main task is to create SQL scripts to help other teams to retrieve the requested data. In the following activities, you will create the scripts, run against the database and send the result to the corresponding teams. Grading After you have completed a problem and clicked the Run Query button, mark the task as complete. Checks will run to verify your work. X NULL When all problems are completed and you are satisfied with the results, use the Submit button to record your score. 0.20 MindTap Cengage Learning 2 ↓ SQL Viewer 81% JE X + InstantRide Mon 10:28 PM Q query.sql X + 1 -- Write your query below and the click "Run Query" to execute it. save multiple queries, click the icon on the left. û ↓ 0 X + Q Search this course Run a SQL query to generate results Update: X Run WA ? A-Z بین Ⓒ ? Chrome File Edit View History Bookmarks Profiles Tab Window Help с T hl Search Results | Course Hero x Chapter 08 Activity 01 (?) CENGAGE MINDTAP Courses - valenciacollege.edu X VC Chapter 01 Use It ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=6094832335509691384341050163&elSBN=9780357673126&id=16885010... Instructions Page 1 of 4 CARS Table Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and end time with location are stored. In addition, the involved driver, car and user are listed for each drive. Price and discount information are also available in the database: TRAVEL ID 0001 5002 3003 0004 5005 0006 0008 6010 TRAVEL START TIME 2022 10:01 040455 2002-10-01 06:57:33 2022 10 01 13:35:20 2022-10-02 08:44:48 2022-10-02 14:38:54 2022-10-03 191214 2022-10431140636 2022-10-03 17:17:12 2022-10-03 21:16:45 2022-10-03 23:21:40 TRAVELS Table TRAVEL END TIME 2022-10-01 04:1419 2022-10-01 06:12:33 2022 10 01 13:45:10 2022-10-02 09:15:28 2022 10 02 16:48:10 2022-10-03 19:23:45 2022-10-00 160056 2022-10-03 17:37:42 2022-10-03 21:26:18 2022-10-03 23:39:10 TRAVEL START LOCATION 9614 York Road 47 Church Street 2 Windsor Road 9060 Mil Lane 2 Queensway 50 Main Road 39 Park Road 37 The Drive 77 Millad 16 Church Rood TRAVEL END LOCATION 84 Church Land 994 68 High Straat 95 West Stroot 27 Main Road 24 Mill Lane 93 Broadway West Str 17 Stanley Road 724 Springheld Moad 30 North Road FEB 27 TRAVEL PRICE 45.44 20.56 1/4 1232 3049 1115 1461 441 25:12 1355 25.02 DRIVER ID 2001 2001 2002 2003 2001 2003 2X12 2004 2001 2003 CAR ID USER ID TRAVEL DISCOUNT NULL NULL NULL 1003 3005 1003 3006 1001 3002 1002 3001 1003 3007 1002 3007 тохи 3003 1000 10003 1002 3001 X 3005 3003 0.13 NULL 0.20 014 0:25 You are assigned as the database administrator to collect and manage transactional data of the NULL 0.20 MindTap Cengage Learning 2 81% ↓ SQL Viewer X + Mon 10:27 PM Q InstantRide D query.sql X + 1 -- Write your query below and the click "Run Query" to execute it. save multiple queries, click the icon on the left. ☆ ☐ Q Search this course X + Update: Run a SQL query to generate results X Run WA ? A-Z بین Ⓒ ? Chrome File Edit View History Bookmarks Profiles Tab Window Help с 0 Y3 Chapter 08 Activity 01 hl & Search Results | Course Hero x (?) CENGAGE MINDTAP Courses - valenciacollege.edu X VC Chapter 01 Use It ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=6094832335509691384341050163&elSBN=9780357673126&id=16885010... Instructions Page 1 of 4 DRIVERS Table In the CARS table, all the cars in the Instant Ride system are kept with the license plate, model and year: CAR ID 1001 1002 1003 1004 CARS Table CAR PLATE en BB-542-AB S BB-883-EE BR-451-ZN BB-189-MM TRAVEL ID TRAVEL START_TIME TRAVEL END TIME An CAR MODEL TOYOTA PRIUS TESLA MODEL 3 TOYOTA AURIS 994 MERCEDES E200 TRAVEL START LOCATION Finally, the transactions of the rides are stored in the TRAVELS table. For each travel, start and end time with location are stored. In addition, the involved driver, car and user are listed for each drive. Price and discount information are also available in the database: TRAVEL END LOCATION TRAVEL PRICE FEB 27 1/4 .. CAR YEAR DRIVER ID 2000 2021 2021 2021 CAR ID Love X USER ID TRAVEL DISCOUNT ZOE ait MindTap Cengage Learning 2 81% ↓ SQL Viewer X + Instant Ride D Mon 10:27 PM Q query.sql X + 1 -- Write your query below and the click "Run Query" to execute it. save multiple queries, click the icon on the left. X ☆ ☐ Q Search this course + Update: Run a SQL query to generate results X Run WA ? A-Z بین Ⓒ ? Chrome File Edit View History Bookmarks Profiles Tab Window Help с 0 Y3 Chapter 08 Activity 01 hl Search Results | Course Hero x (? CENGAGE MINDTAP Courses - valenciacollege.edu X VC Chapter 01 Use It ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=6094832335509691384341050163&elSBN=9780357673126&id=16885010... Instructions Page 1 of 4 USERS Table DRIVER ID DRIVER FIRST NAME 2001 Willie In the DRIVERS table, all the drivers in the Instant Ride are stored with their name, driving license number and check and rating information: 2002 2003 2004 CAR_ID Justin DRIVERS Table 1001 Anthony 1002 Ece DRIVER LAST NAME DRIVER DRIVING LICENSE_ID Butler 1674501 Howard Walker Yilmaz CAR PLATE RB-542-AB BB-883-EE 1953853 O 1735487 1734747 < CAR MODEL TOYOTA PRIUS TESLA MODEL 3 FEB 27 DRIVER START DATE 1/4 2022-09-12 2022-09-09 2022-09-15 In the CARS table, all the cars in the InstantRide system are kept with the license plate, model and year: DRIVER DRIVING LICENSE CHECKED 1 1 1 1 CAR YEAR X 2000 2021 DRIVER RATING 44 48 3.5 MindTap Cengage Learning 00 2 81% ↓ SQL Viewer JE X + InstantRide 3 Mon 10:27 PM Q query.sql X + 1 -- Write your query below and the click "Run Query" to execute it. save multiple queries, click the icon on the left. ☆ ☐ Q Search this course X + Update: Run a SQL query to generate results X Run WA ? A-Z بین Ⓒ ? Chrome File Edit View History Bookmarks Profiles Tab Window Help с 1 V- Chapter 08 Activity 01 Labl Search Results | Course Hero x (?) CENGAGE MINDTAP Courses - valenciacollege.edu X VC Chapter 01 Use It ng.cengage.com/static/nb/ui/evo/index.html?deploymentid=6094832335509691384341050163&elSBN=9780357673126&id=16885010... Instructions Page 1 of 4 InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the InstantRide mobile application, the users request a ride with their location. Drivers and cars are assigned to the request; and then the driver picks up the user to ride their requested location. Information for the users, drivers and cars are stored in the database as well as the travel transactions. USER_ID In the USERS table, information for the users are stored with their first name, last name and email: 3001 3002 3003 3004 3005 3006 3007 3008 USER_FIRST_NAME Jack Ryan Nursin Sarah Bobby Randy Jose Nursin 994 USER LAST NAME Hill Collins Yilmaz Price Griffin Clark Thomas Yilmaz FEB 27 X MindTap Cengage Learning 1/4 USER_EMAIL j.hill@xmail.com r.collins@xmail.com n.atak@gmail.com s.price@xmail.com b.griffin@xmail.com r.clark@xmail.com j.thomas@xmail.com n.yilmaz@xmail.com 2 81% ↓ SQL Viewer JE X + InstantRide 3 Mon 10:27 PM Q query.sql X + 1 -- Write your query below and the click "Run Query" to execute it. save multiple queries, click the icon on the left. ☆ ☐ Q Search this course X + Update: Run a SQL query to generate results X Run WA ? A-Z بین

Answer rating: 100% (QA)

Task1It seems like youre tasked with creating a new table in a SQL database to store maintenance types and providing the table description with the column names and types However the description you p... View the full answer