Question

Draw an ER-diagram for the Figure 1 to book flight ticket. The ER-Diagram must
consists minimum FIVE (5) tables or entities. Include the attributes, primary keys
(underlines), foreign keys and the relationships in the diagram

My bookings Check-in Flight status Support EN MYR - BIG Login/Sign up #SantanGotYou Delivering across Klang Valley use code STAYHOME15 10 to 15% off. T&Cs apply. Flights Hotels SNAP Bags, Meals. Seats Activities OURSHOP Duty-free Travel Protection Deals From Kuala Lumpur (KUL) TO Depart date 09/04/2020 Retum date 12/04/2020 Search 1 Adult Multi-city Promo code Figure 1: Booking flight ticket

Answer 1

For the flight ticket booking I took 5 Entities and that are :

1. Passanger

2. Flight

3. Ticket

4. Administrator

5. Airport

1. Passanger has Attributes :

- user name

- password (primary key)

- first name

- last name

- mobile number

- email

- address

2. Flight has Attributes :

- flight number (primary key)

- deptarture time

- arrival time

- departure

- destination

3. Ticket has Attributes :

- id (primary key)

- date

- price

- airport name

- flight name

4. Administrator has Attributes :

- user name

- password (primary key)

5. Airport has Attributes :

- code (primary key)

- name

- city

- counrty

ume pass word Ja (date dept. Aright (email member time airport) name Ani time passanger (payment ticket Rooking flight fright (name departure N mobile) (addness) Price 198+ Iname Aligut Netrne Destination has Schedino name Airport (Country Code (CHY) Administrator uses name PiBbond

Relation between Entities :

- 1 Passanger paymet for 1 Ticket

- Many Ticket can be for 1 Flight

- Many Flight has a Airport

- Many Flight can be schedule by a Administrator