Correct order

[cluelessPHP]

Silly question, should the EERM be made before or after normalisation?

[NogDog]

Not sure it's an either/or question -- there's nothing wrong with starting with a DB design in an ERM, creating a working first take DB based on it, then re-factoring the DB and the ERM whenever you make changes, whether for normalization or any other reasons. To paraphrase Kool and the Gang, "Iterate. Iterate. Dance to the music."

[cluelessPHP]

NogDog;11059381 wrote:

Not sure it's an either/or question -- there's nothing wrong with starting with a DB design in an ERM, creating a working first take DB based on it, then re-factoring the DB and the ERM whenever you make changes, whether for normalization or any other reasons. To paraphrase Kool and the Gang, "Iterate. Iterate. Dance to the music."

I wasn't sure, I was starting to do the ERM for the thing I started and noticed some mistakes, so I was thinking ERM should be first but I had done normalization first, theres a few things I want to fix. The overall quality I poor. Doing it now