DBstudy
Tables (5)
Department
- dept_number — INT
- dept_name — VARCHAR(100) — NOT NULL
- manager_ssn — VARCHAR(20)
- manager_start_date — DATE
Dependent
- ssn — VARCHAR(20)
- dependent_name — VARCHAR(100)
- sex — VARCHAR(10)
- birth_date — DATE
- relationship — VARCHAR(50)
Employee
- ssn — VARCHAR(20)
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(200)
- salary — DECIMAL(10,2)
- sex — VARCHAR(10)
- birth_date — DATE
- dept_number — INT
- supervisor_ssn — VARCHAR(20)
Project
- project_number — INT
- project_name — VARCHAR(100) — NOT NULL
- project_location — VARCHAR(100)
- dept_number — INT
Works_On
- ssn — VARCHAR(20)
- project_number — INT
- hours_per_week — FLOAT