Good books on DB Design?
Please recommend some good books on database design. It can be a generic approach or can be specific to SQL Server or Oracle. Thanks! Bob
Depends what you want - if you want just sample db schemas there are a ton of books that give different types of ER diagrams.
There's an O'Reilly book on MS Access that is quite good. There is also an excellent book called "Designing Databases with MS Access" by Deborah Riordan, published by MS Press.
Joe Celko's SQL for Smarties: Advanced SQL Programming
The Practical SQL Handbook: Using SQL Variants (4th Edition) by Judith S. Bowman, Sandra L. Emerson, Marcy Darnovsky
As I recall SQL for Smarties has absolutely nothing to do with database design.
Billy Joel on Software
I have Data Modeling Essentials, 2nd edition, but I've only flipped through it. It's on-topic for you, anyway: nothing but modeling.
Been awhile since I bought and nearly read but I still like "The Data Model Resource Book" which has or had a CD you could buy for a ridiculous amount of money. The book itself is worth it as it works with real world models and goes into explanations on modelling based on usage. I believe it was this book that opened my eyes to the snapshot in time. A customer could be an employee could be a distributor etc. etc ... I always like think of things as "at this time, or during this time" as opposed to hard,fast rules true for all time. However, I never mention this in real life to anyone else I work with.
Fog Creek Home