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