A Fundamental Idea
Notice that the database design contains tables for “things” such as the Clients table and the table for the medical professional’s information
These tables represent information about entities
The Visits table is different in an important way …
It represents information about a relationship between entities, namely that the Client and the MedPro are connected or associated by a visit
- Pairing the keys of the related entities is the mechanism
The relational database model (that’s the set of concepts on which modern databases like Access are built) represents information about entities and relationships