Database - Composite Primary Key

Here's a typical relationship diagram:

The Software-Engineer table is created to break the many-to-many relationship of the direct Engineer & Software table.

Notice it has a primary key consist of 2 attributes. This is called a Composite Primary Key.

The Engineer and the Software table are the main tables. The Software-Engineer is a secondary table with Foreign Key to the other 2 table.