20220104_DS_SQR

Tables (7)

DEPARTMENT_LOCATION (Untitled4)

  • departmentID (Key) — char(10) — Foreign key → Department.departmentID — NOT NULL
  • locationID (Key2) — char(10) — Foreign key → LOCATION.locationID — NOT NULL

DEPENDENT (Untitled5)

  • dependentName (Key) — char(20) — Primary key — NOT NULL
  • gender (Field) — char(1)
  • birhtDate (Field2) — date
  • relationship (Field3) — char(10)
  • parent (Field4) — char(10)
  • ssn (Field5) — char(14)
  • employeeID (Key2) — char(10) — Foreign key → EMPLOYEE.employeeID — NOT NULL

Department (Untitled)

  • departmentID (Key) — char(10) — Primary key — NOT NULL
  • departmentName (Field) — char(20)
  • manageStartDate (Field3) — date
  • departmentManager (Key2) — char(10) — Foreign key → EMPLOYEE.employeeID — NOT NULL

EMPLOYEE (Untitled3)

  • employeeID (Key) — char(10) — Primary key — NOT NULL
  • employeeName (Field) — char(30)
  • ssn (Field2) — char(14)
  • salary (Field3) — integer
  • gender (Field4) — char(1)
  • birthDate (Field5) — date
  • project (Field6) — char(10)
  • departmentID (Key2) — char(10) — Foreign key → Department.departmentID — NOT NULL

LOCATION (Untitled2)

  • locationID (Key) — char(10) — Primary key — NOT NULL
  • locationName (Field) — char(20)
  • phone (Field2) — char(20)
  • fax (Field3) — char(20)

PROJECT (Untitled6)

  • projNO (Key) — integer — Primary key — NOT NULL
  • name (Field) — char(20)
  • location (Field2) — char(20)
  • controllingDepartment (Field3) — char(20)
  • departmentID (Key2) — char(10) — Foreign key → Department.departmentID — NOT NULL

WORKSON (Untitled7)

  • ssn (Key) — char(14) — Primary key — NOT NULL
  • projNo (Field) — integer
  • hours (Field2) — char(20)
  • employeeID (Key2) — char(10) — Foreign key → EMPLOYEE.employeeID — NOT NULL
  • projNO (Key3) — integer — Foreign key → PROJECT.projNO — NOT NULL