devshed.com — Call me a nerd, but I’ll never forget the elation I felt several years back when I first succeeded in connecting a database to a Web page. At the time a newcomer to the world of database administration, I happily began creating all kinds of databases to store my valuable information. However, several problems soon arose...
Aug 30, 2006 View in Crawl 4
Closed AccountAug 30, 2006
You can also download books in PDF format from newsgroups.Full listing here: <a class="user" href="http://www.newzbin.com/browse/cat/p/books/education/">http://www.newzbin.com/browse/cat/p/books/education/</a>Better than dropping $40 on a book.
kimrulesAug 30, 2006
What a TERRIBLE site design: a tiny article broken into 5 tinier chunks spread over 5 pages, and each page is 90% non-useful (ads, bloated menu, more ads, even more ads, and is that another menu whoops no it's MORE ADS).Digg it? Heck, I'd dig it a hole.
spyrochaeteAug 30, 2006
Can you alphabetize your refridgerator?Yes, but will it save you time?
danielgaryAug 30, 2006
1. Thanks for the clarification. Asshat.2. No s**t sherlock.
jabbertrackAug 30, 2006
If you're looking for any sort of career in 'teknoligy' the 3 forms of database normalization is a frequently asked question in interviews because even the lowest geek on the totem pole in the office is frequently asked to create working databases for various tasks.I don't care if the article is old or the site is cluttered... that is one of the more succinct descriptions I've read and it would be a good idea to bookmark it.
mrepAug 30, 2006
Normalized scenario readsHouse=======1 || Old House || address 12 || New House || address 2Residents=======1 || Resident 1 || 1 (FK to House)2 || Resident 2 || 1 (FK to House)Just change resident 2's house FK to house 2. Resident 1 is unaffected.PS - there's lot's further you can take normalization, but for this scenario that's all that's required. Going up the layers in normalization just because it's there isn't always a good thing. I could separate out address from house and then separate it into city/state/zip even further. But the question is, how many joins do you want to have to do to get access to the data. Answer: As few as possible.
mrsticks1982Aug 30, 2006
what the... how stupid does this get! THE ARTICLE IS SIX YEARS OLD! <a class="user" href="http://www.devshed.com/cp/bio/W.J.-Gilmore/">http://www.devshed.com/cp/bio/W.J.-Gilmore/</a> - the submitters last article was in 2001.