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 InstantRide 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, kreate a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team.

 

Transcribed Image Text:

A Chrome File Edit View History Bookmarks Profiles Tab Window Help Ismail Homework Help - Q X Courses - valenciaco x VC Chapter 01 Use It 50% Tue 12:27 AM Q MindTap - Cengage X Cc Convert Case | Convex C The InstantRide Mar x + Update Q Search this course ? ng.cengage.com/static/nb/ui/evo/index.html?deploymentId=6094832335509691384341050163&elSBN 9780357673126&id=16885010... < CENGAGE MINDTAP My Home Courses Catalog and Study Tools Rental Options Chapter 08 Activity 01 College Success Tips Career Success Tips Instructions Page 1 of 4 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: RECOMMENDED FOR YOU Scrutinize the Source: Online Help Give Feedback TRAVELD TRAVEL START TIME 5001 2012-10-01 TRAVEL END TIME 2022100014:19 TRAVEL START LOCATION 9614 York Road Chuch TRAVEL END LOCATION TRAVEL PRICE B4 Cherth Lane 1544 DRIVER JO 2001 7000 CARO USER ID TRAVEL DISCOUNT 1000 NULL 3006 query.sql + A-Z 1 2002 00:0 34 5000 2000-0334 50007 2022-10-08 22-10-0171732 2012-10-05 2012-10-0 DOM 3 2004 1401 2000 1002 3007 010 West Street 1004 3003 0:14 17 25.12 E 2012-10-02-2018 TTMR Road 124 Spd Road 1300 2001 3005 NIAL SQL Viewer + 500 2022-10-03 21:21:40 2022-10-13 21:39:0 16 Church Road North Road 2560 2000 1000 3009 020 TRAVELS Table 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 1/4 Run a SQL query to generate results Instant Ride D Run https://cdn.filestackcontent.com/GDgKy9z6QDHvoSPFLfyi FEB 28 A Chrome File Edit View History Bookmarks Profiles Tab Window Help Ismail Homework Help - Q X Courses - valenciaco x VC Chapter 01 Use It 50% Tue 12:27 AM Q MindTap - Cengage X Cc Convert Case | Convex C The InstantRide Mar x + Update Q Search this course ? ng.cengage.com/static/nb/ui/evo/index.html?deploymentId=6094832335509691384341050163&elSBN 9780357673126&id=16885010... < CENGAGE MINDTAP My Home Courses Catalog and Study Tools Rental Options Chapter 08 Activity 01 College Success Tips Career Success Tips Instructions Page 1 of 4 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: RECOMMENDED FOR YOU Scrutinize the Source: Online Help Give Feedback TRAVELD TRAVEL START TIME 5001 2012-10-01 TRAVEL END TIME 2022100014:19 TRAVEL START LOCATION 9614 York Road Chuch TRAVEL END LOCATION TRAVEL PRICE B4 Cherth Lane 1544 DRIVER JO 2001 7000 CARO USER ID TRAVEL DISCOUNT 1000 NULL 3006 query.sql + A-Z 1 2002 00:0 34 5000 2000-0334 50007 2022-10-08 22-10-0171732 2012-10-05 2012-10-0 DOM 3 2004 1401 2000 1002 3007 010 West Street 1004 3003 0:14 17 25.12 E 2012-10-02-2018 TTMR Road 124 Spd Road 1300 2001 3005 NIAL SQL Viewer + 500 2022-10-03 21:21:40 2022-10-13 21:39:0 16 Church Road North Road 2560 2000 1000 3009 020 TRAVELS Table 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 1/4 Run a SQL query to generate results Instant Ride D Run https://cdn.filestackcontent.com/GDgKy9z6QDHvoSPFLfyi FEB 28