Then he explains that one can overcome all the problems addressed by the lower normal forms simply by normalizing to 4NF.
The concept put forth by both Ulman & Widom and Kroenke that a database designer simply can use one normal form (BCNF or 4NF, respectively) to eliminate all lower level problems is attractive from a teaching perspective.
Stopping short of 4NF is not a wise business decision as many anomalies might still exist.
Update anomalies and the justification for 4NF in relational databases.
Key-based update anomalies and the justification for 4NF in database design, in Proc.
Insertion anomalies and the justification for 4NF in relational databases, in Aust.
Entries go to Peter Dodsworth, 62 Kendall Road, Higher Crumpsall, M anchester M8 4NF
ANYONE interested in a reunion of staff of National Bank of Scotland, 22 St Enoch Square, Glasgow, (1954-64), contact: Maria Lang (Shaw), Shennachie, Albany Street, Oban, PA34 4NF