The following diagram illustrates the relationship between the various entities.