[inClass]company(20200909)

Tables (7)

DAPARTMENT_LOCATION (Untitled6)

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

DEPARTMENT (Untitled)

  • dno (Key) — CHAR(8) — Primary key — NOT NULL
  • dName (Field) — CHAR(32)
  • mgrStartDate (Field2) — date
  • mgrssn (Key2) — CHAR(30) — Foreign key → EMPLOYEE.ssn — NOT NULL

DEPENDENT (Untitled7)

  • dSsn (Key) — CHAR(10) — Primary key — NOT NULL
  • dName (Field) — CHAR(30)
  • gender (Field2) — CHAR(10)
  • bDate (Field3) — date
  • relation (Field4) — CHAR(50)
  • ssn (Key2) — CHAR(30) — Foreign key → EMPLOYEE.ssn — NOT NULL

EMPLOYEE (Untitled2)

  • ssn (Key) — CHAR(30) — Primary key — NOT NULL
  • fName (Field) — CHAR(30
  • minIt (Field2) — CHAR(4)
  • lName (Field3) — CHAR(30)
  • bDate (Field4) — date
  • address (Field5) — CHAR(40)
  • gender (Field7) — CHAR(10)
  • salary (Field8) — int(20)
  • dno (Key2) — CHAR(8) — Foreign key → DEPARTMENT.dno — NOT NULL
  • superssn (Key3) — CHAR(30) — Foreign key → EMPLOYEE.ssn — NOT NULL

LOCATION (Untitled5)

  • lNo (Key) — CHAR(8) — Primary key — NOT NULL
  • lName (Field) — CHAR(30)
  • phone (Field2) — CHAR(20)

PROJECT (Untitled3)

  • pNo (Key) — CHAR(8) — Primary key — NOT NULL
  • pName (Field) — CHAR(30)
  • dno (Key2) — CHAR(8) — Foreign key → DEPARTMENT.dno — NOT NULL

WORKSON (Untitled4)

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