Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Development Of Knowledge Framework For Affective Content Analysis

Authors: Swarnangini Sinha

1st Edition

B0CQJ13WZ1, 979-8223977490

More Books

Students also viewed these Databases questions

Question

Describe three other types of visual aids.

Answered: 1 week ago