Untitled

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