ERD

NORMALIZED UPTO 3NF

5) Create table commands of the Normalized tables

CREATE TABLE Airline (

airline_id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(100) NOT NULL,
country VARCHAR(50)
);

CREATE TABLE Flight (

flight_id INT PRIMARY KEY AUTO_INCREMENT,
airline_id INT,
source VARCHAR(50) NOT NULL,
destination VARCHAR(50) NOT NULL,
departure_time TIMESTAMP,
arrival_time TIMESTAMP,
seats_available INT CHECK (seats_available >= 0),
FOREIGN KEY (airline_id) REFERENCES Airline(airline_id) ON DELETE CASCADE,
price decimal(10,2)
);

CREATE TABLE Passenger (

passenger_id INT PRIMARY KEY AUTO_INCREMENT,
first_name VARCHAR(50) NOT NULL,
last_name VARCHAR(50) NOT NULL,
email VARCHAR(100) UNIQUE,
phone VARCHAR(15)
);

CREATE TABLE Reservation (

reservation_id INT PRIMARY KEY AUTO_INCREMENT,
passenger_id INT,
flight_id INT,
reservation_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
status ENUM('Booked', 'Cancelled') DEFAULT 'Booked',
FOREIGN KEY (passenger_id) REFERENCES Passenger(passenger_id) ON DELETE
CASCADE,
FOREIGN KEY (flight_id) REFERENCES Flight(flight_id) ON DELETE CASCADE
);
CREATE TABLE Ticket (
ticket_id INT PRIMARY KEY AUTO_INCREMENT,
reservation_id INT,
issue_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (reservation_id) REFERENCES Reservation(reservation_id) ON DELETE
CASCADE,
cancellation_reason varchar(255) not null
);

CREATE TABLE CancelledTicket (

cancelled_ticket_id INT AUTO_INCREMENT PRIMARY KEY,
ticket_id INT,
reservation_id INT,
passenger_id INT,
flight_id INT,
cancellation_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
cancellation_reason VARCHAR(255),
FOREIGN KEY (ticket_id) REFERENCES Ticket(ticket_id),
FOREIGN KEY (reservation_id) REFERENCES Reservation(reservation_id)
);

CREATE TABLE Payment (

payment_id INT AUTO_INCREMENT PRIMARY KEY,
reservation_id INT NOT NULL,
payment_method VARCHAR(50) NOT NULL,
amount DECIMAL(10, 2) NOT NULL,
payment_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (reservation_id) REFERENCES Reservation(reservation_id) ON DELETE
CASCADE,
payment_status varchar(20) not null default "completed"
);
6) 20 queries solved on MySQl in the form (Question, Query,Output) on the
above tables covering

[Link]: Find all flights with a price between 4500 and 5500.

mysql> SELECT * FROM flight WHERE price BETWEEN 4500 AND 5500;
+-----------+------------+-----------+-------------+---------------------+---------------------+-----------------+---------+
| flight_id | airline_id | source | destination | departure_time | arrival_time | seats_available | price |
+-----------+------------+-----------+-------------+---------------------+---------------------+-----------------+---------+
| 21 | 1 | Mumbai | Delhi | 2024-11-14 21:47:04 | 2024-11-20 11:30:00 | 99 | 5000.00 |
| 22 | 1 | Delhi | Mumbai | 2024-11-14 21:47:04 | 2024-11-20 16:30:00 | 100 | 5000.00 |
| 25 | 3 | Kolkata | Mumbai | 2024-11-14 21:47:04 | 2024-11-20 09:00:00 | 85 | 4500.00 |
| 26 | 3 | Mumbai | Kolkata | 2024-11-14 21:47:04 | 2024-11-20 15:00:00 | 85 | 4500.00 |
| 31 | 6 | Pune | Delhi | 2024-11-14 22:44:45 | 2024-11-20 12:30:00 | 93 | 5500.00 |
| 32 | 6 | Delhi | Pune | 2024-11-14 23:13:43 | 2024-11-20 20:30:00 | 92 | 5500.00 |
| 37 | 9 | Hyderabad | Kolkata | 2024-11-14 21:47:04 | 2024-11-20 06:30:00 | 75 | 4700.00
|
| 38 | 9 | Kolkata | Hyderabad | 2024-11-14 21:47:04 | 2024-11-20 15:30:00 | 75 | 4700.00
|
| 39 | 10 | Delhi | Goa | 2024-11-14 21:47:04 | 2024-11-20 12:30:00 | 115 | 5200.00 |
| 40 | 10 | Goa | Delhi | 2024-11-15 01:22:42 | 2024-11-20 18:30:00 | 113 | 5200.00 |
+-----------+------------+-----------+-------------+---------------------+---------------------+-----------------+---------+
10 rows in set (0.01 sec)

2. Using LIKE to search for airlines with "Air" in their name

mysql> SELECT * FROM airline WHERE name LIKE '%Air%';

+------------+-------------------+---------+
| airline_id | name | country |
+------------+-------------------+---------+
| 1 | Air India | India |
| 4 | GoAir | India |
| 6 | AirAsia India | India |
| 7 | Air India Express | India |
| 8 | Alliance Air | India |
| 9 | Star Air | India |
+------------+-------------------+---------+
6 rows in set (0.00 sec)

3. Queries on dates - finding upcoming flights in December

mysql> SELECT * FROM flight WHERE departure_time BETWEEN '2024-11-14' AND
'2024-12-31';
+-----------+------------+-----------+-------------+---------------------+---------------------+-----------------+---------+
| flight_id | airline_id | source | destination | departure_time | arrival_time | seats_available | price |
+-----------+------------+-----------+-------------+---------------------+---------------------+-----------------+---------+
| 21 | 1 | Mumbai | Delhi | 2024-11-14 21:47:04 | 2024-11-20 11:30:00 | 99 | 5000.00 |
| 22 | 1 | Delhi | Mumbai | 2024-11-14 21:47:04 | 2024-11-20 16:30:00 | 100 | 5000.00 |
| 23 | 2 | Bangalore | Hyderabad | 2024-11-14 21:47:04 | 2024-11-20 08:15:00 | 90 |
3000.00 |
| 24 | 2 | Hyderabad | Bangalore | 2024-11-14 21:47:04 | 2024-11-20 11:15:00 | 90 |
3000.00 |
| 25 | 3 | Kolkata | Mumbai | 2024-11-14 21:47:04 | 2024-11-20 09:00:00 | 85 | 4500.00 |
| 26 | 3 | Mumbai | Kolkata | 2024-11-14 21:47:04 | 2024-11-20 15:00:00 | 85 | 4500.00 |
| 27 | 4 | Chennai | Delhi | 2024-11-15 01:09:46 | 2024-11-20 08:30:00 | 108 | 6000.00 |
| 28 | 4 | Delhi | Chennai | 2024-11-15 01:40:40 | 2024-11-20 20:00:00 | 101 | 6000.00 |
| 29 | 5 | Mumbai | Goa | 2024-11-14 22:38:16 | 2024-11-20 14:30:00 | 119 | 2500.00 |
| 30 | 5 | Goa | Mumbai | 2024-11-15 01:36:41 | 2024-11-20 17:00:00 | 109 | 2500.00 |
| 31 | 6 | Pune | Delhi | 2024-11-14 22:44:45 | 2024-11-20 12:30:00 | 93 | 5500.00 |
| 32 | 6 | Delhi | Pune | 2024-11-14 23:13:43 | 2024-11-20 20:30:00 | 92 | 5500.00 |
| 33 | 7 | Ahmedabad | Mumbai | 2024-11-14 21:47:04 | 2024-11-20 09:00:00 | 105 |
4000.00 |
| 34 | 7 | Mumbai | Ahmedabad | 2024-11-14 21:47:04 | 2024-11-20 21:00:00 | 105 |
4000.00 |
| 35 | 8 | Bangalore | Chennai | 2024-11-14 21:47:04 | 2024-11-20 09:00:00 | 130 |
3500.00 |
| 36 | 8 | Chennai | Bangalore | 2024-11-14 21:47:04 | 2024-11-20 11:00:00 | 130 |
3500.00 |
| 37 | 9 | Hyderabad | Kolkata | 2024-11-14 21:47:04 | 2024-11-20 06:30:00 | 75 | 4700.00
|
| 38 | 9 | Kolkata | Hyderabad | 2024-11-14 21:47:04 | 2024-11-20 15:30:00 | 75 | 4700.00
|
| 39 | 10 | Delhi | Goa | 2024-11-14 21:47:04 | 2024-11-20 12:30:00 | 115 | 5200.00 |
| 40 | 10 | Goa | Delhi | 2024-11-15 01:22:42 | 2024-11-20 18:30:00 | 113 | 5200.00 |
+-----------+------------+-----------+-------------+---------------------+---------------------+-----------------+---------+
20 rows in set (0.01 sec)

