LexisTaxi Association (LTA) is upgrading their technological infrastructure and would like you to design a database to help them keep track of their members and the customers they serve. They would like to first keep track of all the drivers, identified by their drivers licence. They would like to also record their date of birth, addresses, gender, all their mobile numbers, email, date_joined and their name, which includes their first, middle and last name. LTA has a drivers council on which their drivers are organized into clusters and one driver may represent a cluster of drivers on the council.

Each driver may own several vehicles registered to them, of which LTA would need to know the chassis and engine number, license place, colour, year, make and model of the vehicle. Each vehicle is registered to a route, where the system will generate a unique ID for the route. Each route has a point of origin, destination and cost associated with it. The driver can register a vehicle on a different route when the final registration has ended, LTA would like to know the status, start and end date of the registration.

LTA serve two types of customers: prepaid and walk-in. They would like to store the following details on prepaid customers only: name, mobile, gender and address where the mobile number is used to register the customer. Customers who are social media customers may leave comments on their social media platforms about LTA and as such, LTA would like to store specifically the social media handle of those clients. Each time a pre-paid customer takes a taxi on a registered route they would like to know the date and time. For analysis purposes they would like to pick a taxi registered for a route to see all the customers that were transported.

1. Draw the ERD for the scenario above

2. Create the relational notation.