Entity Relationship Diagram

Below is our Entity Relationship Diagram which denotes how all the entities in the project are associated with each other.

We aimed to minimise duplication as much as possible, hence why there are so many entities. With the exception of the weak entities (which we need as such so the records would only be unique within the scope of the entity they belong too), all records of a particular entity can be reused without being redefined.

For example

A piece of data can be used as part of multiple points. In addition to that, a given point can be used in multiple tours.