| For code modeling, I model the structure, not the individual scripts. So, I'll have an index.php driver, an images folder, an includes folder with a template, a driver class, etc... I usually use a tree to model that all out.
As for 3NF, be sure to check for scenarios when 3NF isn't very helpful for live DBs (e.g. when a join is unnecessarily expensive and duplicating a key speeds things up.)
I never learned beyond 3NF. All I heard about beyond that is that it was mainly an academic exercise. 2NF or less, however, is bad for many reasons, so I usually hit between 2NF and 3NF, breaking rules only for speed issues. |