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.
No comments:
Post a Comment