Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 diagramStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started