D111-Data Fundamentals. Week 5. Objectives. Recap Primary Keys Foreign Keys Data Dictionary Creating the Tables in MS Access Creating relationships in MS Access. Problem Statement.
Because we automatically invert the many side of a Many to Many inward, there will always be a One to Many relationship from the outsides in.
THIS WILL NOT NESSESSARILY BE THE CASE FROM INSIDE ENTITY OUT.
The relationship could be One to One or One to Many
We know the relationship from the CLIENT point of view is One to Many
Is the relationship optional or mandatory?
A single CLIENT can make many PURCHASES
Can means the relationship is OPTIONAL
In other words: EACH CLIENTDOES NOT NEED TO MAKEAPURCHASE
If I have the Client ID no.
In the Appointment table,
then I know the Client.
Then if I have the Salesman
ID no. in the Client table, then I
know the Salesman.
Would I then need to associate the
Salesman with the appointment?