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".

Answered: need: entity relationship diagram

Engineering

Computer Engineering

need: entity relationship diagram

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

Related questions

Q: Describe the characteristics of an associative entity.

A: The topic under examination is the concept of an associative entity in the realm of database design…

Q: In the Entity-Relationship (ER) model, list the many types of attributes.

A: What is an ER Model? Theoretically and conceptually, software development uses entity-relationship…

Q: What kinds of data would you store in an entity subtype?

A: Entity Subtype Entity subtypes are entered into the ER model in order for decreasing the total…

Q: Office stestbiame deptCode lastName frstName tacid rank Department employs Credits Faculty sRated…

A: a)entity type that has more than 2 relationships are- class and department class- relationship with…

Q: design an Enhanced Entity Relationship (EER) diagram Topic: Locomotives The ERR diagram should…

A: entities of system : PaperBook, ElectronicBook, Users, borrowing_transactions Attributes of…

Q: Requirements Specification (this is a fictional scenario) A young soccer league wants to manage its…

A: The entity diagram is below:-

Q: Creating a new entity is an example of which level of abstraction: (a)Conceptual (b)Internal (c)…

A: In the context of databases and data modeling, an entity is a real-world object or concept that can…

Q: Explain what it is that the Entity-Relationship model does.

A: Entity Relationship model is a simple diagram which depicts the structure of tables and the…

Q: Why are weak and strong entity sets different?

A: Entity sets in database design refer to collections of related entities or objects. Weak entity sets…

Q: Explain the significance of cardinality in relationships between entities.

A: The concept of cardinality in Entity Relationship (ER) modeling refers to the aspect of…

Q: Explain the terms: Entity Attribute Types of relationship Cardinality Optionality. I NEED…

A: Entity: - Any existing real word object is an entity in the Database. Each entity has attributes,…

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".

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

PRESENTATION Explain Entity Relationship Diagram, symbols, Notations, different components and create an ERD of any given scenario.
Describe the entity-relationship model and how it works.
Define when an attribute from one entity type should be extracted and inserted into another.
The cardinality ratio depends on the real-world meaning of the entity types involved and is defined by the specific application. For the binary relationships below, suggest cardinality ratios based on common-sense meaning of the entity types. Clearly state any assumptions you make. Entity 1 Student Cardinality Ratio Entity 2 Course Item Class Teacher TextBook wwwwwwwwwww Order Instructor
ERD Diagram LucidChart Please be sure to accurately draw each entity, connecting lines, cardinality, actions (relationships), and attributes. Please be sure to properly label – if appropriate – your attributes. Please be sure to designate a primary key and foreign key(s) for each attribute. Please sure to properly label your associative entity – if appropriate. Please be sure to add to your diagram entities “user defined” primary key fields and appropriate foreign key fields Red Light Minor Emergency Clinic located in Wichita Falls, Texas is a 24-hour clinic that provides patients with minor emergency medical care. The clinic would like you to draw and ERD diagram that depicts their customer care process. The nurses working at the clinic can provide care to many patients, and the patient can be seen by many nurses. The clinic would only like to track the nurse’s name (first name and last name). The clinic would like to keep track of the following patient information to include…
Our assignment will be about a student attendance. Entities: student, course, instructor, attendance, enrollment, department, class. Relationships: Student is enrolled in course, Course has instructor, Department has many courses, Detail of the scenario Developing ERD Defining at least 7 Entity Defining attributes Defining all necessary relationships (Identify with matrix diagram) If possible superype-subtype, arc and hierarchical structures, non-transferable relationship. Preparing "table instance chart" to map ERD to DB structure Writing SQL DDL statements for implementing ERD (create table, constraints, defining keys: pks and fks) Making Physical Database using APEX Entering data to the Database Writing SQL DML Statements to reach information One statement including subquery One statement including join One statement including group by One statement including date function "One statement including character function One statement including update One statement including alter table
What is NOT another name for an associative entity? Linking table Bridge entity Composite entity Strong entity
Use an appropriate example to explain Entity Relationship Diagram.
Describe the purpose and operation of an entity-relationship model.
A relationship between entity supertype and entity subtype is known as ___