Help review my tables/relationships?

[justgeig]

I am trying to build a database that is way outside of my skill level and so I'm stumbling and reading and learning all at once. Just wondering if I could trouble someone to take a look at the first set of tables I have set up and let me know if they see any problems with my design.



Quick overview of the company I work for (Aurora): We are a magazine publisher at the core and have two magazines that we publish. That means most of our customers can be referred to as "Advertisers" (if only it were that simple...) We also have other services we provide that have nothing to do with either magazine or even advertising in general. With that in mind, my current goal is to set up a database to record every contact we have and link those Contacts with a list of Clients. Not all contacts are clients that we do business with (ex: a person that we contact for news items to go into our magazines.) Each Client may have multiple Contacts and vice versa. It's also possible that the contact IS the client. That is possible when the Contact does not own or is not affiliated with a business but wants to advertise in our magazines. With all that mess sort of cleared up, I went ahead and made a many-to-many relationship with a Clients table, a Contacts table, and a junction table to connect them. Attached is a PDF showing all the fields and the relationship set up.

ANY insight is appreciated. I'll have more questions if responders think that I am on the right track.

[David04845]

You need to link the Client ID to Contact ID (unless they are the same numbers)
if they are the same numbers then your relationship will work
Client id of 1234 = Contact ID 1234

however if the numbers are different that relationship will not work. you need to find something the records have in common

[justgeig]

like this?

EDIT: Yes, the ID numbers will be different