mm

Tables (5)

DEPARTMEN LOCATION (Untitled4)

  • DEPNO (INT(2)) — Primary key — NOT NULL
  • LOCNO (CHAR(2)) — Primary key — NOT NULL

DEPARTMENT (Untitled2)

  • DEPNO. (Key) — INT(2)) — Primary key — NOT NULL
  • NAME (Key2) — CHAR(20) — Primary key — NOT NULL
  • LOCATION (Key3) — CHAR(30) — Primary key — NOT NULL
  • EMPNO. (Key4) — INT(6) — Foreign key → EMPOLYEE.EMPNO. — NOT NULL
  • NAME (Key22) — CHAR(15) — Foreign key → EMPOLYEE.NAME — NOT NULL
  • BIRTH (Key32) — DATE — Foreign key → EMPOLYEE.BIRTH — NOT NULL
  • GENDER (Key42) — CHAR(1) — Foreign key → EMPOLYEE.GENDER — NOT NULL
  • DEPNO. (Key6) — INT(2)) — Foreign key → EMPOLYEE.DEPNO. — NOT NULL
  • NAME (Key23) — CHAR(20) — Foreign key → EMPOLYEE.NAME — NOT NULL
  • LOCATION (Key33) — CHAR(30) — Foreign key → EMPOLYEE.LOCATION — NOT NULL
  • DEPNO (INT(2)) — Foreign key → DEPARTMEN LOCATION.DEPNO — NOT NULL
  • LOCNO (CHAR(2)) — Foreign key → DEPARTMEN LOCATION.LOCNO — NOT NULL
  • MANAGERNO (Field) — CHAR(6)
  • MANAGERSTARTDATE (Field2) — CHAR(13)

EMPOLYEE (Untitled)

  • EMPNO. (Key) — INT(6) — Primary key — NOT NULL
  • NAME (Key2) — CHAR(15) — Primary key — NOT NULL
  • BIRTH (Key3) — DATE — Primary key — NOT NULL
  • GENDER (Key4) — CHAR(1) — Primary key — NOT NULL
  • DEPNO. (Key6) — INT(2)) — Foreign key → DEPARTMENT.DEPNO. — NOT NULL
  • NAME (Key23) — CHAR(20) — Foreign key → DEPARTMENT.NAME — NOT NULL
  • LOCATION (Key33) — CHAR(30) — Foreign key → DEPARTMENT.LOCATION — NOT NULL
  • EMPNO. (Key43) — INT(6) — Foreign key → DEPARTMENT.EMPNO. — NOT NULL
  • NAME (Key222) — CHAR(15) — Foreign key → DEPARTMENT.NAME — NOT NULL
  • BIRTH (Key322) — DATE — Foreign key → DEPARTMENT.BIRTH — NOT NULL
  • GENDER (Key422) — CHAR(1) — Foreign key → DEPARTMENT.GENDER — NOT NULL
  • DEPNO. (Key63) — INT(2)) — Foreign key → DEPARTMENT.DEPNO. — NOT NULL
  • NAME (Key233) — CHAR(20) — Foreign key → DEPARTMENT.NAME — NOT NULL
  • LOCATION (Key333) — CHAR(30) — Foreign key → DEPARTMENT.LOCATION — NOT NULL
  • DEPNO (INT(2)) — Foreign key → DEPARTMENT.DEPNO — NOT NULL
  • LOCNO (CHAR(2)) — Foreign key → DEPARTMENT.LOCNO — NOT NULL
  • SUPERVISIOR (Field5) — INT(6)
  • ADDRESS (Field) — CHAR(50)
  • DEPNO (Field2) — INT(2)
  • PHONE (Field3) — CHAR(11)
  • EMAIL (Field4) — CHAR(30)
  • SUPERVISIOR (Key5) — INT(6) — Foreign key → EMPOLYEE.EMPNO. — NOT NULL
  • NAME (Key22) — CHAR(15) — Foreign key → EMPOLYEE.NAME — NOT NULL
  • BIRTH (Key32) — DATE — Foreign key → EMPOLYEE.BIRTH — NOT NULL
  • GENDER (Key42) — CHAR(1) — Foreign key → EMPOLYEE.GENDER — NOT NULL
  • DEPNO. (Key62) — INT(2)) — Foreign key → EMPOLYEE.DEPNO. — NOT NULL
  • NAME (Key232) — CHAR(20) — Foreign key → EMPOLYEE.NAME — NOT NULL
  • LOCATION (Key332) — CHAR(30) — Foreign key → EMPOLYEE.LOCATION — NOT NULL

LOCATION (Untitled3)

  • LOCNO (NAME) — CHAR(3) — Primary key — NOT NULL
  • NAME (Field) — CHAR(30)
  • DESCIPTION (Field2) — TXT

PROJECT (Untitled5)

  • PRONO (Key) — Primary key — NOT NULL
  • NAME (CHAR(50))
  • STARTDATE (DATE)
  • ENDDATE (Field3)
  • DEPNO (Field4)