project
Tables (5)
ASSIGNMENT
- emp_id — VARCHAR(10) — Foreign key → EMPLOYEE.emp_id — NOT NULL
- project_id (Key) — VARCHAR(10) — Foreign key → PROJECT.project_id — NOT NULL
- hours — INT
DEPARTMENT (CopyOfDEPARTMENT)
- dept_name (Key) — VARCHAR(50) — Primary key — NOT NULL
- dept_phone — VARCHAR(20)
EMPLOYEE
- emp_id — VARCHAR(10) — Primary key — NOT NULL
- emp_name — VARCHAR(50)
- dept_name (Key) — VARCHAR(50) — Foreign key → DEPARTMENT.dept_name — NOT NULL
MANAGER (CopyOfMANAGER)
- manager_name (Key) — VARCHAR(50) — Primary key — NOT NULL
- manager_phone — VARCHAR(20)
PROJECT
- project_id (Key) — VARCHAR(10) — Primary key — NOT NULL
- project_name — VARCHAR(100)
- manager_name (Key2) — VARCHAR(50) — Foreign key → MANAGER.manager_name — NOT NULL