Connecting Database Tables by Relationships

Designing Databases for Historical Research: D3. Types of relationship

• Student and Home_Base tables
– The tables can have different security
access restrictions based on their data
• Other units can access Home_Base data
without having access to more sensitive data
in Student
– Separate tables but not independent
• Student_ID connects the two tables
(establishes a relationship between them)
– Primary key.