need: entity relationship diagram Customers book their tickets using the following form. A customer can book several tickets at once for aflight. The customer booking the tickets is typically the primary contact (i.e.: the first passenger). If the personbooking the flight is not a passenger, then the user clears the "primary contact" checkbox and enters alternateinformation. 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" booksanother flight in the future, then he is treated as a different entry (booking) in the system even thoughhe'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 thepassengers numbered as 1, 2, and 3. If there is another booking with the number G123-21X9-7 andtwo passengers, then its passengers are numbered as 1 and 2 for that booking.Depart: 07:10 Arrive: 12:56Edmonton (YEG) → Toronto (YYZ)Customer - Primary ContactFirst Name* Middle NameStreet Address *CountryCredit Card* Alternate PhoneAmount(***) ***-****Payment ProcessorPaid OnConfirmation NumberLast NameCityCA $887Credit CardF375-46C7-33 hrs 46 minThu, 15 Dec WJA 152 #Passengers 3(Code: WJA152-15DEC-0710)Email AddressPayPal BitcoinThe UI details of the payment processor are NOT modeled by our system.Instead, when payment has been confirmed we receive a uniqueconfirmation number which we store along with a timestamp of when theconfirmation was received and which payment provider was used.€3Ticket Confirmation Number.Ek***Phone Number *(***) ###-#***Region1f317bb6-f375-46c7-a110-d12f310a4f8fSep 25, 2022 - 9:52:06 AM-Includes taxes. Additional charges for baggage may be required when claiming your tickets.FlightUse this confirmation number when picking upyour tickets from the airport.West Jet Express Non-stopE- Passenger 1 (primary contact)Ⓒ AdultChilde SeniorFirst NameDate of birthMonth- Passenger 2O AdultFirst NameDate of birthMonthFirst Name*DayDate of birthMonthO ChildEPassenger 3O Adult O ChildDay*Middle NameEXYear |-O SeniorMiddle NameYearO SeniorEXMiddle NameDay ▼ YearFlF375-46C7-3Last NamePhone Number **(***) ***-****Last NameLast Name*At the time of payment, a ticket confirmation number will be issued from the airline and displayed on thescreen. This information is used when the boarding passes are picked up at the airport during check-in. ATicket 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 wasused, the confirmation number (always unique) from the payment processor, and a timestamp of whenthe payment was cleared. Valid payment methods are "Credit Card", "PayPal" and "Bitcoin".

Question

need:  entity relationship diagram Customers book their tickets using the following form. A customer can book several tickets at once for aflight. The customer booking the tickets is typically the primary contact (i.e.: the first passenger). If the personbooking the flight is not a passenger, then the user clears the &#34;primary contact&#34; checkbox and enters alternateinformation. 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 &#34;John Doe&#34; booksanother flight in the future, then he is treated as a different entry (booking) in the system even thoughhe'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 thepassengers numbered as 1, 2, and 3. If there is another booking with the number G123-21X9-7 andtwo passengers, then its passengers are numbered as 1 and 2 for that booking.Depart: 07:10 Arrive: 12:56Edmonton (YEG) → Toronto (YYZ)Customer - Primary ContactFirst Name* Middle NameStreet Address *CountryCredit Card* Alternate PhoneAmount(***) ***-****Payment ProcessorPaid OnConfirmation NumberLast NameCityCA $887Credit CardF375-46C7-33 hrs 46 minThu, 15 Dec WJA 152 #Passengers 3(Code: WJA152-15DEC-0710)Email AddressPayPal BitcoinThe UI details of the payment processor are NOT modeled by our system.Instead, when payment has been confirmed we receive a uniqueconfirmation number which we store along with a timestamp of when theconfirmation was received and which payment provider was used.€3Ticket Confirmation Number.Ek***Phone Number *(***) ###-#***Region1f317bb6-f375-46c7-a110-d12f310a4f8fSep 25, 2022 - 9:52:06 AM-Includes taxes. Additional charges for baggage may be required when claiming your tickets.FlightUse this confirmation number when picking upyour tickets from the airport.West Jet Express Non-stopE- Passenger 1 (primary contact)Ⓒ AdultChilde SeniorFirst NameDate of birthMonth- Passenger 2O AdultFirst NameDate of birthMonthFirst Name*DayDate of birthMonthO ChildEPassenger 3O Adult O ChildDay*Middle NameEXYear |-O SeniorMiddle NameYearO SeniorEXMiddle NameDay ▼ YearFlF375-46C7-3Last NamePhone Number **(***) ***-****Last NameLast Name*At the time of payment, a ticket confirmation number will be issued from the airline and displayed on thescreen. This information is used when the boarding passes are picked up at the airport during check-in. ATicket 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 wasused, the confirmation number (always unique) from the payment processor, and a timestamp of whenthe payment was cleared. Valid payment methods are &#34;Credit Card&#34;, &#34;PayPal&#34; and &#34;Bitcoin&#34;.

Accepted Answer

The answer is