company
Tables (7)
DEPARTMENT (Untitled)
- dno (Key) — CHAR(8) — Primary key — NOT NULL
- dname (Field) — CHAR(32)
- mgrstartdate (Field3) — date
- mgrssn (Key2) — CHAR(30) — Foreign key → EMPLOYEE.ssn — NOT NULL
DEPARTMENT_LOCATION (Untitled2)
- dno (Key) — CHAR(8) — Foreign key → DEPARTMENT.dno — NOT NULL
- locationID (Key2) — int(2) — Foreign key → LOCATION.locationID — NOT NULL
DEPENDENT (Untitled5)
- dependent_ssn (Field5) — CHAR(30)
- dependentName (Field) — CHAR(30)
- sex (Field2) — CHAR(30)
- bdate (Field3) — date
- relationship (Field4) — CHAR(15)
- ssn (Key) — CHAR(30) — Foreign key → EMPLOYEE.ssn — NOT NULL
EMPLOYEE (Untitled4)
- ssn (Key) — CHAR(30) — Primary key — NOT NULL
- fname (Field) — CHAR(30)
- minit (Field2) — CHAR(30)
- lname (Field3) — CHAR(30)
- bdate (Field4) — date
- address (Field5) — CHAR(30)
- sex (Field6) — CHAR(30)
- salary (Field7) — int(30)
- superssn (Field8) — CHAR(30)
- dno (Key2) — CHAR(8) — Foreign key → DEPARTMENT.dno — NOT NULL
- supervisorssn (Key3) — CHAR(30) — Foreign key → EMPLOYEE.ssn — NOT NULL
LOCATION (Untitled3)
- locationID (Key) — int(2) — Primary key — NOT NULL
PROJECT (Untitled7)
- pno (Key) — CHAR(30) — Primary key — NOT NULL
- pname (Field) — CHAR(30)
- plocation (Field2) — CHAR(30)
- dno (Field3) — CHAR(30)
WORKS-ON (Untitled6)
- ssn (Key2) — CHAR(30) — Foreign key → EMPLOYEE.ssn — NOT NULL
- pno (Key3) — CHAR(30) — Foreign key → PROJECT.pno — NOT NULL
- hour (Field) — int(3)