task4
Tables (6)
DEPARTMENT
- Dnumber — INT — Primary key — NOT NULL
- Dname — VARCHAR(15) — NOT NULL
- Mgr_ssn — CHAR(9) — Foreign key → EMPLOYEE.Ssn — NOT NULL
- Mgr_start_date — DATE
DEPENDENT
- Dependent_name — VARCHAR(15) — Primary key — NOT NULL
- Essn — CHAR(9) — Foreign key → EMPLOYEE.Ssn — NOT NULL
- Sex — CHAR(1)
- Bdate — DATE
- Relationship — VARCHAR(8)
DEPT_LOCATIONS
- Dlocation — VARCHAR(15) — Primary key — NOT NULL
- Dnumber — INT — Foreign key → DEPARTMENT.Dnumber — NOT NULL
EMPLOYEE
- Ssn — CHAR(9) — Primary key — NOT NULL
- Fname — VARCHAR(15) — NOT NULL
- Minit — CHAR(1)
- Lname — VARCHAR(15) — NOT NULL
- Bdate — DATE
- Address — VARCHAR(50)
- Sex — CHAR(1)
- Salary — DECIMAL(10,2)
- Super_ssn — CHAR(9) — Foreign key → EMPLOYEE.Ssn
- Dno — INT — Foreign key → DEPARTMENT.Dnumber — NOT NULL
PROJECT
- Pnumber — INT — Primary key — NOT NULL
- Pname — VARCHAR(15) — NOT NULL
- Plocation — VARCHAR(15)
- Dnum — INT — Foreign key → DEPARTMENT.Dnumber — NOT NULL
WORKS_ON
- Essn — CHAR(9) — Foreign key → EMPLOYEE.Ssn — NOT NULL
- Pno — INT — Foreign key → PROJECT.Pnumber — NOT NULL
- Hours — DECIMAL(4,1)