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