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