Question: Develop a conceptual model based on the following business rules. You can make some additional assumptions of the rules that make common sense if necessary.

Develop a conceptual model based on the following business rules. You can make some additional assumptions of the rules that make common sense if necessary. Submit the screenshot of the conceptual model (using drawing tools or take a picture of your handwriting model).
ABC, a guided tour company, operates with the following guidelines:
ABC provides a variety of tours, each requiring information on tour name, approximate length (in hours), and associated fees. Guides are identified by an employee ID, and additional details such as their name, home address, and date of hire are recorded. Guides undergo a qualification test for specific tours, and it is crucial to track their qualifications, including the date of completion for each tour. A guide may be qualified for multiple tours, and conversely, a tour may have multiple qualified guides. New guides may or may not be initially qualified, just as new tours may or may not have qualified guides.
Each tour is designed to visit at least three locations. Details for each location, including name, type, and official description, are maintained. Some locations, like the White House, may be visited by multiple tours, while others, such as Arlington Cemetery, are exclusive to a single tour. The order of locations visited is also tracked.
The actual execution of a tour is referred to as an "outing." ABC schedules outings well in advance for advertising and employee scheduling purposes. A tour may have multiple scheduled outings, though newly designed tours may not have any outings scheduled. Each outing is specific to a tour and scheduled for a particular date and time. Every outing must be associated with a tour, and as all ABC tours are guided, each outing requires a designated guide. Although guides are typically qualified for specific tours, they may be asked to lead an outing even if not officially qualified. Newly hired guides may not have led any outings yet. Tourists, referred to as "clients" by ABC, pay to join scheduled outings. Client information, including name and telephone number, is recorded. Clients may sign up for multiple outings, and each outing may have multiple clients. Client information is retained only for those who have signed up for at least one outing, with newly scheduled outings potentially having no clients signed up at the time.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!