Question: solve fast plzzzz Construct an E-R model for an online Flight ticket booking system. i) Entity TICKET_BOOKING with attributes booking_id, booking_date, booking_desc. ii) Entity USER

solve fast plzzzz
Construct an E-R model for an online Flight ticket booking system. i) Entity TICKET_BOOKING with attributes booking_id, booking_date, booking_desc. ii) Entity USER with attributes name, user_id, user_mail, user_DOB, user_phone(multiple attribute). iii) Entity LOGIN with attributes login_id, login_username and login userpassword, and airline enquiry as a weak entity set on user. iv) Entity PASSENGER with attributes passenger_id, contact detail, name, vaccination certificate and age. v) PAYMENT method as a week entity set to TICKET_BOOKING with attributes net banking, credit card, UPI, Payment_Id, Debit card. vi) Draw relationships between entities based on the association among them. Mark the Primary key, Foreign keys, Candidate keys and tabulate the same below your ER diagram
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
