Relationships: How tables build connections
In the relational world, tables rarely live alone. To combine data from different places, we use relationships. They are built on a Primary Key (PK) → Foreign Key (FK) pair. In a university model, that means links between students, profiles, faculties, and courses. Choosing the right relationship type is a large part of successful schema design.