Untitled
unknown
plain_text
2 months ago
766 B
4
Indexable
erDiagram CUSTOMER { int customerID PK string customerName ... other customer attributes } EMPLOYEE { int employeeID PK string employeeName ... other employee attributes } PROJECT { int projectID PK int customerID FK ... other project attributes } EQUIPMENT { int equipmentID PK string equipmentName ... other equipment attributes } WORKS_ON { int employeeID FK int projectID FK date startDate date endDate } CUSTOMER ||--o{ PROJECT : hires for EMPLOYEE ||--o{ WORKS_ON : works on PROJECT ||--o{ WORKS_ON : has workers PROJECT ||--o{ EQUIPMENT : uses
Editor is loading...
Leave a Comment