Multiple relational tables theory

I’m a little unclear on theory here.

I have a number of tables but specifically…

clients
placements
facilities

A client may have only 1 placement
A placement may have only 1 client but there may be many placements per
client.
A placement may have only 1 facility
A facility may have only 1 placement but there may be many placements
per facility

I’m wondering if it is necessary to store a facility relation in the
client since the client will have one relation to the placement and the
placement will have a one relation to the facility.

I do anticipate needing frequent reports that list clients per facility
so that would be an advantage to store the facility in the client.
Should I be creating a relationship between client and facility when the
real relationship is between client and placement and the other real
relationship is between placement and facility?

Craig

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs