Question: Create full SQL script for creating this database with everything shown in this schema including 1- determining primary [underlined] and foreign keys and unique (PK

Create full SQL script for creating this database with everything shown in this schema including

1- determining primary [underlined] and foreign keys and unique (PK or FK or U)

2- actions on foreign key when update or delete (nothing or cascade or delete on your valid assumption)

3- inserting some tuples for every relation to check the full database

Create full SQL script for creating this database with everything shown in

Flight Airports Clients Username Password Core City Country SSN First Name Last Name Phone Number Email Address Flight Number Fare Departure Time Departure From Arrival Time Arrival TO Available Seats Flight Date status Assigned Airplane Assigned Pilot ID Assigned Crew ID Airport Code Employees +ID Type First Name Last Name Username Password Date of Birth EK FO FO) Airplanes Airplane No Number of Seats Type Services Service No Service Name Service Price Service_Recured Service No FO Client Username FI Booking Username FK Flight Number IFK) Reservation Number

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!