Question 1

ACTScooter is a newly established company that offers scooter rental services in Canberra. The employees at ACTScooter are classified into the three non-overlapping categories, administrators, distributors and technicians. An administrator helps a customer to register their unique credit card number and home address at ACTscooter. The work type of administrators can be either remote, onsite or hybrid. Each distributor helps to move scooters around and can be reached through a mobile phone number. Each technician has a qualification level, conducts periodic inspections for the scooters and records the date and feedback of every inspection for a scooter. Each ACTScooter employee can be uniquely identified by their employee number. ACTScooter also stores the brand, the manufacture year and an internal distinct ID for each scooter. Every ride is booked by exactly one customer. The database should allow customers to retrieve the detailed information about each of their rides, including a unique reference number, the scooter ID, the fare, the start time and end time, the origin and the destination. Once a ride is completed, the customer’s credit card will be automatically charged by ACTScooter.

Your task is to design an Enhanced Entity Relationship (EER) diagram for the above database, which should include entities, relationships, attributes and constraints wherever appropriate (you can make more assumptions if necessary).

You also need to identify the requirements that cannot be captured in an EER-diagram.