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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!