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