?

Log in

No account? Create an account
entries friends calendar profile Previous Previous Next Next
Working on the SQL - shadows of echoes of memories of songs
j4
j4
Working on the SQL
Read 13 | Write
Comments
mobbsy From: mobbsy Date: August 18th, 2008 08:11 pm (UTC) (Link)
This is a common notation for schema diagrammes that I've used and seen used quite frequently.

Again, I can't really think of a single good text on database design. If you ask, somebody will usually crop up and say Date's Introduction to Database Systems - it's the classic reference in the field, however it's not a terribly good tutorial.

Understand normalisation, understand why a design being 3NF is worth aiming for, and only then think about breaking the rules.
mobbsy From: mobbsy Date: August 18th, 2008 08:17 pm (UTC) (Link)
http://www2.cs.uregina.ca/~bernatja/crowsfoot.html - better page for Crow's Foot notation than Wikipedia
caramel_betty From: caramel_betty Date: August 19th, 2008 09:45 am (UTC) (Link)
I second the caution about Date. He's very thorough, but sometimes too thorough. He's also incredibly dry to read.
Read 13 | Write