Hi Guys,

I am going round in circles trying to sort this out.

I wish to move my design to the next step. I am using MYSQL for my database.

I am not sure if i am to include the fields that are duplicated in other tables (foreign keys) or do i add them at a later data?

Can anyone help put me in the right direction so i can complete the schema including relationships, foreign keys etc.

PLEASE SEE ATTATCHED MODEL
Check Out My Model



Many Thanks

Richard Howells
my email

Download DBDesigner and design your database using this tool. You can then use DBDesigner to generate the MySQL database automatically.

DBDesigner is free.