ER Diagram 2
Budget: €30 – €250 EUR
A local taxi company has a database of information on all of their drivers and cars stored in Excel. Unfortunately, this is very difficult to update and maintain. The table below lists all of the drivers in the company. Each driver has a unique ID. It also lists all of the cars that the drivers are allowed to drive during work. Each car has a unique Registration. Can you rearrange this data into a conceptual model to allow for an EMPLOYEE-DRIVESCAR relationship?
Your new conceptual model should make it easy for new drivers to be assigned to cars, drivers to be removed, cars to be deleted, new cars to be added etc.
You should rearrange the data in the Excel table below to fill tables involved in the EMPLOYEEDRIVES-CAR relationship. Examples were provided in Lectures 1 and 2
Your new conceptual model should make it easy for new drivers to be assigned to cars, drivers to be removed, cars to be deleted, new cars to be added etc.
You should rearrange the data in the Excel table below to fill tables involved in the EMPLOYEEDRIVES-CAR relationship. Examples were provided in Lectures 1 and 2