How draw ER diagram of tourism system?

Tourism System ER Diagram

```

+-----------+

| Tourist |

+-----------+

|

+--------------+----------------+

| Reservation | |

+--------------+ |

| | |

V V V

+--------------+ +-----------+ +-----------+

| Transport | | Hotel | | Attraction|

+--------------+ +-----------+ +-----------+

| | |

V V V

+-+ +-+ +-+-+

| | | | | | |

+-+--+--+ | | +--------------+ | |-----+

| | | | | | | Tourist | | | |

+-+--+--+ | | +--------------+ | |-----+

| | |

V V V

+-+ +-+ +-+-+

| | | | | | |

+-+--+--+ | | +--------------+ | |-----+

| | | | | | | Agency | | | |

+-+--+--+ | | +--------------+ | |-----+

| | |

V V V

+-+ +-+ +-+-+

| | | | | | |

+-+--+--+ | | +--------------+ | |-----+

| | | | | | | Attraction | | | |

+-+--+--+ | | +--------------+ | |-----+

Key:

* Tourist: This entity represents a person who is traveling for leisure. Attributes of this entity include name, age, gender, nationality, and contact information.

* Reservation: This entity represents a booking made by a tourist for transportation, accommodation, or an attraction. Attributes of this entity include reservation number, date, time, number of people, and total cost.

* Transport: This entity represents a means of transportation used by tourists, such as a car, bus, train, or plane. Attributes of this entity include vehicle type, capacity, and cost per mile.

* Hotel: This entity represents a place where tourists can stay overnight. Attributes of this entity include hotel name, location, star rating, number of rooms, and cost per night.

* Attraction: This entity represents a place or activity that tourists visit for leisure, such as a museum, historical site, or theme park. Attributes of this entity include attraction name, location, type of attraction, and cost of admission.

* Agency: This entity represents a company that provides travel services, such as booking transportation, accommodation, and attractions. Attributes of this entity include agency name, location, contact information, and types of services offered.

```

Copyright Wanderlust World © https://www.ynyoo.com