entity relationship diagram for tours and travel
#1

describe to me entity relationship diagram for tours and travel?
Reply
#2

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).
Reply

Important Note..!

If you are not satisfied with above reply ,..Please

ASK HERE

So that we will collect data for you and will made reply to the request....OR try below "QUICK REPLY" box to add a reply to this page
Popular Searches: entity relationship diagram of training and placement, block diagram of travel and tourism, er diagram for tours and travel management system, tours and travel php coding download, pdf tours and travel management vb project, conclusion of tours and travel management system, srs document for tours and travel in php,

[-]
Quick Reply
Message
Type your reply to this message here.

Image Verification
Please enter the text contained within the image into the text box below it. This process is used to prevent automated spam bots.
Image Verification
(case insensitive)

Possibly Related Threads...
Thread Author Replies Views Last Post
Video frequency counter using ic 74c926 diagram working 1 4,275 02-01-2019, 09:35 PM
Last Post:
  block diagram of low cost automatic gate light with musical bell 1 7,271 06-10-2018, 05:46 AM
Last Post: Guest
  circuit diagram of smoke detector using at89s52 2 13,811 29-06-2018, 01:05 PM
Last Post: Guest
  circuit diagram dc motor speed and direction control over gsm mobile modem pdf 2 15,092 19-03-2018, 10:57 AM
Last Post: Guest
  travel agency vb6 0 project report with coding in pdf format 3 3,228 13-03-2018, 12:15 AM
Last Post: Guest
  ciruit diagram of alcohol detector 1 1,298 20-02-2018, 01:00 PM
Last Post: [email protected]
  ppt on design and implementation of intelligent campus security tracking system based on rfid and zigbee 7 16,063 09-02-2018, 02:20 PM
Last Post: udaya
Smile physics investigatory projects for class 12 cbse to set up a common base transistor circuit and to study its input and o 3 25,155 20-12-2017, 09:44 AM
Last Post: jaseela123d
  pure sine wave inverter circuit diagram free download 2 2,232 17-10-2017, 08:37 PM
Last Post: M Pasha
  autoclave plc circuit diagram picture 2 1,618 18-09-2017, 01:10 PM
Last Post: jaseela123d

Forum Jump: