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
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
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
Step by step
Solved in 2 steps with 1 images
