I am building a website platform and I want to get some advice on using MySQL with Foreign Keys. I am looking for a consultant to advise me on database design and help me normalize the database and rebuild the tables to use foreign keys.
The table data is blank and the structure has already been built. I assigned some foreign keys but I don't even know if they are setup correctly. I can give you whatever information you need.
I want to learn how to create foreign keys in MySQL. I use XAMPP right now and I have used MySQL Administrator in windows to create foreign keys.
So basically I am looking for consultation on how to create foreign keys and manage my MySQL databases better. I know SQL well and my website is developed in PHP though I have also developed platforms in PERL.