You are tasked with designing a new system for the Peel Police Department. The new system provides an inventory of police vehicles that police can use for official purposes. This system must provide the following information:

$1.$ Which police drove the vehicle and how many kilometers did he$/$she drive?

$2.$ A history of how many police personnel drove a specific vehicle.

$3.$ How many vehicles are available for the day. From this information, police staff can book a car for the day.

$4.$ When is a vehicle due for service and the cost of service.

$5.$ When is a vehicle due for replacement $($this means, selling the vehicle because it reached a specific mileage$).$

$6.$ If police personnel is holding on to the vehicle for more than $24$ hours, he$/$she must get approval from their manager. The system must have a provision for getting approvals from managers.

For this, we need a view for admin users and a view for Police Personnel to book the vehicle for the day.