Dimensional modeling: Primary and foreign keys
Primary and foreign key relationships are used in relational databases to define manytoone relationships between tables. The primary key/foreign key relationships between tables in a star or snowflake schema, sometimes called manytoone relationships, represent the paths along which related tables are joined together in the database.