DB0921

Tables (5)

DEPARTMENT (Untitled2)

  • deptNo (Key) — integer — Primary key — NOT NULL
  • name (Field2) — char(20)
  • manager (Field3) — char(20)
  • manageStartDate (Field) — date
  • location (Field5) — char(20)
  • ssn (Key2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL

DEPENDANT (Untitled3)

  • depenID (Key) — char(14) — Primary key — NOT NULL
  • name (Field) — char(20)
  • birthDate (Field2) — date
  • ssn (Field3) — char(14)
  • ssn (Key2) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL

EMPLOYEE

  • ssn (Key) — char(14) — Primary key — NOT NULL
  • name (Field) — char(20)
  • address (Field2) — char(50)
  • phone (Field3) — char(11)
  • depID (Field4) — char(14)
  • depenID (Key2) — char(14) — Foreign key → DEPENDANT.depenID — NOT NULL

PROJECT (Untitled)

  • projNo (Key) — integer — Primary key — NOT NULL
  • name (Field) — char(20)
  • contolDeptNo (Field2) — integer
  • controlDeptName (Field3) — char(20)
  • depenID (Key2) — char(14) — Foreign key → DEPENDANT.depenID — NOT NULL

WORKSON (Untitled4)

  • wonID (Key) — CHAR(20) — Primary key — NOT NULL
  • SSN (Field) — char(14)
  • projectID (Field2) — char(10)
  • hours (Field3) — float
  • projNo (Key2) — integer — Foreign key → PROJECT.projNo — NOT NULL
  • ssn (Key3) — char(14) — Foreign key → EMPLOYEE.ssn — NOT NULL