TEST
Tables (8)
A PROJECT EMPLOYEE (Untitled7)
- Position (Field) — char(7)
- Participation rate (Field2) — integer(15)
- Salary (Field3) — integer(20)
- EMPLOYEE NUMBER (Key) — integer(9) — Foreign key → EMPLOYEE.EMPLOYEE NUMBER — NOT NULL
- projNo (Key2) — integer(5) — Foreign key → PROJECT.projectID — NOT NULL
- EMPLOYEE NUMBER (Key22) — integer(9) — Foreign key → PROJECT.EMPLOYEE NUMBER — NOT NULL
DEPARTMENT
- DepenID (Key) — char(15) — Primary key — NOT NULL
- Name (Field) — char(20)
- PhoneNo (Field2) — char(11)
- Budget (Field3) — integer(20)
- employee ssn (Field4) — char(9)
- EMPLOYEE NUMBER (Key2) — integer(9) — Foreign key → EMPLOYEE.EMPLOYEE NUMBER — NOT NULL
DEPENDENT (Untitled3)
- Dependency number (Key) — integer() — Primary key — NOT NULL
- Name (Field) — char()
- Gender (Field2) — integer(1)
- birthDate (Field3) — integer()
- Relationship (Field4) — char()
- EMPLOYEE NUMBER (Key2) — integer(9) — Foreign key → EMPLOYEE.EMPLOYEE NUMBER — NOT NULL
DEPT-LOCATION (Untitled5)
- DeptNo (Key) — char() — Foreign key → DEPARTMENT.DepenID — NOT NULL
- Place number (Key2) — integer() — Foreign key → LOCATION.Place number — NOT NULL
EMPLOYEE (Untitled)
- EMPLOYEE NUMBER (Key) — integer(9) — Primary key — NOT NULL
- Name (Field) — char(3)
- Birthdate (Field2) — integer()
- Salary (Field3) — integer()
- Gender (Field4) — integer(1)
- Address (Field5) — char()
- DeptNo (Key2) — char() — Foreign key → DEPARTMENT.DepenID — NOT NULL
LOCATION (Untitled6)
- Place number (Key) — integer() — Primary key — NOT NULL
- Place name (Field) — chac()
- Address (Field2) — chac()
PROJECT (Untitled4)
- projectID (Key) — integer() — Primary key — NOT NULL
- EMPLOYEE NUMBER (Key22) — integer(9) — Foreign key → WORKSON.EMPLOYEE NUMBER — NOT NULL
- name (Field) — char()
- controllingDepartment (Field2) — char()
- Period (Field3) — char()
- Amount (Field4) — integer()
- DeptNo (Key2) — char() — Foreign key → DEPARTMENT.DepenID — NOT NULL
WORKSON (Untitled8)
- EMPLOYEE NUMBER (Key2) — integer(9) — Foreign key → EMPLOYEE.EMPLOYEE NUMBER — NOT NULL
- projectID (Field2) — char(10)
- hours (Field3) — float
- Field