I've been reading a lot about database design at the moment, so I thought I'll make a thread and put all related questions in a single thread.
I've read a lot about normalizing (data?) in the database. Read about it in different sources, but can't figure out what they mean by that. Simply sanitizing? Or something else?
So I've already designed a database (as I went along... started reading on database design after creating this database) and was wondering if it looks sound from a more experienced database designer.
Different sources say different things about stored procedures. Some say they are a very good practice and should always be implemented, and if you don't use them then you don't know what you are doing and others are against it with a passion. What is an unbiased, fact-founded suggestion about it? Are foreign keys with on-delete or on-update go into the stored procedure category?
In phpMyAdmin under the 'More' tab when viewing a database (top-rightmost tab) there is an option for central columns. What are these columns exactly?