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)
Speed Test in Windows #shorts
Speed Test in Windows #shorts Check out our latest video tutorial! Thanks for watching! Do...
-
In the world of business and personal growth, we are constantly told to "take our shot." We are told to seize opportunities, launc...
