Skip navigation links

MySQL Forums :: MySQL Workbench :: Create database with relationships using diagram


Advanced Search

Create database with relationships using diagram
Posted by: Andy Deans ()
Date: December 01, 2009 01:38PM

Hi,

I have had some great advice about setting up foreign key relationships using the diagram method in mysql workbench.

Could someone point me in the right direction in creating the relationships between my tables.

What I am trying to achieve is a backend system where a user would add clients and those clients would have various products sold to them

So what i was wondering is, would sayd key clientid be used throughout products table as a foreign key and does the sales person userid need to be used throughout also to reference this to them?

If anyone could help me out that would be great or point me to some documentation on what fields would normally make up a relational database.

many thanks

andy

Options: ReplyQuote


Subject Views Written By Posted
Create database with relationships using diagram 2442 Andy Deans 12/01/2009 01:38PM
Re: Create database with relationships using diagram 1542 Chad Bourque 12/01/2009 03:17PM
Re: Create database with relationships using diagram 1396 Andy Deans 12/01/2009 03:34PM
Re: Create database with relationships using diagram 1437 Andy Deans 12/08/2009 10:26AM
Re: Create database with relationships using diagram 1341 Andy Deans 01/20/2010 09:17AM
Re: Create database with relationships using diagram 1061 Andy Deans 01/21/2010 12:26PM
Re: Create database with relationships using diagram 1198 Mike Lischke 01/25/2010 02:43AM
Re: Create database with relationships using diagram 1259 Andy Deans 01/25/2010 07:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.