problem $4$ Statement $(25$ points$)$ :

A bus company is responsible for offering public transportation in the suburbs

of a large metropolitan area. The company has significant data management

requirements: It needs to keep track of its $150$ vehicles, $400$ drivers, $60$ bus

routes, and hundreds of scheduled departures everyday. In addition, it is

essential for the company to know which drivers are certified to drive which

buses. The data that the company has available include the following

attributes:

The attributes are as follows:

RouteID, RouteStartPoint, RouteEndPoint,

RouteStandardDrivingTime, ScheduleDate,

ScheduledDepTime, ScheduledArrTime,

DriverID, DriverFName, DriverLName,

DateDriverJoinedCompany, DriverDOB, VehicleID,

VehicleMake, VehicleModel, VehiclePassangerCapacity,

DriverCertStartDate, DriverCertEndDate.

Based on this information:

a$.$ Identify the functional dependencies between the attributes.

b$.$ Identify the reasons why this relation is not in $3$NF$.$

c$.$ Present the attributes organized so that the resulting relations are in $3$NF$.$