Author: Lim Jet Wee Occupation: Online IGCSE & A Level Tutor Teaching Since: 2000 Subjects: Computer Science, ICT, Business Studies, Economics Contact: WhatsApp: +6017 761 9288 https://wa.me/60177619288 Free notes: https://jetweelim.site.google.com · Hub: https://linktr.ee/jetweelim
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)
Ms Edge Browser Workspace #shorts
Ms Edge Browser Workspace #shorts Check out our latest video tutorial!
-
In the world of business and personal growth, we are constantly told to "take our shot." We are told to seize opportunities, launc...
-
"You've spent months memorising business theories, but if you don't know how to "apply" them in the exam room, all th...
