I've been using MySql for the most of my career, and I did learn about relational algebra, normal forms and whatnot back in school, thank you. It's my experience that most programmers I have worked with knows about this stuff too.

That aside, MySql does have transactions and it does have foreign key constraints. Innodb has been around for a long time, you know.