Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

plz I want an explanation of the Database schema diagram and Sample database state. Travel Travel- From To Travel- Time- Departure Arrival. Company- Number day

plz I want an explanation of the Database schema diagram and Sample database state. image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Travel Travel- From To Travel- Time- Departure Arrival. Company- Number day day time Time Number Company Company-Number Company Name Airpane Airpane-type Airpane- Number Passenger- Number Company- Number Passenger Passe Passe Passe Gen Passp Trans Trans Trans nger- nger- nger- der ort- port- port- port- numb Neckn Num Ticket Price ame ber Nu Trav el- Num ber er To Travel- day Time- day Travel Travel- Fro Numb m er 55 Al- Riyad 56 Al- Riyad 57 Al- Riyad 58 Al- Riyad 85 Al- Riyad 86 Al- Riyad 87 Riyad Berlin Sunday 15/09/20 19 Berlin Sunday 15/09/20 19 Berlin Sunday 17/09/20 19 Egypt Tuesday 19/12/20 19 Egypt Tuesday 23/09/20 Departur Arriva Compan e-time I-Time y- Number 7:30:00 1 a.m 7:30:00 1 a.m 7:30:00 1 a.m 4:30:00 2 p.m 4:30:00 2 p.m 11:30:00 1 a.m 11:30:00 1 a.m 19 ay Lando Wednesd 23/09/20 n 19 Lando Wednesd n ay Al- Company Company-Number 1 2 Company Name Al-Amel-Company Al-Rahma-company Airpane-type Airpane Airpane- Number 550 551 552 Boeing-787 Airbus A350 Boeing-max-737 Passenger- Number 800 500 300 Company- Number 1 1 2 er Passenger Passeng Passeng Passeng Gend Passpo Transpo Transpo Travel er- er-name er- er rt- rt-Price Number Neckna Numbe Ticket Numb me 3 Zahra Ali AL-SAYED Femal 154230 14120 4000 56 4 Zahra Femal 18530 14132 4000 55 Sameer 6 Yaseen AL-Amiri Male 18760 14142 4000 55 abdul- aleem 5 Hamza AL-SAYED Male 15440 14190 2500 55 7 Omar AL-SAYED Male 150648 24321 2500 56 11 Ghyth AL-SAYED Male 54123 23320 3000 56 8 Ziad AL-SAYED Male 76890 89709 3000 56 8

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

The Database Experts Guide To Database 2

Authors: Bruce L. Larson

1st Edition

0070232679, 978-0070232679

More Books

Students also viewed these Databases questions

Question

Question Who can establish a Keogh retirement plan?

Answered: 1 week ago