4. Using ORDER BY to sort passengers by name alphabetically

mysql> select*from passenger order by first_name;

+--------------+------------+-----------+---------------------------+------------+
| passenger_id | first_name | last_name | email | phone |
+--------------+------------+-----------+---------------------------+------------+
| 7 | kirti | joshi | [Link]@[Link] | 9870654890 |
| 9 | pooja | mane | [Link]@[Link] | 9699477120 |
| 6 | pratik | mane | [Link]@[Link] | 9087690854 |
| 8 | preeti | pardeshi | [Link]@[Link] | 8765906543 |
| 5 | priya | mohite | [Link]@[Link] | 9987654309 |
| 11 | ram | kumbhar | [Link]@[Link] | 9145301031 |
| 4 | riya | chaudhari | [Link]@[Link] | 9087654345 |
| 12 | sakshi | joshi | [Link]@[Link] | 7666885213 |
| 3 | samiksha | patil | [Link]@[Link] | 7677885123 |
| 1 | shrutika | Nalavade | [Link]@123 | 9145301031 |
| 10 | Soham | Kumbhar | [Link]@[Link] | 9699477120 |
| 2 | swati | kumbhar | [Link]@[Link] | 9699477120 |
| 13 | varad | mohite | [Link]@[Link] | 9699477120 |
+--------------+------------+-----------+---------------------------+------------+
13 rows in set (0.02 sec)

5. Retrieve the list of all flights along with their airline details, displaying the source,
destination, departure time, arrival time, seats available, and price, even if there are no
matching airlines for some flights.
mysql> select*from flight left outer join airline on flight.airline_id=airline.airline_id;
+-----------+------------+-----------+-------------+---------------------+---------------------+-----------------+---------+------------+-------------------+-
--------+
| flight_id | airline_id | source | destination | departure_time | arrival_time | seats_available | price |
airline_id | name
| country |
+-----------+------------+-----------+-------------+---------------------+---------------------+-----------------+---------+------------+-------------------+-
--------+
| 21 | 1 | Mumbai | Delhi | 2024-11-14 21:47:04 | 2024-11-20 11:30:00 | 99 | 5000.00 |
1 | Air India
| India |
| 22 | 1 | Delhi | Mumbai | 2024-11-14 21:47:04 | 2024-11-20 16:30:00 | 100 | 5000.00 |
1 | Air India
| India |
| 23 | 2 | Bangalore | Hyderabad | 2024-11-14 21:47:04 | 2024-11-20 08:15:00 | 90 |
3000.00 | 2 | IndiGo
| India |
| 24 | 2 | Hyderabad | Bangalore | 2024-11-14 21:47:04 | 2024-11-20 11:15:00 | 90 |
3000.00 | 2 | IndiGo
| India |
| 25 | 3 | Kolkata | Mumbai | 2024-11-14 21:47:04 | 2024-11-20 09:00:00 | 85 | 4500.00 |
3 | SpiceJet
| India |
| 26 | 3 | Mumbai | Kolkata | 2024-11-14 21:47:04 | 2024-11-20 15:00:00 | 85 | 4500.00 |
3 | SpiceJet
| India |
| 27 | 4 | Chennai | Delhi | 2024-11-15 01:09:46 | 2024-11-20 08:30:00 | 108 | 6000.00 |
4 | GoAir
| India |
| 28 | 4 | Delhi | Chennai | 2024-11-15 01:40:40 | 2024-11-20 20:00:00 | 101 | 6000.00 |
4 | GoAir
| India |
| 29 | 5 | Mumbai | Goa | 2024-11-14 22:38:16 | 2024-11-20 14:30:00 | 119 | 2500.00 |
5 | Vistara
| India |
| 30 | 5 | Goa | Mumbai | 2024-11-15 01:36:41 | 2024-11-20 17:00:00 | 109 | 2500.00 |
5 | Vistara
| India |
| 31 | 6 | Pune | Delhi | 2024-11-14 22:44:45 | 2024-11-20 12:30:00 | 93 | 5500.00 |
6 | AirAsia India | India |
| 32 | 6 | Delhi | Pune | 2024-11-14 23:13:43 | 2024-11-20 20:30:00 | 92 | 5500.00 |
6 | AirAsia India | India |
| 33 | 7 | Ahmedabad | Mumbai | 2024-11-14 21:47:04 | 2024-11-20 09:00:00 | 105 |
4000.00 | 7 | Air India Express | India |
| 34 | 7 | Mumbai | Ahmedabad | 2024-11-14 21:47:04 | 2024-11-20 21:00:00 | 105 |
4000.00 | 7 | Air India Express | India |
| 35 | 8 | Bangalore | Chennai | 2024-11-14 21:47:04 | 2024-11-20 09:00:00 | 130 |
3500.00 | 8 | Alliance Air | India |
| 36 | 8 | Chennai | Bangalore | 2024-11-14 21:47:04 | 2024-11-20 11:00:00 | 130 |
3500.00 | 8 | Alliance Air | India |
| 37 | 9 | Hyderabad | Kolkata | 2024-11-14 21:47:04 | 2024-11-20 06:30:00 | 75 | 4700.00
| 9 | Star Air
| India |
| 38 | 9 | Kolkata | Hyderabad | 2024-11-14 21:47:04 | 2024-11-20 15:30:00 | 75 | 4700.00
| 9 | Star Air
| India |
| 39 | 10 | Delhi | Goa | 2024-11-14 21:47:04 | 2024-11-20 12:30:00 | 115 | 5200.00 |
10 | TruJet
| India |
| 40 | 10 | Goa | Delhi | 2024-11-15 01:22:42 | 2024-11-20 18:30:00 | 113 | 5200.00 |
10 | TruJet
| India |
+-----------+------------+-----------+-------------+---------------------+---------------------+-----------------+---------+------------+-------------------+-
--------+
20 rows in set (0.00 sec)

