Database design & normalization resources

[MarcusJT]

Here are some excellent articles on database design & normalisation - most are written with Access in mind, but 99% of the principles and techniques apply to every database under the sun, so they are well worth a read no matter which DB you use!

Understanding Relational Database Design

<snip/>

How the Table Analyzer Wizard Works

Database Normalization Basics

GeekGirls.com Database Tutorials


Some tip-style pages:

<snip/>

Database Design and Modeling Fundamentals


Does anyone else know of any quality articles/resources on these topics? Also, could one of the moderators could mark this thread "Important"? Cheers!


M@rco

EDIT: Added tips pages
EDIT: Removed the mailing list links, which are now sadly deceased.

EDIT:

SitePoint article:
Concepts of Database Design and Management

Wikipedia:
Database normalization

Mittineague

[cyngon]

The best resource I've found for learning these topics is Part 5 (entitled "Relational Database Design") of Kevin Yank's book Building a Database-Driven Web Site Using PHP and MySQL.

<snip/>

-Bryan

[r937]

there's a great normalization resource which covers data modelling and the relational model here --

http://www.utexas.edu/its/archive/wi...ng/rm/rm7.html

[jdulberg]

I just found some good articles about normalization posted on the DevShed forums:

<snip/>

[Flawless_koder]

I swear by Data Modelling Essentials ( which means it's never been opened - j/king )

But if someone knows the url for the e-book then that's a fairly good resource.

Flawless

[rycamor]

It is sometimes interesting to browse comp.databases.theory

And for those who want the heavy stuff: http://www.dbdebunk.com/. This site focuses heavily on the fundamentals of relational data theory. It has good information for those interested in the serious side of database design, and also for those possibly even interested in developing database management systems themselves (one of my future dreams ).

(WARNING: might cause you to rethink much of what you think you know about databases)

[sjokki]

OOP and datamodeling: http://www.agiledata.org/

[serge52]

See about database design www.configure-all.com
There is also about MySQL security

[GrahamT]

Lots of database design and normalization articles here:

http://www.databasedev.co.uk/general.html

[markstory]

Didn't see this in the thread, but I found it in another thread. Amazing list of data model samples for many different applications

http://www.databaseanswers.org/data_models/index.htm

[itcn]

I know this thread is a bit dated, but I do have a very pertinent article on this subject, and good database design never goes out of style:

http://www.barrywise.com/2008/01/dat...gn-techniques/

[WeatherSquareCom]

I'm a believer in normalizing to 3NF then turn around and denormilize for performance. Don't get to caught up in the "rules".

http://blog.makezine.com/archive/200...normalize.html
Sort of shares my belief.

[r937]

nice link, weathersquare

i should like to suggest that the correct strategy is as follows:

normalize to 3NF and then stop

don't denormalize right away -- that'd be silly

wait until you hit a few million rows

this strategy is completely supported by that article:

Only when you find there are performance problems do you need to think about optimizing. Usually this can be accomplished through smarter querying. When it cannot, you derive a denormalized data set from the normalized source.