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