[Link] a unique list of flights grouped by their departure city (source), displaying
only the flight_id, source (departure city), and seats_available. This will show one flight
per departure city.

mysql> select flight_id,source,seats_available from flight group by source;

+-----------+-----------+-----------------+
| flight_id | source | seats_available |
+-----------+-----------+-----------------+
| 33 | Ahmedabad | 105 |
| 23 | Bangalore | 90 |
| 27 | Chennai | 108 |
| 22 | Delhi | 100 |
| 30 | Goa | 109 |
| 24 | Hyderabad | 90 |
| 25 | Kolkata | 85 |
| 21 | Mumbai | 99 |
| 31 | Pune | 93 |
+-----------+-----------+-----------------+
9 rows in set (0.01 sec)

7. join ticket and reservation by cartessian product

mysql> SELECT *
-> FROM ticket, reservation;
+-----------+----------------+---------------------+---------------------+----------------+--------------+-----------+---------------------+-----------+
| ticket_id | reservation_id | issue_date | cancellation_reason | reservation_id | passenger_id | flight_id
| reservation_date | status |
+-----------+----------------+---------------------+---------------------+----------------+--------------+-----------+---------------------+-----------+
| 1| 1 | 2024-11-14 21:25:34 | NULL | 1| 1| 21 | 2024-11-14 21:25:34
| Cancelled |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 1| 1| 21 | 2024-11-14 21:25:34
| Cancelled |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 1| 1| 21 | 2024-11-14 21:25:34
| Cancelled |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 1| 1| 21 | 2024-11-14 21:25:34
| Cancelled |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 1| 1| 21 | 2024-11-14 21:25:34
| Cancelled |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 1| 1| 21 | 2024-11-14 21:25:34
| Cancelled |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 1| 1| 21 | 2024-11-14 21:25:34
| Cancelled |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 1| 1| 21 | 2024-11-14 21:25:34
| Cancelled |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 1| 1| 21 | 2024-11-14 21:25:34
| Cancelled |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 1| 1| 21 | 2024-11-14
21:25:34 | Cancelled |
| 11 | 12 | 2024-11-15 00:49:50 | NULL | 1| 1| 21 | 2024-11-14
21:25:34 | Cancelled |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 1| 1| 21 | 2024-11-14
21:25:34 | Cancelled |
| 13 | 14 | 2024-11-15 01:22:42 | Delay | 1| 1| 21 | 2024-11-14 21:25:34
| Cancelled |
| 14 | 15 | 2024-11-15 01:28:51 | emaegency | 1| 1| 21 | 2024-11-14
21:25:34 | Cancelled |
| 15 | 16 | 2024-11-15 01:36:41 | Emergency | 1| 1| 21 | 2024-11-14
21:25:34 | Cancelled |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 1| 1| 21 | 2024-11-14
21:25:34 | Cancelled |
| 1| 1 | 2024-11-14 21:25:34 | NULL | 2| 2| 30 | 2024-11-14 21:29:41
| Cancelled |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 2| 2| 30 | 2024-11-14 21:29:41
| Cancelled |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 2| 2| 30 | 2024-11-14 21:29:41
| Cancelled |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 2| 2| 30 | 2024-11-14 21:29:41
| Cancelled |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 2| 2| 30 | 2024-11-14 21:29:41
| Cancelled |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 2| 2| 30 | 2024-11-14 21:29:41
| Cancelled |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 2| 2| 30 | 2024-11-14 21:29:41
| Cancelled |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 2| 2| 30 | 2024-11-14 21:29:41
| Cancelled |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 2| 2| 30 | 2024-11-14 21:29:41
| Cancelled |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 2| 2| 30 | 2024-11-14
21:29:41 | Cancelled |
| 11 | 12 | 2024-11-15 00:49:50 | NULL | 2| 2| 30 | 2024-11-14
21:29:41 | Cancelled |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 2| 2| 30 | 2024-11-14
21:29:41 | Cancelled |
| 13 | 14 | 2024-11-15 01:22:42 | Delay | 2| 2| 30 | 2024-11-14 21:29:41
| Cancelled |
| 14 | 15 | 2024-11-15 01:28:51 | emaegency | 2| 2| 30 | 2024-11-14
21:29:41 | Cancelled |
| 15 | 16 | 2024-11-15 01:36:41 | Emergency | 2| 2| 30 | 2024-11-14
21:29:41 | Cancelled |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 2| 2| 30 | 2024-11-14
21:29:41 | Cancelled |
| 1| 1 | 2024-11-14 21:25:34 | NULL | 3| 3| 28 | 2024-11-14 21:50:06
| Booked |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 3| 3| 28 | 2024-11-14 21:50:06
| Booked |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 3| 3| 28 | 2024-11-14 21:50:06
| Booked |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 3| 3| 28 | 2024-11-14 21:50:06
| Booked |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 3| 3| 28 | 2024-11-14 21:50:06
| Booked |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 3| 3| 28 | 2024-11-14 21:50:06
| Booked |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 3| 3| 28 | 2024-11-14 21:50:06
| Booked |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 3| 3| 28 | 2024-11-14 21:50:06
| Booked |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 3| 3| 28 | 2024-11-14 21:50:06
| Booked |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 3| 3| 28 | 2024-11-14
21:50:06 | Booked |
| 11 | 12 | 2024-11-15 00:49:50 | NULL | 3| 3| 28 | 2024-11-14
21:50:06 | Booked |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 3| 3| 28 | 2024-11-14
21:50:06 | Booked |
| 13 | 14 | 2024-11-15 01:22:42 | Delay | 3| 3| 28 | 2024-11-14 21:50:06
| Booked |
| 14 | 15 | 2024-11-15 01:28:51 | emaegency | 3| 3| 28 | 2024-11-14
21:50:06 | Booked |
| 15 | 16 | 2024-11-15 01:36:41 | Emergency | 3| 3| 28 | 2024-11-14
21:50:06 | Booked |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 3| 3| 28 | 2024-11-14
21:50:06 | Booked |
| 1| 1 | 2024-11-14 21:25:34 | NULL | 4| 3| 28 | 2024-11-14 21:52:44
| Booked |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 4| 3| 28 | 2024-11-14 21:52:44
| Booked |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 4| 3| 28 | 2024-11-14 21:52:44
| Booked |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 4| 3| 28 | 2024-11-14 21:52:44
| Booked |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 4| 3| 28 | 2024-11-14 21:52:44
| Booked |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 4| 3| 28 | 2024-11-14 21:52:44
| Booked |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 4| 3| 28 | 2024-11-14 21:52:44
| Booked |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 4| 3| 28 | 2024-11-14 21:52:44
| Booked |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 4| 3| 28 | 2024-11-14 21:52:44
| Booked |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 4| 3| 28 | 2024-11-14
21:52:44 | Booked |
| 11 | 12 | 2024-11-15 00:49:50 | NULL | 4| 3| 28 | 2024-11-14
21:52:44 | Booked |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 4| 3| 28 | 2024-11-14
21:52:44 | Booked |
| 13 | 14 | 2024-11-15 01:22:42 | Delay | 4| 3| 28 | 2024-11-14 21:52:44
| Booked |
| 14 | 15 | 2024-11-15 01:28:51 | emaegency | 4| 3| 28 | 2024-11-14
21:52:44 | Booked |
| 15 | 16 | 2024-11-15 01:36:41 | Emergency | 4| 3| 28 | 2024-11-14
21:52:44 | Booked |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 4| 3| 28 | 2024-11-14
21:52:44 | Booked |
| 1| 1 | 2024-11-14 21:25:34 | NULL | 5| 5| 28 | 2024-11-14 22:24:44
| Booked |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 5| 5| 28 | 2024-11-14 22:24:44
| Booked |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 5| 5| 28 | 2024-11-14 22:24:44
| Booked |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 5| 5| 28 | 2024-11-14 22:24:44
| Booked |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 5| 5| 28 | 2024-11-14 22:24:44
| Booked |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 5| 5| 28 | 2024-11-14 22:24:44
| Booked |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 5| 5| 28 | 2024-11-14 22:24:44
| Booked |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 5| 5| 28 | 2024-11-14 22:24:44
| Booked |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 5| 5| 28 | 2024-11-14 22:24:44
| Booked |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 5| 5| 28 | 2024-11-14
22:24:44 | Booked |
| 11 | 12 | 2024-11-15 00:49:50 | NULL | 5| 5| 28 | 2024-11-14
22:24:44 | Booked |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 5| 5| 28 | 2024-11-14
22:24:44 | Booked |
| 13 | 14 | 2024-11-15 01:22:42 | Delay | 5| 5| 28 | 2024-11-14 22:24:44
| Booked |
| 14 | 15 | 2024-11-15 01:28:51 | emaegency | 5| 5| 28 | 2024-11-14
22:24:44 | Booked |
| 15 | 16 | 2024-11-15 01:36:41 | Emergency | 5| 5| 28 | 2024-11-14
22:24:44 | Booked |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 5| 5| 28 | 2024-11-14
22:24:44 | Booked |
| 1| 1 | 2024-11-14 21:25:34 | NULL | 6| 6| 28 | 2024-11-14 22:28:20
| Booked |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 6| 6| 28 | 2024-11-14 22:28:20
| Booked |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 6| 6| 28 | 2024-11-14 22:28:20
| Booked |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 6| 6| 28 | 2024-11-14 22:28:20
| Booked |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 6| 6| 28 | 2024-11-14 22:28:20
| Booked |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 6| 6| 28 | 2024-11-14 22:28:20
| Booked |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 6| 6| 28 | 2024-11-14 22:28:20
| Booked |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 6| 6| 28 | 2024-11-14 22:28:20
| Booked |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 6| 6| 28 | 2024-11-14 22:28:20
| Booked |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 6| 6| 28 | 2024-11-14
22:28:20 | Booked |
| 11 | 12 | 2024-11-15 00:49:50 | NULL | 6| 6| 28 | 2024-11-14
22:28:20 | Booked |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 6| 6| 28 | 2024-11-14
22:28:20 | Booked |
| 13 | 14 | 2024-11-15 01:22:42 | Delay | 6| 6| 28 | 2024-11-14 22:28:20
| Booked |
| 14 | 15 | 2024-11-15 01:28:51 | emaegency | 6| 6| 28 | 2024-11-14
22:28:20 | Booked |
| 15 | 16 | 2024-11-15 01:36:41 | Emergency | 6| 6| 28 | 2024-11-14
22:28:20 | Booked |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 6| 6| 28 | 2024-11-14
22:28:20 | Booked |
| 1| 1 | 2024-11-14 21:25:34 | NULL | 7| 6| 29 | 2024-11-14 22:38:16
| Booked |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 7| 6| 29 | 2024-11-14 22:38:16
| Booked |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 7| 6| 29 | 2024-11-14 22:38:16
| Booked |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 7| 6| 29 | 2024-11-14 22:38:16
| Booked |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 7| 6| 29 | 2024-11-14 22:38:16
| Booked |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 7| 6| 29 | 2024-11-14 22:38:16
| Booked |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 7| 6| 29 | 2024-11-14 22:38:16
| Booked |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 7| 6| 29 | 2024-11-14 22:38:16
| Booked |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 7| 6| 29 | 2024-11-14 22:38:16
| Booked |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 7| 6| 29 | 2024-11-14
22:38:16 | Booked |
| 11 | 12 | 2024-11-15 00:49:50 | NULL | 7| 6| 29 | 2024-11-14
22:38:16 | Booked |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 7| 6| 29 | 2024-11-14
22:38:16 | Booked |
| 13 | 14 | 2024-11-15 01:22:42 | Delay | 7| 6| 29 | 2024-11-14 22:38:16
| Booked |
| 14 | 15 | 2024-11-15 01:28:51 | emaegency | 7| 6| 29 | 2024-11-14
22:38:16 | Booked |
| 15 | 16 | 2024-11-15 01:36:41 | Emergency | 7| 6| 29 | 2024-11-14
22:38:16 | Booked |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 7| 6| 29 | 2024-11-14
22:38:16 | Booked |
| 1| 1 | 2024-11-14 21:25:34 | NULL | 8| 5| 31 | 2024-11-14 22:44:45
| Cancelled |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 8| 5| 31 | 2024-11-14 22:44:45
| Cancelled |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 8| 5| 31 | 2024-11-14 22:44:45
| Cancelled |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 8| 5| 31 | 2024-11-14 22:44:45
| Cancelled |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 8| 5| 31 | 2024-11-14 22:44:45
| Cancelled |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 8| 5| 31 | 2024-11-14 22:44:45
| Cancelled |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 8| 5| 31 | 2024-11-14 22:44:45
| Cancelled |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 8| 5| 31 | 2024-11-14 22:44:45
| Cancelled |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 8| 5| 31 | 2024-11-14 22:44:45
| Cancelled |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 8| 5| 31 | 2024-11-14
22:44:45 | Cancelled |
| 11 | 12 | 2024-11-15 00:49:50 | NULL | 8| 5| 31 | 2024-11-14
22:44:45 | Cancelled |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 8| 5| 31 | 2024-11-14
22:44:45 | Cancelled |
| 13 | 14 | 2024-11-15 01:22:42 | Delay | 8| 5| 31 | 2024-11-14 22:44:45
| Cancelled |
| 14 | 15 | 2024-11-15 01:28:51 | emaegency | 8| 5| 31 | 2024-11-14
22:44:45 | Cancelled |
| 15 | 16 | 2024-11-15 01:36:41 | Emergency | 8| 5| 31 | 2024-11-14
22:44:45 | Cancelled |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 8| 5| 31 | 2024-11-14
22:44:45 | Cancelled |
| 1| 1 | 2024-11-14 21:25:34 | NULL | 9| 7| 28 | 2024-11-14 23:02:32
| Booked |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 9| 7| 28 | 2024-11-14 23:02:32
| Booked |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 9| 7| 28 | 2024-11-14 23:02:32
| Booked |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 9| 7| 28 | 2024-11-14 23:02:32
| Booked |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 9| 7| 28 | 2024-11-14 23:02:32
| Booked |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 9| 7| 28 | 2024-11-14 23:02:32
| Booked |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 9| 7| 28 | 2024-11-14 23:02:32
| Booked |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 9| 7| 28 | 2024-11-14 23:02:32
| Booked |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 9| 7| 28 | 2024-11-14 23:02:32
| Booked |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 9| 7| 28 | 2024-11-14
23:02:32 | Booked |
| 11 | 12 | 2024-11-15 00:49:50 | NULL | 9| 7| 28 | 2024-11-14
23:02:32 | Booked |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 9| 7| 28 | 2024-11-14
23:02:32 | Booked |
| 13 | 14 | 2024-11-15 01:22:42 | Delay | 9| 7| 28 | 2024-11-14 23:02:32
| Booked |
| 14 | 15 | 2024-11-15 01:28:51 | emaegency | 9| 7| 28 | 2024-11-14
23:02:32 | Booked |
| 15 | 16 | 2024-11-15 01:36:41 | Emergency | 9| 7| 28 | 2024-11-14
23:02:32 | Booked |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 9| 7| 28 | 2024-11-14
23:02:32 | Booked |
| 1| 1 | 2024-11-14 21:25:34 | NULL | 10 | 2| 32 | 2024-11-14 23:13:43
| Booked |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 10 | 2| 32 | 2024-11-14 23:13:43
| Booked |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 10 | 2| 32 | 2024-11-14 23:13:43
| Booked |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 10 | 2| 32 | 2024-11-14 23:13:43
| Booked |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 10 | 2| 32 | 2024-11-14 23:13:43
| Booked |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 10 | 2| 32 | 2024-11-14 23:13:43
| Booked |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 10 | 2| 32 | 2024-11-14 23:13:43
| Booked |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 10 | 2| 32 | 2024-11-14 23:13:43
| Booked |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 10 | 2| 32 | 2024-11-14
23:13:43 | Booked |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 10 | 2| 32 | 2024-11-14
23:13:43 | Booked |
| 11 | 12 | 2024-11-15 00:49:50 | NULL | 10 | 2| 32 | 2024-11-14
23:13:43 | Booked |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 10 | 2| 32 | 2024-11-14
23:13:43 | Booked |
| 13 | 14 | 2024-11-15 01:22:42 | Delay | 10 | 2| 32 | 2024-11-14
23:13:43 | Booked |
| 14 | 15 | 2024-11-15 01:28:51 | emaegency | 10 | 2| 32 | 2024-11-14
23:13:43 | Booked |
| 15 | 16 | 2024-11-15 01:36:41 | Emergency | 10 | 2| 32 | 2024-11-14
23:13:43 | Booked |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 10 | 2| 32 | 2024-11-14
23:13:43 | Booked |
| 1| 1 | 2024-11-14 21:25:34 | NULL | 11 | 9| 30 | 2024-11-15 00:20:05
| Booked |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 11 | 9| 30 | 2024-11-15 00:20:05
| Booked |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 11 | 9| 30 | 2024-11-15 00:20:05
| Booked |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 11 | 9| 30 | 2024-11-15 00:20:05
| Booked |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 11 | 9| 30 | 2024-11-15 00:20:05
| Booked |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 11 | 9| 30 | 2024-11-15 00:20:05
| Booked |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 11 | 9| 30 | 2024-11-15 00:20:05
| Booked |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 11 | 9| 30 | 2024-11-15 00:20:05
| Booked |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 11 | 9| 30 | 2024-11-15
00:20:05 | Booked |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 11 | 9| 30 | 2024-11-15
00:20:05 | Booked |
| 11 | 12 | 2024-11-15 00:49:50 | NULL | 11 | 9| 30 | 2024-11-15
00:20:05 | Booked |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 11 | 9| 30 | 2024-11-15
00:20:05 | Booked |
| 13 | 14 | 2024-11-15 01:22:42 | Delay | 11 | 9| 30 | 2024-11-15
00:20:05 | Booked |
| 14 | 15 | 2024-11-15 01:28:51 | emaegency | 11 | 9| 30 | 2024-11-15
00:20:05 | Booked |
| 15 | 16 | 2024-11-15 01:36:41 | Emergency | 11 | 9| 30 | 2024-11-15
00:20:05 | Booked |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 11 | 9| 30 | 2024-11-15
00:20:05 | Booked |
| 1| 1 | 2024-11-14 21:25:34 | NULL | 12 | 7| 30 | 2024-11-15 00:49:50
| Booked |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 12 | 7| 30 | 2024-11-15 00:49:50
| Booked |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 12 | 7| 30 | 2024-11-15 00:49:50
| Booked |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 12 | 7| 30 | 2024-11-15 00:49:50
| Booked |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 12 | 7| 30 | 2024-11-15 00:49:50
| Booked |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 12 | 7| 30 | 2024-11-15 00:49:50
| Booked |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 12 | 7| 30 | 2024-11-15 00:49:50
| Booked |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 12 | 7| 30 | 2024-11-15 00:49:50
| Booked |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 12 | 7| 30 | 2024-11-15
00:49:50 | Booked |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 12 | 7| 30 | 2024-11-15 00:4|
11 | 12 | 2024-11-15 00:49:50 | NULL | 12 | 7| 30 | 2024-11-15 00:49:50 |
Booked |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 12 | 7| 30 | 2024-11-15
00:49:50 | Boo
ked | | 13 | 14 |
2024-11-15 01:22:42 | Delay | 12 | 7| 30 | 2024-11-15 00:49:50 | Boo
ked | 16 | 2024-11-15 01:36:41 | Emergency | 12 | 7| 30 | 2024-11-15
00:49:50 | Booked |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 12 | 7| 30 | 2024-11-15
00:49:50 | Booked |
| 1| 1 | 2024-11-14 21:25:34 | NULL | 13 | 10 | 27 | 2024-11-15
01:09:46 | Cancelled |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 13 | 10 | 27 | 2024-11-15
01:09:46 | Cancelled |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 13 | 10 | 27 | 2024-11-15
01:09:46 | Cancelled |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 13 | 10 | 27 | 2024-11-15
01:09:46 | Cancelled |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 13 | 10 | 27 | 2024-11-15
01:09:46 | Cancelled |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 13 | 10 | 27 | 2024-11-15
01:09:46 | Cancelled |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 13 | 10 | 27 | 2024-11-15
01:09:46 | Cancelled |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 13 | 10 | 27 | 2024-11-15
01:09:46 | Cancelled |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 13 | 10 | 27 | 2024-11-15
01:09:46 | Cancelled |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 13 | 10 | 27 | 2024-11-15
01:09:46 | Cancelled |
| 11 | 12 | 2024-11-15 00:49:50 | NULL | 13 | 10 | 27 | 2024-11-15
01:09:46 | Cancelled |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 13 | 10 | 27 | 2024-11-15
01:09:46 | Cancelled |
| 13 | 14 | 2024-11-15 01:22:42 | Delay | 13 | 10 | 27 | 2024-11-15
01:09:46 | Cancelled |
| 14 | 15 | 2024-11-15 01:28:51 | emaegency | 13 | 10 | 27 | 2024-11-15
01:09:46 | Cancelled |
| 15 | 16 | 2024-11-15 01:36:41 | Emergency | 13 | 10 | 27 | 2024-11-15
01:09:46 | Cancelled |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 13 | 10 | 27 | 2024-11-15
01:09:46 | Cancelled |
| 1| 1 | 2024-11-14 21:25:34 | NULL | 14 | 11 | 40 | 2024-11-15
01:22:42 | Cancelled |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 14 | 11 | 40 | 2024-11-15
01:22:42 | Cancelled |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 14 | 11 | 40 | 2024-11-15
01:22:42 | Cancelled |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 14 | 11 | 40 | 2024-11-15
01:22:42 | Cancelled |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 14 | 11 | 40 | 2024-11-15
01:22:42 | Cancelled |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 14 | 11 | 40 | 2024-11-15
01:22:42 | Cancelled |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 14 | 11 | 40 | 2024-11-15
01:22:42 | Cancelled |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 14 | 11 | 40 | 2024-11-15
01:22:42 | Cancelled |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 14 | 11 | 40 | 2024-11-15
01:22:42 | Cancelled |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 14 | 11 | 40 | 2024-11-15
01:22:42 | Cancelled |
| 11 | 12 | 2024-11-15 00:49:50 | NULL | 14 | 11 | 40 | 2024-11-15
01:22:42 | Cancelled |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 14 | 11 | 40 | 2024-11-15
01:22:42 | Cancelled |
| 13 | 14 | 2024-11-15 01:22:42 | Delay | 14 | 11 | 40 | 2024-11-15
01:22:42 | Cancelled |
| 14 | 15 | 2024-11-15 01:28:51 | emaegency | 14 | 11 | 40 | 2024-11-15
01:22:42 | Cancelled |
| 15 | 16 | 2024-11-15 01:36:41 | Emergency | 14 | 11 | 40 | 2024-11-15
01:22:42 | Cancelled |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 14 | 11 | 40 | 2024-11-15
01:22:42 | Cancelled |
| 1| 1 | 2024-11-14 21:25:34 | NULL | 15 | 12 | 30 | 2024-11-15
01:28:51 | Cancelled |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 15 | 12 | 30 | 2024-11-15
01:28:51 | Cancelled |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 15 | 12 | 30 | 2024-11-15
01:28:51 | Cancelled |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 15 | 12 | 30 | 2024-11-15
01:28:51 | Cancelled |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 15 | 12 | 30 | 2024-11-15
01:28:51 | Cancelled |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 15 | 12 | 30 | 2024-11-15
01:28:51 | Cancelled |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 15 | 12 | 30 | 2024-11-15
01:28:51 | Cancelled |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 15 | 12 | 30 | 2024-11-15
01:28:51 | Cancelled |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 15 | 12 | 30 | 2024-11-15
01:28:51 | Cancelled |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 15 | 12 | 30 | 2024-11-15
01:28:51 | Cancelled |
| 11 | 12 | 2024-11-15 00:49:50 | NULL | 15 | 12 | 30 | 2024-11-15
01:28:51 | Cancelled |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 15 | 12 | 30 | 2024-11-15
01:28:51 | Cancelled |
| 13 | 14 | 2024-11-15 01:22:42 | Delay | 15 | 12 | 30 | 2024-11-15
01:28:51 | Cancelled |
| 14 | 15 | 2024-11-15 01:28:51 | emaegency | 15 | 12 | 30 | 2024-11-15
01:28:51 | Cancelled |
| 15 | 16 | 2024-11-15 01:36:41 | Emergency | 15 | 12 | 30 | 2024-11-15
01:28:51 | Cancelled |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 15 | 12 | 30 | 2024-11-15
01:28:51 | Cancelled |
| 1| 1 | 2024-11-14 21:25:34 | NULL | 16 | 13 | 30 | 2024-11-15
01:36:41 | Cancelled |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 16 | 13 | 30 | 2024-11-15
01:36:41 | Cancelled |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 16 | 13 | 30 | 2024-11-15
01:36:41 | Cancelled |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 16 | 13 | 30 | 2024-11-15
01:36:41 | Cancelled |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 16 | 13 | 30 | 2024-11-15
01:36:41 | Cancelled |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 16 | 13 | 30 | 2024-11-15
01:36:41 | Cancelled |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 16 | 13 | 30 | 2024-11-15
01:36:41 | Cancelled |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 16 | 13 | 30 | 2024-11-15
01:36:41 | Cancelled |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 16 | 13 | 30 | 2024-11-15
01:36:41 | Cancelled |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 16 | 13 | 30 | 2024-11-15
01:36:41 | Cancelled |
| 11 | 12 | 2024-11-15 00:49:50 | NULL | 16 | 13 | 30 | 2024-11-15
01:36:41 | Cancelled |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 16 | 13 | 30 | 2024-11-15
01:36:41 | Cancelled |
| 13 | 14 | 2024-11-15 01:22:42 | Delay | 16 | 13 | 30 | 2024-11-15
01:36:41 | Cancelled |
| 14 | 15 | 2024-11-15 01:28:51 | emaegency | 16 | 13 | 30 | 2024-11-15
01:36:41 | Cancelled |
| 15 | 16 | 2024-11-15 01:36:41 | Emergency | 16 | 13 | 30 | 2024-11-15
01:36:41 | Cancelled |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 16 | 13 | 30 | 2024-11-15
01:36:41 | Cancelled |
| 1| 1 | 2024-11-14 21:25:34 | NULL | 17 | 2| 28 | 2024-11-15 01:40:40
| Booked |
| 2| 2 | 2024-11-14 21:29:41 | NULL | 17 | 2| 28 | 2024-11-15 01:40:40
| Booked |
| 3| 4 | 2024-11-14 21:53:59 | NULL | 17 | 2| 28 | 2024-11-15 01:40:40
| Booked |
| 4| 5 | 2024-11-14 22:24:44 | NULL | 17 | 2| 28 | 2024-11-15 01:40:40
| Booked |
| 5| 6 | 2024-11-14 22:28:20 | NULL | 17 | 2| 28 | 2024-11-15 01:40:40
| Booked |
| 6| 7 | 2024-11-14 22:38:16 | NULL | 17 | 2| 28 | 2024-11-15 01:40:40
| Booked |
| 7| 8 | 2024-11-14 22:44:45 | NULL | 17 | 2| 28 | 2024-11-15 01:40:40
| Booked |
| 8| 9 | 2024-11-14 23:02:32 | NULL | 17 | 2| 28 | 2024-11-15 01:40:40
| Booked |
| 9| 10 | 2024-11-14 23:13:43 | NULL | 17 | 2| 28 | 2024-11-15
01:40:40 | Booked |
| 10 | 11 | 2024-11-15 00:20:05 | NULL | 17 | 2| 28 | 2024-11-15
01:40:40 | Booked |
| 11 | 12 | 2024-11-15 00:49:50 | NULL | 17 | 2| 28 | 2024-11-15
01:40:40 | Booked |
| 12 | 13 | 2024-11-15 01:09:46 | Medical | 17 | 2| 28 | 2024-11-15
01:40:40 | Booked |
| 13 | 14 | 2024-11-15 01:22:42 | Delay | 17 | 2| 28 | 2024-11-15
01:40:40 | Booked |
| 14 | 15 | 2024-11-15 01:28:51 | emaegency | 17 | 2| 28 | 2024-11-15
01:40:40 | Booked |
| 15 | 16 | 2024-11-15 01:36:41 | Emergency | 17 | 2| 28 | 2024-11-15
01:40:40 | Booked |
| 16 | 17 | 2024-11-15 01:40:40 | NULL | 17 | 2| 28 | 2024-11-15
01:40:40 | Booked |
+-----------+----------------+---------------------+---------------------+----------------+--------------+-----------+---------------------+-----------+
272 rows in set (0.01 sec)

8)mysql>Retrieve the passenger_id, reservation_id, and first_name of passengers who

have a reservation, displaying each passenger’s reservation details.

mysql> SELECT passenger.passenger_id, reservation.reservation_id, passenger.first_name

-> FROM passenger
-> INNER JOIN reservation ON passenger.passenger_id = reservation.passenger_id;
+--------------+----------------+------------+
| passenger_id | reservation_id | first_name |
+--------------+----------------+------------+
| 1| 1 | shrutika |
| 2| 2 | swati |
| 2| 10 | swati |
| 2| 17 | swati |
| 3| 3 | samiksha |
| 3| 4 | samiksha |
| 5| 5 | priya |
| 5| 8 | priya |
| 6| 6 | pratik |
| 6| 7 | pratik |
| 7| 9 | kirti |
| 7| 12 | kirti |
| 9| 11 | pooja |
| 10 | 13 | Soham |
| 11 | 14 | ram |
| 12 | 15 | sakshi |
| 13 | 16 | varad |
+--------------+----------------+------------+
17 rows in set (0.00 sec)

mysql>
9)Find the passenger who has made the most reservations.

mysql> SELECT first_name, email

-> FROM passenger
-> WHERE passenger_id = (
-> SELECT passenger_id
-> FROM reservation
-> GROUP BY passenger_id
-> ORDER BY COUNT(reservation_id) DESC
 -> LIMIT 1
-> );
+------------+-------------------------+
| first_name | email |
+------------+-------------------------+
| swati | [Link]@[Link] |
+------------+-------------------------+
1 row in set (0.01 sec)

