It doesn't keep cascading, since cascades flow from parent to child. Since FacilityAddress is a "child" to BOTH Address and to Facility, it's not going to keep cascading,...
I don't understand one thing. You said 'Address' could be used for facility, department of user, so why did you have foreign key to facility table only?...
However, what happens if an address is used more than once? Two of the faculty live at the same address (husband & wife), then one leaves (divorce), you...