Question: 2. Design a database that will hold information for a small travel agency to conduct its business. The agency exclusively offers trips. Each trip is

2. Design a database that will hold information for a small travel agency to conduct its business. The agency exclusively offers trips. Each trip is identified by a number. For each trip, the name, the price per person and duration of the trip (in days) are stored. A trip is offered every week on the same day. A trip on a certain date can be booked by a customer. Each customer gets a unique number, and the database should also store the customer's name, address, phone number and email. A customer can book different trips on different dates
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