mysql>

10)Write a query to get all flight details along with the passengers who have booked
these flights, including flights that have no reservations.

mysql> SELECT f.flight_id, p.first_name, p.last_name

-> FROM Flight f
-> RIGHT OUTER JOIN Reservation r ON f.flight_id = r.flight_id
-> RIGHT OUTER JOIN Passenger p ON r.passenger_id = p.passenger_id;
+-----------+------------+-----------+
| flight_id | first_name | last_name |
+-----------+------------+-----------+
| 21 | shrutika | Nalavade |
| 30 | swati | kumbhar |
| 32 | swati | kumbhar |
| 28 | swati | kumbhar |
| 28 | samiksha | patil |
| 28 | samiksha | patil |
| NULL | riya | chaudhari |
| 28 | priya | mohite |
| 31 | priya | mohite |
| 28 | pratik | mane |
| 29 | pratik | mane |
| 28 | kirti | joshi |
| 30 | kirti | joshi |
| NULL | preeti | pardeshi |
| 30 | pooja | mane |
| 27 | Soham | Kumbhar |
| 40 | ram | kumbhar |
| 30 | sakshi | joshi |
| 30 | varad | mohite |
+-----------+------------+-----------+
19 rows in set (0.01 sec)

11)Write a query to create a view that shows a list of passengers and the
corresponding flight details.
mysql> select*from passenger_flight_details;
+------------+-----------+-----------+
| first_name | last_name | flight_id |
+------------+-----------+-----------+
| shrutika | Nalavade | 21 |
| swati | kumbhar | 30 |
| samiksha | patil | 28 |
| samiksha | patil | 28 |
| priya | mohite | 28 |
| pratik | mane | 28 |
| pratik | mane | 29 |
| priya | mohite | 31 |
| kirti | joshi | 28 |
| swati | kumbhar | 32 |
| pooja | mane | 30 |
| kirti | joshi | 30 |
| Soham | Kumbhar | 27 |
| ram | kumbhar | 40 |
| sakshi | joshi | 30 |
| varad | mohite | 30 |
| swati | kumbhar | 28 |
+------------+-----------+-----------+
17 rows in set (0.01 sec)

