Any good guides on DB design?

Need a crash course...

[sugarkane]

Anyone know of any useful tutorials on designing databases - ie normalising, optimising for speed etc?

Something general - not necessarily relating to any particular database engine...

[Brett_Tabke]

SQL? or just in general?

I'd think you'd have to get into specific products to find the answers you were looking for Sugarkane. The real meat of any db is in the structure details - those can only be discussed if the os/db is known.

Here is one I've bookmarked. A book on IBM db2:
[pdc.kth.se...]

[sugarkane]

Thanks for the link - ploughing through that lot should keep me quiet for a bit :)

>SQL? or just in general?

Any relational db really...

I agree that the really meaty stuff tends to be product specific, but there are some overarching principles (one-to-many and many-to-many relationships for example) that apply equally well to most DBs. These principles are usually touched on in product documentation, but with prior knowledge assumed and/or only in relation to how that product implements them.

What I'm looking for is a 'Relational Database Design for Dummies' type of thing.

[Mike_Mackin]

[bookmag.com...]

[sugarkane]

Perfect!

But not free ;)

[Xoc]

There is a pretty good book by Michael J. Hernandez called Database Design for Mere Mortals. Not product specific and covers the stuff you need. Published by Addison Wesley Longman, Inc.

Caveat, Mike is a friend and business associate.