Access Routes in Personnel System Example

Consider the Department, Section and Employee tables which are part of the Personnel System Application database.

For the Department table, access routes to both the Employee and Section tables are created. The access routes tell LANSA how the Department table will access the other tables:

For the Section table, a relationship back to Department and a relationship to Employee are needed.

For the Employee table, a relationship back to both the Department and Section tables are needed