Please help I have been at this for day **Scenario and Database Model: InstantRide****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 to their requested location. Information for the users, drivers, and cars are stored in the database, as well as the travel transactions.In the **USERS** table, information for the users is stored with their first name, last name, and email:| USER_ID | USER_FIRST_NAME | USER_LAST_NAME | USER_EMAIL ||---------|-----------------|----------------|--------------------|| 3001 | Jack | Hill | j.hill@mail.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 | b.griffin@xmail.com|| 3006 | Randy | Clark | r.clark@xmail.com || 3007 | Jose | Thomas | j.thomas@xmail.com || 3008 | Nursin | Yilmaz | n.yilmaz@xmail.com |*Users Table* **Tasks:**1. Create a new table to store car maintenance types.2. Create a new table to store maintenance operations.3. Create a new table to store the information of active drivers.4. Create an **INDEX** to search for driver information.5. Create a constraint on the **ACTIVE_DRIVERS** table.6. Alter the **MAINTENANCE_TYPES** table to include pricing information.

This is very simple. Here are the complete solutions for the given problem statement. Solution a) CREATE TABLE car_maintainance_types ( car_ID INT NOT NULL, corrective_maintainance VARCHAR(255), preventive_maintainance VARCHAR(255), predictive_maintainance VARCHAR(255)); Solution b) CREATE TABLE car_maintainance_operations ( car_ID INT FOREIGN KEY REFERENCES car_maintainance_types( car_ID), air_filter VARCHAR(255), headlights VARCHAR(255), tyre_pressure VARCHAR(255)); Solution c) CREATE TABLE car_active_drivers ( car_ID INT NOT NULL, first_name VARCHAR(255), last_name VARCHAR(255), age INT, address VARCHAR(255), phone INT NOT NULL);Solution d) CREATE INDEX driver_information_asc ON car_active_drivers(car_ID, first_name, last_name, age ASC); Solution e)Note: SQL constraints are used to specify rules for the data in a tableCREATE TABLE car_active_drivers ( car_ID INT NOT NULL, first_name VARCHAR(255), last_name VARCHAR(255), age INT, address VARCHAR(255), phone INT NOT NULL); Solution f) ALTER TABLE car_maintainance_typesADD pricing_information varchar(255); Hope it helps !!

Engineering

Computer Science

InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the Instant Ride 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.

InstantRide is the new ride sharing application in the city and it has just started its operations. With the help of the Instant Ride 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.

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

Similar questions

Is it true that Grace Hopper is credited with the invention of the computer?
What actions would you follow if you were debugging a computer error code? and what resources do you rely on to assist you in your search for solutions?
Do you think of yourself as physically educated? Why?
I'm wondering about your degree of knowledge about the use of modern computers.
Chose the correct answer
Justify, “A poorly designed front-end of the software can cause a user to make catastrophic errors” plz solve in 30 minutes
Is there anything you can do to differentiate fact from fiction on the internet?
Is playing video games on a computer beneficial or harmful to human beings in the long run? What justifications do you have for holding this belief?
What are the top six causes of today's high frequency of computer errors?
Is it possible that Grace Hopper invented the computer?
Is engaging in computer gaming beneficial or detrimental to individuals in the long term? What is the foundation upon which your belief is predicated?
Do you feel that persons who are physically or mentally handicapped may benefit in some way from utilising the Internet? Include in your explanation any assistive technology that you feel might be developed in the future to aid people with physical limitations. • Is it prudent to make the source code for assistive technology publicly available?