Assignment
This is an assignment from DATABASE SYSTEMS: Design, Implementation, and Management 13th Edition
Module: Advanced SQL Activity 1
InstantRide is the new ride sharing application in the city and it has just started it 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.
• Task I: Create a new table to store car maintenance types.
• Task II: Create a new table to store maintenance operations.
• Task III: Create a new table to store the information of active drivers.
• Task IV: Create an INDEX to search for driver information.
• Task V: Create a constraint on the ACTIVE_DRIVERS table.
• Task VI: Alter the MAINTENANCE_TYPES table to include pricing information.