database design

	Home Register Search Help Login

Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

database design

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Community >> Computer Software and Hardware issues >> database design

Page: [1]


student Posts: 1 Joined: 11/17/2004 Status: offline	database design - 11/17/2004 3:47:35 Hi, i am working in database design AND I HAVE SOME question regarding the normalization? Why are there so many foreign keys in the third normal form? could you please help me in that. Thank you,


bobby Posts: 11394 Joined: 8/15/1969 From: Seattle WA USA Status: offline	RE: database design - 11/17/2004 11:51:34 Normalizing is a pain in the butt... not fun at all, but once you figure it out it's not as daunting as it seems. It's been a while since I took a workshop on db design... but the reason for the foreign keys (if memory serves) is because you have a many to many relationship between two tables that needs a junction table to normalize. I would strongly suggest picking up a book or taking a class on database design, rationalization and normalization... it's not an easy subject to explain easily... I took a one day class (workshop) at a local CC. It was an 8 hour class and cost me about $100. It was the best thing I could have done. (It was actually part two of a five class workshop on web dev. using Frontpage) _____________________________ If con is the opposite of pro, is Congress the opposite of progress? (in reply to student)