SECTION B: ENTITY RELATIONSHIP DIAGRAM (9 marks)
Question 4: Consider the following and draw an ERD.
An application is providing a service to book seats of buses and private cars online.
Each user is given an option to view the status/details of available buses and cars, fares, their source/destination, and desired and actual departure/arrival times. They can also view the details of the drivers, their customer reviews rating, and comments.
On the other side, drivers can see the customers' details and their travel history.
To use this application, the users and drivers must create/use their password-protected accounts.