mysql>

12)Write a query to create an index on the reservation_date column of the Reservation

table.

mysql> CREATE INDEX idx_reservation_date ON Reservation(reservation_date);

Query OK, 0 rows affected (0.03 sec)
Records: 0 Duplicates: 0 Warnings: 0

13)create trigger which will insert name of airline in uppercase before inserting record
mysql> DELIMITER //
mysql>
mysql> CREATE TRIGGER t1
-> BEFORE INSERT ON Airline
-> FOR EACH ROW
-> BEGIN
-> SET [Link] = UPPER([Link]);
-> END //
Query OK, 0 rows affected (0.01 sec)

mysql>
mysql> DELIMITER ;
mysql> insert into airline values(100,"mahalakshmi","india");
Query OK, 1 row affected (0.01 sec)

mysql> select*from airline;

+------------+-------------------+---------+
| airline_id | name | country |
+------------+-------------------+---------+
| 1 | Air India | India |
| 2 | IndiGo | India |
| 3 | SpiceJet | India |
| 4 | GoAir | India |
| 5 | Vistara | India |
| 6 | AirAsia India | India |
| 7 | Air India Express | India |
| 8 | Alliance Air | India |
| 9 | Star Air | India |
| 10 | TruJet | India |
| 100 | MAHALAKSHMI | india |
+------------+-------------------+---------+
11 rows in set (0.00 sec)

