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