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:
Comments (Atom)
-
Surprising ways to improve your study routine Improving your study routine can be more straightforward than you think, especially when som...
