Resources on database design and data integrity enforcement best practices?
I'm curerntly going throught the following. I've read Louis Davidson's earlier books and fond them very useful so I'm looking forward to reading his latest one (for SQL Server 2012).


"Pro SQL Server 2005 Database Design and Optimization", Louis Davidson et al.
"Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design", Michael J. Hernandez.


More generally, authors you should look out for include Chris Date, Fabian Pascal, Joe Celko (for advanced and/or theoretical topics).

Also check out this other DBA question - some of the answers there may help.