FIT 100
© Copyright University of
Washington 1999-2000
A Fundamental Idea
vNotice that the database
design contains tables for “things” such as
the Clients table and the table for the medical professional’s information
vThese tables represent
information about entities
vThe Visits table is different
in an important way …
vIt represents information
about a relationship between entities, namely
that the Client and the MedPro are connected or associated by a visit
oPairing
the keys of the related entities is the mechanism
vThe relational database model
(that’s the set of concepts on which modern
databases like Access are built) represents information about entities and relationships