Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
need:  entity relationship diagram

need:  entity relationship diagram

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

need:  entity relationship diagram

Customers book their tickets using the following form. A customer can book several tickets at once for a flight. The customer booking the tickets is typically the primary contact (i.e.: the first passenger). If the person booking the flight is not a passenger, then the user clears the "primary contact" checkbox and enters alternate information. The first passenger must be an adult and have a contact phone number. Note: The system will not support identification of individuals. For example, if "John Doe" books another flight in the future, then he is treated as a different entry (booking) in the system even though he's used this booking system in the past. Passengers associated within a given booking must be identified by a sequential number. For example, in the following form, the confirmation number F375-46C7-3 with three passengers will have the passengers numbered as 1, 2, and 3. If there is another booking with the number G123-21X9-7 and two passengers, then its passengers are numbered as 1 and 2 for that booking. Depart: 07:10 Arrive: 12:56 Edmonton (YEG) → Toronto (YYZ) Customer - Primary Contact First Name * Middle Name Street Address * Country Credit Card * Alternate Phone Amount (***) ***-**** Payment Processor Paid On Confirmation Number Last Name City CA $887 Credit Card F375-46C7-3 3 hrs 46 min Thu, 15 Dec WJA 152 #Passengers 3 (Code: WJA152-15DEC-0710) Email Address PayPal Bitcoin The UI details of the payment processor are NOT modeled by our system. Instead, when payment has been confirmed we receive a unique confirmation number which we store along with a timestamp of when the confirmation was received and which payment provider was used. €3 Ticket Confirmation Number. Ek * ** Phone Number * (***) ###-#*** Region 1f317bb6-f375-46c7-a110-d12f310a4f8f Sep 25, 2022 - 9:52:06 AM -Includes taxes. Additional charges for baggage may be required when claiming your tickets. Flight Use this confirmation number when picking up your tickets from the airport. West Jet Express Non-stop E - Passenger 1 (primary contact) Ⓒ Adult Child e Senior First Name Date of birth Month - Passenger 2 O Adult First Name Date of birth Month First Name * Day Date of birth Month O Child E Passenger 3 O Adult O Child Day * Middle Name EX Year |- O Senior Middle Name Year O Senior EX Middle Name Day ▼ Year Fl F375-46C7-3 Last Name Phone Number ** (***) ***-**** Last Name Last Name * At the time of payment, a ticket confirmation number will be issued from the airline and displayed on the screen. This information is used when the boarding passes are picked up at the airport during check-in. A Ticket Confirmation Number identifies all the details of the booked flight. * * Note: The database will not store any payment information other than the payment method that was used, the confirmation number (always unique) from the payment processor, and a timestamp of when the payment was cleared. Valid payment methods are "Credit Card", "PayPal" and "Bitcoin".
Transcribed Image Text:Customers book their tickets using the following form. A customer can book several tickets at once for a flight. The customer booking the tickets is typically the primary contact (i.e.: the first passenger). If the person booking the flight is not a passenger, then the user clears the "primary contact" checkbox and enters alternate information. The first passenger must be an adult and have a contact phone number. Note: The system will not support identification of individuals. For example, if "John Doe" books another flight in the future, then he is treated as a different entry (booking) in the system even though he's used this booking system in the past. Passengers associated within a given booking must be identified by a sequential number. For example, in the following form, the confirmation number F375-46C7-3 with three passengers will have the passengers numbered as 1, 2, and 3. If there is another booking with the number G123-21X9-7 and two passengers, then its passengers are numbered as 1 and 2 for that booking. Depart: 07:10 Arrive: 12:56 Edmonton (YEG) → Toronto (YYZ) Customer - Primary Contact First Name * Middle Name Street Address * Country Credit Card * Alternate Phone Amount (***) ***-**** Payment Processor Paid On Confirmation Number Last Name City CA $887 Credit Card F375-46C7-3 3 hrs 46 min Thu, 15 Dec WJA 152 #Passengers 3 (Code: WJA152-15DEC-0710) Email Address PayPal Bitcoin The UI details of the payment processor are NOT modeled by our system. Instead, when payment has been confirmed we receive a unique confirmation number which we store along with a timestamp of when the confirmation was received and which payment provider was used. €3 Ticket Confirmation Number. Ek * ** Phone Number * (***) ###-#*** Region 1f317bb6-f375-46c7-a110-d12f310a4f8f Sep 25, 2022 - 9:52:06 AM -Includes taxes. Additional charges for baggage may be required when claiming your tickets. Flight Use this confirmation number when picking up your tickets from the airport. West Jet Express Non-stop E - Passenger 1 (primary contact) Ⓒ Adult Child e Senior First Name Date of birth Month - Passenger 2 O Adult First Name Date of birth Month First Name * Day Date of birth Month O Child E Passenger 3 O Adult O Child Day * Middle Name EX Year |- O Senior Middle Name Year O Senior EX Middle Name Day ▼ Year Fl F375-46C7-3 Last Name Phone Number ** (***) ***-**** Last Name Last Name * At the time of payment, a ticket confirmation number will be issued from the airline and displayed on the screen. This information is used when the boarding passes are picked up at the airport during check-in. A Ticket Confirmation Number identifies all the details of the booked flight. * * Note: The database will not store any payment information other than the payment method that was used, the confirmation number (always unique) from the payment processor, and a timestamp of when the payment was cleared. Valid payment methods are "Credit Card", "PayPal" and "Bitcoin".
Expert Solution
steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS