The Database assignment consist on a project of supporting the tourism in Albania. This project will provide an online Transportation Management System Database Design. The idea of the project starts with the online reservation$/$payment of the client, picking up the client$/$tourist at the airport$/$point of entrance in Albania, transporting to the destination residence and vice versa.This is supposed to be a Pilot project for Gjirokastra City. Objective:Design and implement a relational database for an online transportation management system to facilitate the booking, tracking, and management of transportation services.Requirements:Entity$-$Relationship Diagram $($ERD$)$:Create a comprehensive ERD for the online transportation system.Identify entities such as User, Driver, Vehicle, Trip, Booking, and Payment. Define attributes and relationships between entities.Normalization:Apply normalization techniques to ensure the database is in at least $3$rd Normal Form $(3$NF$).$Explain the normalization process and justify the choices made in the context of transportation data.Tables Creation:Implement the database tables based on the ERD and normalization results.Include primary keys, foreign keys, and appropriate data types for each attribute.Data Population:Populate the tables with sample data to demonstrate the functionality of the database.Include scenarios like multiple trips per user, driver availability, and various payment methods.Queries:Develop SQL queries to perform the following operations:Retrieve a list of all trips for a specific user.Display details of a particular trip, including the driver, vehicle, and payment information.Find the total earnings for a specific driver within a given time period.Update the status of a trip $($e$.$g$.,$ from booked to completed$).$Identify drivers available in a specific location.Views and Indexing:Create at least two views to simplify common queries, such as a view showing all active bookings. Explain why these views are useful.Implement appropriate indexing to optimize the performance of certain queries.Triggers:Implement a trigger to update the status of a driver $($e$.$g$.,$ from available to busy$)$ when they accept a trip.Security:Implement basic security measures, such as user roles and permissions, to control access to sensitive information.Documentation:Provide documentation that includes a description of the database schema, relationships, and the purpose of each table. Include instructions on how to set up the database.