niverse604

Hi please help to create ERD diagram not handrawn but using online tools please include legends
 

Question 5: Conceptual Design (25 marks) "Tours Now" is a new family-owned business offering transport options for coach (Bus) tours in the Perth metropolitan area and selected regional areas. Tours Now 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 Tours Now are listed below: Information about a route includes a unique code, its departing depot, its destination, and estimated departure and arrival times. To reduce costs, Tours Now only has non-stop charter tours with a single origin and destination. Tours are timetabled for a route on one or more dates with a Bus and staff assigned to each Tour, and the available seats (i.e., seats not taken) noted. In a staff deployment, the staff ID and the Role are recorded. It is a business requirement that the number of hours that Tour staff (i.e., Driver, Tour Guide, Tour Coordinator, etc...) are on a Tour must be noted. There is no such requirement for non-tour staff (e.g., maintenance crew, admin officers, operations staff, etc..). Buses have a registration number (rego), make, model, year, a capacity (number of passengers the bus can accommodate), and a scheduled- maintenance date.