I don't know if this is the right place for this question or not but I'm hoping someone can point me in the right direction. I have a project in mind that requires a database and I would like to begin ...

You are creating a database from scratch for an application This application will have multiple siloed environments (PROD, TST, INT, DEV) Data from PROD will nightly be moved to the other environments ...