ALTER TABLE care_center
    ADD CONSTRAINT care_center_rn_fk
    FOREIGN KEY (eID)
    REFERENCES rn (eID);
ALTER TABLE rn
    ADD CONSTRAINT rn_nurse_fk
    FOREIGN KEY (eID)
    REFERENCES nurse (eID);
ALTER TABLE nurse
    ADD CONSTRAINT nurse_care_center_fk
    FOREIGN KEY (eID, cc_name, cc_loc)
    REFERENCES care_center (eID, cc_name, cc_loc);
ALTER TABLE room
    ADD CONSTRAINT room_care_center_fk
    FOREIGN KEY (eID, cc_name, cc_loc)
    REFERENCES care_center (eID, cc_name, cc_loc);
ALTER TABLE bed
    ADD CONSTRAINT bed_room_fk
    FOREIGN KEY (cc_name, cc_loc,room_no)
    REFERENCES room (cc_name, cc_loc, room_no);
ALTER TABLE bed
    ADD CONSTRAINT bed_resident_fk
    FOREIGN KEY (patID)
    REFERENCES resident (patID);