Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
Texan
Forum Newbie
Posts: 9 Joined: Mon Dec 20, 2004 9:23 pm
Post
by Texan » Thu Apr 28, 2005 10:43 pm
A quick question, I would like to do some finishing touches on my
database. I would like to set up all of my freign keys in my DB.
How do I set these up? I know I should know, but I don't. Are
there any benefits do setting them up?
Thanks
Chris Corbyn
Breakbeat Nuttzer
Posts: 13098 Joined: Wed Mar 24, 2004 7:57 am
Location: Melbourne, Australia
Post
by Chris Corbyn » Fri Apr 29, 2005 2:19 am
Dude.... if your database is finshed I can't see how you don't have these set up if you need them. It's the almost the first thing you should do.
I guess it's time to read up on database design and Normalization.
Google: "Database normalization"
Texan
Forum Newbie
Posts: 9 Joined: Mon Dec 20, 2004 9:23 pm
Post
by Texan » Fri Apr 29, 2005 4:29 am
The project isn't done, I am just doing some test scrips and such to make sure the db
is setup in the best possible way.