describe to me entity relationship diagram for tours and travel?
Posts: 14,118
Threads: 61
Joined: Oct 2014
Entity-relationship Diagram
The company has a representative office in the capital
cities in various countries around the world. Each travel agency only organizes local
the tour is not available not cross-country.Customers book on these tours (taking into account customer can order many rounds) and may pay for the tour in a series of installments. For each payment, a receipt is issued, containing the receipt number (5 digits Max-99999), payment date (date), the number of customers, the payment amount and number of rounds. For each tour, the company supports a unique world tour number (99999), city name (20 characters-C20), description (C50), the maximum number of participants (maximum 99), date (day), and return (date), the price of an adult tour (99999.99), the cost of child tour (99999.99) and details for each overnight stop on a tour that includes a stop date (date), the name of the hotel (C20), the hotel fax number (C15) and the city (C20) for each bed in the tour.
Each client is assigned a globally unique client number (99999).
In addition, the company maintains information on the surname (C20), name (C20), street
address (C20), city/(C20), ZIP Code/postal (C4) and phone number (C10-not all customers have phone number) to each customer. When a customer books a tour company also records the date of reservation, number of adults and number of children booked a tour for the total amount of debt of the client on this tour and the current outstanding balance on this tour. If the customer pays for the tour tallments, audio inputs this outstanding balance changes each time a payment is made. For each agency, agency code (C2), the name of the Agency, the Agency (C20) address (C40), phone number (C10), and manager name (C20) are recorded.
You should use the Crow foot model, and develop a comprehensive ERD, on the basis of the above scenario.
Complement the ERD with the necessary capacity and important attributes and
important keys (Primary & foreign key).