Relational Database Design Book Recommendations

[GRT]

I'm looking to buy a book on relational database design because I just got a job and I need to brush up seeing as I took my databases class 3 years ago and haven't done much database stuff since then. If anyone knows of a good book please let me know. Thanks in advance.

 

[ZemAphorE]

GRT

take a look at Database managment systems, 3rd edition by Ramakrishnan and Gehrke
it goes into a fairbit of application and the books questions are ranging from easy to mediocre, they teach it at ubc a third year course.

Personally i liked it , since it was very easy to read . ill see if i can find and post my profs notes .. (if its allowed anyway) those ranged from mediocre to hard .

hope this helps

 

[GRT]

I'll take a look at that book and anything that you could post would be a great help.

I looked around and I also found this book on amazon that people seem to like.
http://www.amazon.com/exec/obidos/t...102-8443901-9460109?v=glance&s=books&n=507846

 

[tim_m]

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, Second Edition was suggested to me previously somewhere, quite possibly here, however, i haven't gotten the chance to buy it so i don't really know about it. just thought i'd through it out there

 

[cHoCo]

This book was excellent IMO:
http://www.amazon.com/exec/obidos/tg/detail/-/0321122267/qid=1099319497/sr=1-1/ref=sr_1_1/002-6351792-8305628?v=glance&s=books

 

[Mycroft999]

I always have this book near at hand. Its an excellent source of ideas on how to model data, quite readable and reasonably compact. Just be aware that you will not always need to be nearly as detailed in your implementations as the models in the book.

http://www.amazon.com/exec/obidos/ASIN/0932633293/qid=1099428789/sr=2-1/ref=pd_ka_b_2_1/002-0193137-8622462

 

[ZemAphorE]

sorry man i think
....


WOW.. i was just typing this and then it struck me to search in some other place for his notes , i found it !!!

ill PM u the address

anyone else needs it, please feel free to ask ill send it to u .. i just dont wanna post it in public .. it might pose a problem later .

 

[Cardboard Hammer]

This book was excellent IMO:
http://www.amazon.com/exec/obidos/tg/detail/-/0321122267/qid=1099319497/sr=1-1/ref=sr_1_1/002-6351792-8305628?v=glance&s=books

Had a couple of classes (one undergrad, one grad) that used earlier editions of that text. Good book, but is more than he really needs, as it covers more than just relational databases...

 

[Cardboard Hammer]

Do you which DBMS(s) you'd be working with? You might be best served to get book(s) focused on the system(s) you'd actually be working with... If you'll be using SQL Server, the product documentation, SQL Server Books Online, is very helpful. (Can actually be found online here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/getstart_4fht.asp )