Question $5$: Conceptual Design $(25$ marks$)$

$$ToursNow$$ is a new family$-$owned business offering transport options for coach $($Bus$)$ tours in the Perth metropolitan area and selected regional areas. ToursNow has experienced significant growth in recent months due to a growing customer base from all different types. As the business expands its operations and services, they have recognized the need for an efficient relational database to keep track of their fleet, sales, vehicle maintenance, and information about passengers and staffing. ToursNow prides itself as having an extensive tour selection option which are available for charter $24$ hours a day, seven days a week. More specific notes about ToursNow are listed below: