@mnl this exact process is simplified by applying data modeling heuristics for relational schema abstraction. db-eng grammatical blathering aside, specifically I'm referring to the 'third normal form'. Since I'm on a tablet and doing my best version of Palm Pilot short-hand swiping for word completions, instead of typing like I'd prefer, here's some links that describes what I'm referencing about...- Data schema normalization, 3NF: https://docs.oracle.com/cd/B10500_01/server.920/a96520/schemas.htm- Or for those who consider Oracle resources undesirable: https://www.ssp.sh/brain/third-normal-form/writing code on paper is hardcore, impressive, reminds me that I don't own a pen, though I do have a laser printer in a box somewhere.
