3 of 3 people found the following review helpful
A must read for any DB professional,
This review is from: Applied Mathematics for Database Professionals (Expert's Voice) (Hardcover)
I think the title of this review says it all. I recently graduated from college with a B.S. in Computer Science. Part of the requirements of the program was an introductory Symbolic Logic course. While difficult, it ended up being quite a bit of fun. Then I stumbled across this book and decided to give it a read. WOW! If you took discrete mathematics and/or symbolic logic and perhaps even a database course in college and didn't understand why you needed to take those courses, this book couldn't connect the dots more clearly for you. I think this book should be required reading.
Having said all of that, fast forward 2 weeks after reading this book. I'm working on a project where I discovered a database design we were using was inconsistent. Using my symbolic logic background from college I formally proved the inconsistencies of the design; and using knowledge from this book, redesigned the database--which ended up being simpler, smaller, and met the requirements for the project.
I can't praise this book and its concepts enough. By the way, the project I was working on uses MS SQL Server while the book uses Oracle (generically, and barely at all, since you're not learing about a DBMS, but about how to properly design a database using sound mathematical principles); I did not find this to be a problem, so don't let the fact that the author uses Oracle in his examples make you shy away from this book. It is applicable to ANY RDBMS. The examples mostly use trivial CRUD statements and some CHECK constraints and TRIGGERs here and there to help enforce data integrity.