company

Tables (9)

CONTROLS (Untitled6)

  • DNAME (Key) — Foreign key → DEPARTMENT.DNAME — NOT NULL
  • DNUMBER (Key2) — Foreign key → DEPARTMENT.DNUMBER — NOT NULL
  • FNAME (Key3) — Foreign key → DEPARTMENT.FNAME — NOT NULL
  • LNAME (Key22) — Foreign key → DEPARTMENT.LNAME — NOT NULL
  • SSN (Key32) — Foreign key → DEPARTMENT.SSN — NOT NULL
  • BDATE (Key4) — Foreign key → DEPARTMENT.BDATE — NOT NULL
  • ADDRESS (Key5) — Foreign key → DEPARTMENT.ADDRESS — NOT NULL
  • SEX (Key6) — Foreign key → DEPARTMENT.SEX — NOT NULL
  • SALARY (Key7) — Foreign key → DEPARTMENT.SALARY — NOT NULL
  • FNAME (Key8) — Foreign key → DEPARTMENT.FNAME — NOT NULL
  • LNAME (Key23) — Foreign key → DEPARTMENT.LNAME — NOT NULL
  • SSN (Key33) — Foreign key → DEPARTMENT.SSN — NOT NULL
  • BDATE (Key42) — Foreign key → DEPARTMENT.BDATE — NOT NULL
  • ADDRESS (Key52) — Foreign key → DEPARTMENT.ADDRESS — NOT NULL
  • SEX (Key62) — Foreign key → DEPARTMENT.SEX — NOT NULL
  • SALARY (Key72) — Foreign key → DEPARTMENT.SALARY — NOT NULL

DEPARTMENT (2)

  • DNAME (Key) — Primary key — NOT NULL
  • DNUMBER (Key2) — Primary key — NOT NULL
  • FNAME (Key3) — Foreign key → WORKS_FOR.FNAME — NOT NULL
  • LNAME (Key22) — Foreign key → WORKS_FOR.LNAME — NOT NULL
  • SSN (Key32) — Foreign key → WORKS_FOR.SSN — NOT NULL
  • BDATE (Key4) — Foreign key → WORKS_FOR.BDATE — NOT NULL
  • ADDRESS (Key5) — Foreign key → WORKS_FOR.ADDRESS — NOT NULL
  • SEX (Key6) — Foreign key → WORKS_FOR.SEX — NOT NULL
  • SALARY (Key7) — Foreign key → WORKS_FOR.SALARY — NOT NULL
  • FNAME (Key8) — Foreign key → MANAGES.FNAME — NOT NULL
  • LNAME (Key23) — Foreign key → MANAGES.LNAME — NOT NULL
  • SSN (Key33) — Foreign key → MANAGES.SSN — NOT NULL
  • BDATE (Key42) — Foreign key → MANAGES.BDATE — NOT NULL
  • ADDRESS (Key52) — Foreign key → MANAGES.ADDRESS — NOT NULL
  • SEX (Key62) — Foreign key → MANAGES.SEX — NOT NULL
  • SALARY (Key72) — Foreign key → MANAGES.SALARY — NOT NULL

DEPENDENT (Untitled)

  • Name (Key) — Primary key — NOT NULL
  • Sex (Key2) — Primary key — NOT NULL
  • BirthDate (Key3) — Primary key — NOT NULL
  • Relationship (Key4) — Primary key — NOT NULL
  • FNAME (Key5) — Foreign key → DEPENDENTS_OF.FNAME — NOT NULL
  • LNAME (Key22) — Foreign key → DEPENDENTS_OF.LNAME — NOT NULL
  • SSN (Key32) — Foreign key → DEPENDENTS_OF.SSN — NOT NULL
  • BDATE (Key42) — Foreign key → DEPENDENTS_OF.BDATE — NOT NULL
  • ADDRESS (Key52) — Foreign key → DEPENDENTS_OF.ADDRESS — NOT NULL
  • SEX (Key6) — Foreign key → DEPENDENTS_OF.SEX — NOT NULL
  • SALARY (Key7) — Foreign key → DEPENDENTS_OF.SALARY — NOT NULL

DEPENDENTS_OF (Untitled5)

  • FNAME (Key) — Foreign key → EMPLOYEE.FNAME — NOT NULL
  • LNAME (Key2) — Foreign key → EMPLOYEE.LNAME — NOT NULL
  • SSN (Key3) — Foreign key → EMPLOYEE.SSN — NOT NULL
  • BDATE (Key4) — Foreign key → EMPLOYEE.BDATE — NOT NULL
  • ADDRESS (Key5) — Foreign key → EMPLOYEE.ADDRESS — NOT NULL
  • SEX (Key6) — Foreign key → EMPLOYEE.SEX — NOT NULL
  • SALARY (Key7) — Foreign key → EMPLOYEE.SALARY — NOT NULL

