Create database with relationships using diagram

[Andy Deans]

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