company

Tables (7)

DEPARTMENT (Untitled)

  • dno (Key) — CHAR(8) — Primary key — NOT NULL
  • dname (Field) — CHAR(32)
  • mgrstartdate (Field3) — date
  • mgrssn (Key2) — CHAR(30) — Foreign key → EMPLOYEE.ssn — NOT NULL

DEPARTMENT_LOCATION (Untitled2)

  • dno (Key) — CHAR(8) — Foreign key → DEPARTMENT.dno — NOT NULL
  • locationID (Key2) — int(2) — Foreign key → LOCATION.locationID — NOT NULL

DEPENDENT (Untitled5)

  • dependent_ssn (Field5) — CHAR(30)
  • dependentName (Field) — CHAR(30)
  • sex (Field2) — CHAR(30)
  • bdate (Field3) — date
  • relationship (Field4) — CHAR(15)
  • ssn (Key) — CHAR(30) — Foreign key → EMPLOYEE.ssn — NOT NULL

EMPLOYEE (Untitled4)

  • ssn (Key) — CHAR(30) — Primary key — NOT NULL
  • fname (Field) — CHAR(30)
  • minit (Field2) — CHAR(30)
  • lname (Field3) — CHAR(30)
  • bdate (Field4) — date
  • address (Field5) — CHAR(30)
  • sex (Field6) — CHAR(30)
  • salary (Field7) — int(30)
  • superssn (Field8) — CHAR(30)
  • dno (Key2) — CHAR(8) — Foreign key → DEPARTMENT.dno — NOT NULL
  • supervisorssn (Key3) — CHAR(30) — Foreign key → EMPLOYEE.ssn — NOT NULL

LOCATION (Untitled3)

  • locationID (Key) — int(2) — Primary key — NOT NULL

PROJECT (Untitled7)

  • pno (Key) — CHAR(30) — Primary key — NOT NULL
  • pname (Field) — CHAR(30)
  • plocation (Field2) — CHAR(30)
  • dno (Field3) — CHAR(30)

WORKS-ON (Untitled6)

  • ssn (Key2) — CHAR(30) — Foreign key → EMPLOYEE.ssn — NOT NULL
  • pno (Key3) — CHAR(30) — Foreign key → PROJECT.pno — NOT NULL
  • hour (Field) — int(3)