Database information DriverInfo

• driver_id, driver ID
• driver, driver number, this database is weird
• name, driver name
• holidays_taken, days holiday taken
• hours_this_year, hours worked this year
• hours_this_week hours worked this week
• driver_availability driver availability on certain date

---

• getDrivers() - returns IDs of all drivers in the DB
• findDriver(string number) - find the driver
• getName(int driver) - get the name of hte driver
• getHolidaysTaken(int driver) - get the number of days taken, or booked for holidays
• setHolidaysTaken(int driver) - as above
• getHoursThisYear(int driver) - set the number of hours worked this year
• setHoursThisYear(int driver, int value) - as above
• getHoursThisWeek(int driver) - obvious
• setHoursThisWeek(int driver, int value) - obvious
• String getNumber(int driver) - get the ID number of a driver, i think
• boolean isAvailable(int driver, Date date) - checks whether a driver is available on
• boolean isAvailable(int driver) - checks if available TODAY!
• setAvailable(int driver, Date date, boolean available) - set driver availability on a certain date
• setAvailable(int driver, boolean available) - sets availability for TODAY!