Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I want an explanation of the Database schema diagram. And Sample database state. plz help me Travel Travel- From To Travel Time Departure - Arrival

I want an explanation of the Database schema diagram. And Sample database state. plz help me 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 Number Airpane-type Passenger Number Company Number Passenger Passe Passe Passe Gen Passp Trans Trans Trans nger- ngernger der ort port- port- port- Nu numb Neckn Num Ticket Price er ame ber Trav el Num ber Departur Arriva Compan e-time Time Number 7:30:00 1 7.30.00 1 Travel Travel Fro To Travel Time- Numbm day day er 55 A Berin Sunday 15/09/20 Riyad 19 56 AI Berlin Sunday 15:09:20 Riyad 19 57 AB Berlin Sunday 17/09/20 Riyad 19 AL Egypt Tuesday 19/1220 Riyad 19 RS Al Egypt Tuesday 230920 Riyad 19 86 AL Lando Wednesd 2300 20 Riyad y 19 AL Lande Wednesd Riyad pm 4:30:00 pm 2 an 11:30:00 1 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 Passenger Passeng Passeng Passeng Gend Passpo Transpo Transpo Travel er- er-name er- er rt. rt-Price Number Neckna Numbe Ticket Numb me r er 3 Zahra All 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 7 Omar AL-SAYED Male 150648 24321 2500 11 Ghyth AL-SAYED Male 54123 23320 3000 8 Ziad AL-SAYED Male 76890 89709 3000 8888

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

Databases And Information Systems 1 International Baltic Conference Dbandis 2020 Tallinn Estonia June 19 2020 Proceedings

Authors: Tarmo Robal ,Hele-Mai Haav ,Jaan Penjam ,Raimundas Matulevicius

1st Edition

303057671X, 978-3030576714

More Books

Students also viewed these Databases questions

Question

6. What questions would you suggest should be included?

Answered: 1 week ago