Entities Attributes,Relationships And ER Diagram

                Airline Booking System Entities and Attributes

Entities

An entity is an object that exists. An entity can be a single thing, person, place, or object. data can be stored about such entities.

1. Ticket Agency Entity

2. Flight Entity

3. Airline ticket

4. Passenger

Entity Attributes

An attribute defines the information about the entity that needs to be stored. An entity will have zero or more attributes, and each of those attributes applies only to that entity.

1 . Ticket Agency: Agent, phone_number, email_addrest, Ticket_type, Booking_number

2. Flight : total_seats, Arrival_date & time, Departure date & time , Flight_ticket, destination airport

3. Airline ticket: Ticket_id, description, seat number

4 . Passenger : Name , passport_number, email

Relationships

There are three types of relationships in this chosen scenario. They are one to one, one to many, many to many.

1. Ticket agency has tickets (one to many)

2. Ticket agency has flight (one to many)

3. Tickets have been booked by passengers (many to many)

ER Diagram