A burning question I've had lately: Why aren't the tables in the default "mysql" database normalized? What is it about these tables that makes them better than normalization? Throughout my few years of programming, I've learned that striving for Second Normal Form (2NF) will create some of the best designed databases.
Every time I go to setup user access in mysql, I have to go to 3 different tables to make entries (db, host, user), and enter a lot of the information twice. Yes, i know there are better ways to do this, but I like the feel of having my hands dirty. It seems like Normalization could help out the mysql database immensely (not to mention it would be putting to practice the methodologies that are supported in the database community).
Posted by kposey at March 18, 2005 07:31 AM | TrackBack