I had reverse engineered our data warehouse schema into a data model using data modeler.
I am trying to redefine the existing relationships and re-engineer our current environment, however, I am having difficulty in defining the relationships between entities.
Our database currently does not "enforce" the relationships using foreign keys for the sake of saving some overhead on the database maintenance, rather the data integrity logic is built into the ETL.
We are using SQL SERVER 2017 Developer Build 14.0.1000.169 (Standard in PROD).
EDIT: Forgot to mention that we are using Toad Data Modeler v188.8.131.52
Please see screenshot below: