The following analysis came from a project to build a transport management database for a transport association. The organisation transports people in financial difficulty, in return-to-work situations, with social problems, or mobility impaired workers on low wages.
The organisation receives public funds and contributions from employers, employs drivers and owns vehicles. The journeys of the people they transport in daily rounds are financed by public organisations.
The transport management database reports enable the association to compare journeys, people transported by financing organisation to justify funds against trips, and could calculate budgets for each financing organisation.
The transport management database manages contacts within each organisation, holding data on the persons who authorise users’ journeys. The module to manage users holds their financing status, and simple statistics on user profiles.
The following entity relationship model was used in the draft design of a Microsoft Access transport management database.