13)Write a stored procedure that fetches passenger name through passenger id

mysql> delimiter //
mysql> create procedure p1(in passenger_id int,out pass_name varchar(90)
-> )begin
-> select first_name into pass_name from passenger where passenger.passenger_id=passenger_id;
-> end
-> //
Query OK, 0 rows affected (0.00 sec)
mysql> call p1(4,@pn);
Query OK, 1 row affected (0.00 sec)

mysql> select @pn;

+------+
| @pn |
+------+
| riya |
+------+
1 row in set (0.00 sec)

mysql>

14)Write a query to find the unique flight numbers that have been reserved.
mysql> SELECT DISTINCT flight_id FROM Reservation;
+-----------+
| flight_id |
+-----------+
| 21 |
| 27 |
| 28 |
| 29 |
| 30 |
| 31 |
| 32 |
| 40 |
+-----------+
8 rows in set (0.01 sec)

mysql>

15)updating price to 8000 where flight id =23

mysql> update flight set price=8000 where flight_id=23;

Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0

mysql> select*from flight;

+-----------+------------+-----------+-------------+---------------------+---------------------+-----------------+---------+
| flight_id | airline_id | source | destination | departure_time | arrival_time | seats_available | price |
+-----------+------------+-----------+-------------+---------------------+---------------------+-----------------+---------+
| 21 | 1 | Mumbai | Delhi | 2024-11-14 21:47:04 | 2024-11-20 11:30:00 | 99 | 5000.00 |
| 22 | 1 | Delhi | Mumbai | 2024-11-14 21:47:04 | 2024-11-20 16:30:00 | 100 | 5000.00 |
| 23 | 2 | Bangalore | Hyderabad | 2024-11-15 03:30:58 | 2024-11-20 08:15:00 | 90 |
8000.00 |
| 24 | 2 | Hyderabad | Bangalore | 2024-11-14 21:47:04 | 2024-11-20 11:15:00 | 90 |
3000.00 |
| 25 | 3 | Kolkata | Mumbai | 2024-11-14 21:47:04 | 2024-11-20 09:00:00 | 85 | 4500.00 |
| 26 | 3 | Mumbai | Kolkata | 2024-11-14 21:47:04 | 2024-11-20 15:00:00 | 85 | 4500.00 |
| 27 | 4 | Chennai | Delhi | 2024-11-15 01:09:46 | 2024-11-20 08:30:00 | 108 | 6000.00 |
| 28 | 4 | Delhi | Chennai | 2024-11-15 01:40:40 | 2024-11-20 20:00:00 | 101 | 6000.00 |
| 29 | 5 | Mumbai | Goa | 2024-11-14 22:38:16 | 2024-11-20 14:30:00 | 119 | 2500.00 |
| 30 | 5 | Goa | Mumbai | 2024-11-15 01:36:41 | 2024-11-20 17:00:00 | 109 | 2500.00 |
| 31 | 6 | Pune | Delhi | 2024-11-14 22:44:45 | 2024-11-20 12:30:00 | 93 | 5500.00 |
| 32 | 6 | Delhi | Pune | 2024-11-14 23:13:43 | 2024-11-20 20:30:00 | 92 | 5500.00 |
| 33 | 7 | Ahmedabad | Mumbai | 2024-11-14 21:47:04 | 2024-11-20 09:00:00 | 105 |
4000.00 |
| 34 | 7 | Mumbai | Ahmedabad | 2024-11-14 21:47:04 | 2024-11-20 21:00:00 | 105 |
4000.00 |
| 35 | 8 | Bangalore | Chennai | 2024-11-14 21:47:04 | 2024-11-20 09:00:00 | 130 |
3500.00 |
| 36 | 8 | Chennai | Bangalore | 2024-11-14 21:47:04 | 2024-11-20 11:00:00 | 130 |
3500.00 |
| 37 | 9 | Hyderabad | Kolkata | 2024-11-14 21:47:04 | 2024-11-20 06:30:00 | 75 | 4700.00
|
| 38 | 9 | Kolkata | Hyderabad | 2024-11-14 21:47:04 | 2024-11-20 15:30:00 | 75 | 4700.00
|
| 39 | 10 | Delhi | Goa | 2024-11-14 21:47:04 | 2024-11-20 12:30:00 | 115 | 5200.00 |
| 40 | 10 | Goa | Delhi | 2024-11-15 01:22:42 | 2024-11-20 18:30:00 | 113 | 5200.00 |
+-----------+------------+-----------+-------------+---------------------+---------------------+-----------------+---------+
20 rows in set (0.01 sec)

