Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am designing a database and it has so many relationships among my tables and i need a book that teaches database design very well.I am looking for a book where table relationships simple and complex has been covered extensively and maybe case studies in the book.

share|improve this question
    
Converted to CW as this is a "list of X" question. That is all. –  jcolebrand Mar 11 '11 at 2:35
add comment

5 Answers 5

up vote 9 down vote accepted

Both of these guys authored several books, but I'm going to link to their blogs in case you want something more immediate.

Louis Davidson: http://drsql.org
Paul Nielsen: http://www.sqlserverbible.com/

share|improve this answer
add comment

SQL Antipatterns is worth a read for some hints on what you shouldn't do and why not (and under what circumstances those rules can be legitimately ignored).

share|improve this answer
add comment

Database in Depth: Relational Theory for Practitioners, by C.J. Date provides a great, short and highly informative introduction to database design.

share|improve this answer
add comment

Before you dive into the literature, you may find this paper useful:

All for One, One for All by C. J. Date

[This paper's] aim is to pin down the exact nature of oneto-one, many-to-one, one-to-many, and many-to-many relationships. In particular, it tries to come up with precise definitions for these concepts [because] a survey of the literature certainly betrays confusion and lack of systematic thinking in this area

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.