![database design - Composite primary key plus a separate (surrogate) id column for foreign key references - Database Administrators Stack Exchange database design - Composite primary key plus a separate (surrogate) id column for foreign key references - Database Administrators Stack Exchange](https://i.stack.imgur.com/2zyB0.png)
database design - Composite primary key plus a separate (surrogate) id column for foreign key references - Database Administrators Stack Exchange
![database design - Modeling Optional Foreign Key from Composite Primary Key field (Oracle Data Modeler) - Database Administrators Stack Exchange database design - Modeling Optional Foreign Key from Composite Primary Key field (Oracle Data Modeler) - Database Administrators Stack Exchange](https://i.stack.imgur.com/5BI7v.png)
database design - Modeling Optional Foreign Key from Composite Primary Key field (Oracle Data Modeler) - Database Administrators Stack Exchange
![SQL-Lecture-7 (Composite Primary Key and Composite Foreign Key with Practical Demonstrations) - YouTube SQL-Lecture-7 (Composite Primary Key and Composite Foreign Key with Practical Demonstrations) - YouTube](https://i.ytimg.com/vi/Lzfc7n4lPKk/maxresdefault.jpg)
SQL-Lecture-7 (Composite Primary Key and Composite Foreign Key with Practical Demonstrations) - YouTube
![Types of Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign) - GeeksforGeeks Types of Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign) - GeeksforGeeks](https://media.geeksforgeeks.org/wp-content/uploads/20230314173852/Foreign-keys.png)
Types of Keys in Relational Model (Candidate, Super, Primary, Alternate and Foreign) - GeeksforGeeks
![database design - Composite key as foreign key of multiple tables - Database Administrators Stack Exchange database design - Composite key as foreign key of multiple tables - Database Administrators Stack Exchange](https://i.stack.imgur.com/YL52a.jpg)
database design - Composite key as foreign key of multiple tables - Database Administrators Stack Exchange
![SQL-Lecture-7 (Composite Primary Key and Composite Foreign Key with Practical Demonstrations) - YouTube SQL-Lecture-7 (Composite Primary Key and Composite Foreign Key with Practical Demonstrations) - YouTube](https://i.ytimg.com/vi/Lzfc7n4lPKk/sddefault.jpg)
SQL-Lecture-7 (Composite Primary Key and Composite Foreign Key with Practical Demonstrations) - YouTube
![net - Inheritance and composite foreign keys - one part of the key in base class, the other part in derived class - Stack Overflow net - Inheritance and composite foreign keys - one part of the key in base class, the other part in derived class - Stack Overflow](https://i.stack.imgur.com/vFGvn.png)