Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 NumberStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started