Many expert programmers who write complex SQL without a second thought still struggle with database design. Unfortunately, many introductory topics cause eyes to glaze over when we read “transitive dependencies” and “Boyce-Codd normal form”. When you’re done with this talk, you’ll understand the basics of creating a database that won’t make a DBA yell at you. We won’t even use (many) big words.
[youtube y1tcbhWLiUM]
Video producer: http://act.yapc.eu/
Slides of the presentation: http://www.slideshare.net/Ovid/how-to-fake-a-database-design