Company erd

Tables (7)

Department (DEPARTMENT)

  • dno — CHAR(8) — Primary key — NOT NULL
  • dname — CHAR(32)
  • mgstartdate — date
  • mngssn (Key) — CHAR(30) — Foreign key → Employee.ssn — NOT NULL

Department_Location (DEPARTMENT_LOACATION)

  • dno — CHAR(8) — Foreign key → Department.dno — NOT NULL
  • locationId (Key) — int(2) — Foreign key → Location.locationId — NOT NULL

Dependant (Untitled2)

  • dependant_ssn (Field) — CHAR(30)
  • dependantName (Field2) — CHAR(30)
  • sex (Field3) — CHAR(30)
  • bdate (Field4) — date
  • relationship (Field5) — CHAR(15)
  • Field6
  • ssn (Key) — CHAR(30) — Foreign key → Employee.ssn — NOT NULL

Employee (Untitled)

  • ssn (Key) — CHAR(30) — Primary key — NOT NULL
  • fname (Field) — CHAR(30)
  • minit (Field2) — CHAR(30)
  • Iname (Field3) — CHAR(30)
  • bdate (Field4) — date
  • address (Field5) — CHAR(30)
  • sex (Field6) — CHAR(30)
  • salay (Field7) — int(30)
  • superssn (Field8) — CHAR(30)
  • supervisorssn (Key3) — CHAR(30) — Foreign key → Employee.ssn — NOT NULL
  • dno — CHAR(8) — Foreign key → Department.dno — NOT NULL

Location (LOCATION)

  • locationId (Key) — int(2) — Primary key — NOT NULL
  • Field

Project (Untitled3)

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

WorkON (Untitled4)

  • pno (Key2) — CHAR(30) — Foreign key → Project.pno — NOT NULL
  • hour (Field) — int(3)
  • ssn (Key) — CHAR(30) — Foreign key → Employee.ssn — NOT NULL