Question
Please draw an Entity-Relationship diagram for the scenario described below. Each relationship must have cardinalities. If you think that the cardinality of a relationship hasn't
Please draw an Entity-Relationship diagram for the scenario described below. Each relationship must have cardinalities. If you think that the cardinality of a relationship hasn't been clearly specified, please make your own REASONABAL assumptions and NOTE them.If you want to use weak entities in your diagram, please use a rectangle with dotted line to present a weak entity. If you want to use interaction entities, please a rectangle with double edges to represent an interaction entity.You can use the drawing tool https://erdplus.com/, Microsoft word, or any other software (such as vision) to draw the schema.
Scenario: An online travel agency travelpedia.com is trying to draw a database for the holiday booking activities. Customers can book their holiday reservations by visiting the travelpedia.com website. When booking their reservations, a customer would provide information including the length of stay, inward and outward dates, the city and country they would like to visit, their preferred facilities and the type of resort, as well as the number of passengers. The customer must also indicate if they are only booking a flight or only accommodation or both. Once the holiday reservation is booked, the customer is invoiced. The database needs to track the invoice number, and invoices must be paid one month before the departure date. If the invoice is not successfully paid in time, the reservation will be cancelled, but the company will keep the reservation record in the database for one year. A person, who does not have to be the customer, must pay the invoice in full, either by credit card, debit card or PayPal account. For each payment, the system needs to record the invoice number and the name and address of the payer. If the payer pays using credit card or debit card, the system needs to record the card type, card number and expiration date and if the payer pays using PayPal, the systems needs to record the PayPal account number. The system also needs to have a flag field that indicates if a payment is successful or not.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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