diff --git a/STINK_postgrad.xml b/STINK_postgrad.xml index 8c12845..ea3062b 100644 --- a/STINK_postgrad.xml +++ b/STINK_postgrad.xml @@ -10,9 +10,9 @@
- Design-level ERD of the proposed database - - Design-level ERD of the proposed database + Design-level ERD of the proposed database (Barker notation) + + Design-level ERD of the proposed database (Barker notation)
@@ -491,7 +491,7 @@

We also need to add a relation between Staff and Component to resolve the many-to-many relationship:

-

StaffComponent(StaffID, ComponentCode, Type); StaffID FK to Staff, ComponentCode FK to Component

+

StaffComponent(StaffID, ComponentCode, Type); StaffID FK to Staff, ComponentCode FK to Component

CREATE TABLE Staff_Component