EMPLOYEE (1)

  • FNAME (Key) — Primary key — NOT NULL
  • LNAME (Key2) — Primary key — NOT NULL
  • SSN (Key3) — Primary key — NOT NULL
  • BDATE (Key4) — Primary key — NOT NULL
  • ADDRESS (Key5) — Primary key — NOT NULL
  • SEX (Key6) — Primary key — NOT NULL
  • SALARY (Key7) — Primary key — NOT NULL

MANAGES (Untitled3)

  • FNAME (Key) — Foreign key → EMPLOYEE.FNAME — NOT NULL
  • LNAME (Key2) — Foreign key → EMPLOYEE.LNAME — NOT NULL
  • SSN (Key3) — Foreign key → EMPLOYEE.SSN — NOT NULL
  • BDATE (Key4) — Foreign key → EMPLOYEE.BDATE — NOT NULL
  • ADDRESS (Key5) — Foreign key → EMPLOYEE.ADDRESS — NOT NULL
  • SEX (Key6) — Foreign key → EMPLOYEE.SEX — NOT NULL
  • SALARY (Key7) — Foreign key → EMPLOYEE.SALARY — NOT NULL

PROJECT (3)

  • PNAME (Key) — Primary key — NOT NULL
  • PNUMBER (Key2) — Primary key — NOT NULL
  • PLOCATION (Key3) — Primary key — NOT NULL
  • FNAME (Key4) — Foreign key → WORKS_ON.FNAME — NOT NULL
  • LNAME (Key22) — Foreign key → WORKS_ON.LNAME — NOT NULL
  • SSN (Key32) — Foreign key → WORKS_ON.SSN — NOT NULL
  • BDATE (Key42) — Foreign key → WORKS_ON.BDATE — NOT NULL
  • ADDRESS (Key5) — Foreign key → WORKS_ON.ADDRESS — NOT NULL
  • SEX (Key6) — Foreign key → WORKS_ON.SEX — NOT NULL
  • SALARY (Key7) — Foreign key → WORKS_ON.SALARY — NOT NULL
  • DNAME (Key8) — Foreign key → CONTROLS.DNAME — NOT NULL
  • DNUMBER (Key23) — Foreign key → CONTROLS.DNUMBER — NOT NULL
  • FNAME (Key33) — Foreign key → CONTROLS.FNAME — NOT NULL
  • LNAME (Key222) — Foreign key → CONTROLS.LNAME — NOT NULL
  • SSN (Key322) — Foreign key → CONTROLS.SSN — NOT NULL
  • BDATE (Key43) — Foreign key → CONTROLS.BDATE — NOT NULL
  • ADDRESS (Key52) — Foreign key → CONTROLS.ADDRESS — NOT NULL
  • SEX (Key62) — Foreign key → CONTROLS.SEX — NOT NULL
  • SALARY (Key72) — Foreign key → CONTROLS.SALARY — NOT NULL
  • FNAME (Key82) — Foreign key → CONTROLS.FNAME — NOT NULL
  • LNAME (Key232) — Foreign key → CONTROLS.LNAME — NOT NULL
  • SSN (Key332) — Foreign key → CONTROLS.SSN — NOT NULL
  • BDATE (Key422) — Foreign key → CONTROLS.BDATE — NOT NULL
  • ADDRESS (Key522) — Foreign key → CONTROLS.ADDRESS — NOT NULL
  • SEX (Key622) — Foreign key → CONTROLS.SEX — NOT NULL
  • SALARY (Key722) — Foreign key → CONTROLS.SALARY — NOT NULL

WORKS_FOR (Untitled2)

  • FNAME (Key) — Foreign key → EMPLOYEE.FNAME — NOT NULL
  • LNAME (Key2) — Foreign key → EMPLOYEE.LNAME — NOT NULL
  • SSN (Key3) — Foreign key → EMPLOYEE.SSN — NOT NULL
  • BDATE (Key4) — Foreign key → EMPLOYEE.BDATE — NOT NULL
  • ADDRESS (Key5) — Foreign key → EMPLOYEE.ADDRESS — NOT NULL
  • SEX (Key6) — Foreign key → EMPLOYEE.SEX — NOT NULL
  • SALARY (Key7) — Foreign key → EMPLOYEE.SALARY — NOT NULL

WORKS_ON (Untitled4)

  • FNAME (Key) — Foreign key → EMPLOYEE.FNAME — NOT NULL
  • LNAME (Key2) — Foreign key → EMPLOYEE.LNAME — NOT NULL
  • SSN (Key3) — Foreign key → EMPLOYEE.SSN — NOT NULL
  • BDATE (Key4) — Foreign key → EMPLOYEE.BDATE — NOT NULL
  • ADDRESS (Key5) — Foreign key → EMPLOYEE.ADDRESS — NOT NULL
  • SEX (Key6) — Foreign key → EMPLOYEE.SEX — NOT NULL
  • SALARY (Key7) — Foreign key → EMPLOYEE.SALARY — NOT NULL