Good Database Design Books?

OneC0de writes "I am the Director of IT for a small/medium sized marketing company, where I personally write the code that runs our applications. We use a variety of technology at our office, the majority of which rely on MS-SQL and MySQL databases. I am familiar with tables, SQL queries, and have a general understanding of how the SQL databases work. What I'm looking for is a good book, particularly a newer book, to explain general database design techniques, and maybe explain some relational tables. We have some tables that have million of rows, and I'd like to know the best method of designing these tables."

Comments

Re:Somewhere, a coder is polishing his resume

[Orestesx]

Good for you that you earned the title, but you are not a director. A director has multiple managers, who each has his own staff. You are a supervisor. And you work for a small business.