Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beginning VB.NET Databases

Authors: Thearon Willis

1st Edition

1594864217, 978-1594864216

More Books

Students also viewed these Databases questions

Question

2. What efforts are countries making to reverse the brain drain?

Answered: 1 week ago