16)delete recors from airline where name="mahalakshimi"?

mysql>
mysql> delete from airline where name="mahalakshimi";
Query OK, 0 rows affected (0.00 sec)

mysql> select*from airline;

+------------+-------------------+---------+
| airline_id | name | country |
+------------+-------------------+---------+
| 1 | Air India | India |
| 2 | IndiGo | India |
| 3 | SpiceJet | India |
| 4 | GoAir | India |
| 5 | Vistara | India |
| 6 | AirAsia India | India |
| 7 | Air India Express | India |
| 8 | Alliance Air | India |
| 9 | Star Air | India |
| 10 | TruJet | India |
| 100 | MAHALAKSHMI | india |
+------------+-------------------+---------+
11 rows in set (0.00 sec)

17)display all airline start with alphabate 'a'?

mysql> select*from airline where name like "a%";

+------------+-------------------+---------+
| airline_id | name | country |
+------------+-------------------+---------+
| 1 | Air India | India |
| 6 | AirAsia India | India |
| 7 | Air India Express | India |
| 8 | Alliance Air | India |
+------------+-------------------+---------+
4 rows in set (0.00 sec)

mysql>

18)display distict source from flight table?

mysql> select distinct source from flight;

+-----------+
| source |
+-----------+
| Mumbai |
| Delhi |
| Bangalore |
| Hyderabad |
| Kolkata |
| Chennai |
| Goa |
| Pune |
| Ahmedabad |
+-----------+
9 rows in set (0.00 sec)

mysql>

19) display number of flghts going from one source along with their flight_id?

mysql> select flight_id,count(*) from flight group by source;

+-----------+----------+
| flight_id | count(*) |
+-----------+----------+
| 33 | 1|
| 23 | 2|
| 27 | 2|
| 22 | 4|
| 30 | 2|
| 24 | 2|
| 25 | 2|
| 21 | 4|
| 31 | 1|
+-----------+----------+
9 rows in set (0.01 sec)

20)display flight details in descending order of price

mysql> select*from flight order by price desc;
+-----------+------------+-----------+-------------+---------------------+---------------------+-----------------+---------+
| flight_id | airline_id | source | destination | departure_time | arrival_time | seats_available | price |
+-----------+------------+-----------+-------------+---------------------+---------------------+-----------------+---------+
| 23 | 2 | Bangalore | Hyderabad | 2024-11-15 03:30:58 | 2024-11-20 08:15:00 | 90 |
8000.00 |
| 28 | 4 | Delhi | Chennai | 2024-11-15 01:40:40 | 2024-11-20 20:00:00 | 101 | 6000.00 |
| 27 | 4 | Chennai | Delhi | 2024-11-15 01:09:46 | 2024-11-20 08:30:00 | 108 | 6000.00 |
| 31 | 6 | Pune | Delhi | 2024-11-14 22:44:45 | 2024-11-20 12:30:00 | 93 | 5500.00 |
| 32 | 6 | Delhi | Pune | 2024-11-14 23:13:43 | 2024-11-20 20:30:00 | 92 | 5500.00 |
| 39 | 10 | Delhi | Goa | 2024-11-14 21:47:04 | 2024-11-20 12:30:00 | 115 | 5200.00 |
| 40 | 10 | Goa | Delhi | 2024-11-15 01:22:42 | 2024-11-20 18:30:00 | 113 | 5200.00 |
| 21 | 1 | Mumbai | Delhi | 2024-11-14 21:47:04 | 2024-11-20 11:30:00 | 99 | 5000.00 |
| 22 | 1 | Delhi | Mumbai | 2024-11-14 21:47:04 | 2024-11-20 16:30:00 | 100 | 5000.00 |
| 38 | 9 | Kolkata | Hyderabad | 2024-11-14 21:47:04 | 2024-11-20 15:30:00 | 75 | 4700.00
|
| 37 | 9 | Hyderabad | Kolkata | 2024-11-14 21:47:04 | 2024-11-20 06:30:00 | 75 | 4700.00
|
| 26 | 3 | Mumbai | Kolkata | 2024-11-14 21:47:04 | 2024-11-20 15:00:00 | 85 | 4500.00 |
| 25 | 3 | Kolkata | Mumbai | 2024-11-14 21:47:04 | 2024-11-20 09:00:00 | 85 | 4500.00 |
| 33 | 7 | Ahmedabad | Mumbai | 2024-11-14 21:47:04 | 2024-11-20 09:00:00 | 105 |
4000.00 |
| 34 | 7 | Mumbai | Ahmedabad | 2024-11-14 21:47:04 | 2024-11-20 21:00:00 | 105 |
4000.00 |
| 35 | 8 | Bangalore | Chennai | 2024-11-14 21:47:04 | 2024-11-20 09:00:00 | 130 |
3500.00 |
| 36 | 8 | Chennai | Bangalore | 2024-11-14 21:47:04 | 2024-11-20 11:00:00 | 130 |
3500.00 |
| 24 | 2 | Hyderabad | Bangalore | 2024-11-14 21:47:04 | 2024-11-20 11:15:00 | 90 |
3000.00 |
| 30 | 5 | Goa | Mumbai | 2024-11-15 01:36:41 | 2024-11-20 17:00:00 | 109 | 2500.00 |
| 29 | 5 | Mumbai | Goa | 2024-11-14 22:38:16 | 2024-11-20 14:30:00 | 119 | 2500.00 |
+-----------+------------+-----------+-------------+---------------------+---------------------+-----------------+---------+
20 rows in set (0.00 sec)

mysql>