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.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
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?