Browse the latest online walk through tutorial with lots of discussion and many screenshots: SynApp2 Tutorial – A Human Resources Application for Oracle® Database. Even though it's Oracle Database specific, most of the techniques and concepts translate directly to MySQL. There's good information for everyone.
SynApp2 Patterns - http://www.synapp2.org/main/?page_id=29