Annelie,

What is your primary Table? I assume it is Your Project correct? from what little you shared; all the others are Foreign Keys in this table.  The exception is teams that need a many-to-many relationship.

📼Relationships
📼Many-to-Many
📼Access Relationship Seminar

Hi Sami Shamma, thanks for your comment. My primary table is the project.  Do you mean that my primary table should contain the IDs from all other tables, if so that does make better sense to me. Does a junction table only include two items? And the reason is to enable it to help with many to many relationships? Do I understand that correctly?

The answers to your questions are in the free videos I recommended for you: in my first reply.

Hi Annelie, it all depends on how your business is set up.  Most cases in real life use many-to-many relationships.  For instance, a customer can buy multiple products, and each product can be bought by multiple customers.

Ask yourself:
A project can involve multiple branches.  True or false?
Each branch can be involved in multiple projects.  True or false?

A project can involve multiple programs.  True or false?
Each program can be involved in multiple projects.  True or false?

A project can involve multiple teams.  True or false?
Each team can be involved in multiple projects.  True or false?

If any pair above is true both ways, you need many-to-many relationship for it.

A more relatable real-life example:

A person can sign in to multiple Internet accounts.  True.
An Internet account can be signed in to by multiple people.  THIS IS FALSE, since each account can only link to one set of user ID/password.

In the case above, there cannot be a many-to-many relationship.  It can only be one-to-many.

Another example:

A person can have multiple social security numbers.  FALSE.
Each social security number can be used by multiple people.  FALSE.

In this case, there can only be a *one-to-one* relationship.

In short, it all depends on specific real-life applications, which you have to be clear about before setting up your database.

Thanks Both Sami and Kevin,
Sami, this is my first time asking a question and I did not realize that the blue text was your recommended videos. I have watched all of them but still my brain refuses to "click in", I guess I just need to continue watching them.
Thanks Kevin for your true or false questions. I am primarily trying to understand the difference of a primary table and a junction table and I will ponder your questions and try to put it to use in my situation. I feel my brain starting to get hot of all thinking. :) Thanks again!