In Need of a GOOD Database Design Book

[grip003]

Hey Everyone:

 

I am in need of a good database design book. I have some decent experience in creating databases and applications that use them, but I want to make sure I am not making some huge mistakes in my programs. I currently use MySQL and have recenlty been playing around with Firebird. In the past (years ago) I have used MS Access, but I'd rather not go back to that. I really just want to understand the best practices for designing and building solid relational databases. I have a master's degree in CS, so I can should be able to understand just about any book that is out there on the subject. I appreciate any and all suggestions.

[Joe Mamma]

firebird rocks!!!

 

 

heres the 10th edition of the college text I had in junior year -

 

http://www.nerdbooks.com/item.php?id=0131672673

 

I recommend it. The only design book I have needed.

 

When I bought the third edition, it came with a little DB modeling program called Salsa. Salsa is now TableDesigner. For 40 bucks it is a great tool.

[grip003]

Thanks Joe Mamma:

 

I will check that book out. I don't feel like dropping $130 for it though. I think I will try to get an earlier version. As a side note, can you store images in a firebird table like you can in MySQL?

 

Thanks

[Joe Mamma]

Thanks Joe Mamma:

 

I will check that book out. I don't feel like dropping $130 for it though. I think I will try to get an earlier version. As a side note, can you store images in a firebird table like you can in MySQL?

 

Thanks

Yes . . . I've not done it, but Firebird supports BLOB data. Treat em just like you would in MySQL i am sure.

[ALEX_0077]

Try e-bay, search for "Database Processing kroenke david 2005". its about $90 to $100 bucks w/ shipping total.