Do not use GO command in your code
On completion, import your work by browsing to the above folder.
Note that:
+ You could use only SQL Server, SQL Server Management Studio, and paper or offline document in your computer.
+ If any of the previous requirements is not respected, your mark will be 0.
From the 2nd question, you should use the database provided in the sql file which has the following database diagram. Please, run the provided script to create tables and insert data into your database.
airline
id
code
name
country
8
flight
id
airline id
departing_airport
arriving_airport
departing_gate
arriving_gate
departure_time
arrival_time
Zoom
FUO
+ 100%
airport
id
code
name
country
state
city
8
100
booking
id
8
passenger_id
flight_id
00
booking_platform_id
booking_time
passenger
id
first_name
last_name
date_of_birth
country
email
gender
00
baggage id
booking_id
weight_in_kg
booking Platform
id
name
url
Close
