Design of transport management database

This post is also available in: Français (French)

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.

Context

statistics to produce for transport system

Funding

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.

uml analysis of a transport system

Activity Reporting

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.

dashboards for trasnport system

Contact management

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.

part of the relational model of a transport system

One Comment

Add a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.