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)