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)…

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?