subject: Database design - CMIS

Then answer in the text and provide the following information.

1) What data would you capture in addition to what is provided?

2) Why do you consider these additions important to achieve better tracking of the company's operations and/or improve clarity?

3) If your data inclucdes new attribute explain which entity they would reside within and why? If your new data inclucdes new entities, explain how they would be related to the existing entities and what their primary key would be?

\begin{tabular}{|l|} \hline \multicolumn{1}{|c|}{ ROUTE } \\ \hline RouteID \\ RouteStartPoint \\ RouteEndPoint \\ RouteStandardDrivingTime \\ \hline \end{tabular} \begin{tabular}{|l|} \hline \multicolumn{1}{|c|}{ DRIVER } \\ \hline DriverID \\ DriverFName \\ DriverLName \\ DateDriverJoinedCompany \\ DriverDOB \\ \hline \end{tabular} \begin{tabular}{|l|} \hline \multicolumn{1}{|c|}{ VEHICLE } \\ \hline VehicleID \\ VehicleMake \\ VehicleModel \\ Vehicle PassengerCapacity \\ \hline \end{tabular}