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.
Subscribe to:
Posts (Atom)
Learn how Stellar Repair for MS SQL can help recover data from corrupted MDF files
Learn how Stellar Repair for MS SQL can help recover data from corrupted MDF files Check out our latest video tuto...
-
In the world of business and personal growth, we are constantly told to "take our shot." We are told to seize opportunities, launc...
