E-R Diagram
Tables (5)
Department (1)
- Number (Key) — Number — Primary key — NOT NULL
- Name (Field) — Char
- Manager_Start_Date (Field2) — Date
Dependent (4)
- SSN (Key2) — Number — Foreign key → Employee.SSN — NOT NULL
- Number (Key3) — Number — Foreign key → Employee.Number — NOT NULL
- Name (Field) — Char
- Gender (Field2) — Char
- Birthdate (Field3) — Date
Employee (3)
- SSN (Key) — Numer — Primary key — NOT NULL
- Number (Key3) — Number — Foreign key → Department.Number — NOT NULL
- Address (Field) — Char
- Salary (Field2) — Number
- Birthdate (Field6) — Date
Project (2)
- Number (Key2) — Number — Foreign key → Department.Number — NOT NULL
- SSN (Key) — Numer — Foreign key → Employee.SSN — NOT NULL
- Name (Field)
Works_on (5)
- Number (Key2) — Number — Foreign key → Project.Number — NOT NULL
- SSN (Key) — Numer — Foreign key → Project.SSN — NOT NULL
- Hours_per_week (Field2)