2024_1_example00

Tables (3)

DEPARTMENT

  • depID — char(4) — Primary key — NOT NULL
  • depNAME (depName) — char(20)
  • menageStarDate (manageStarDate) — date
  • empID — char(10) — Foreign key → EMPLOYEE.empID — NOT NULL

EMPLOYEE

  • empID — char(10) — Primary key — NOT NULL
  • name — char(20)
  • birthday (birthDate) — date
  • gender — char(1)
  • phone — char(11)
  • depID — char(4) — Foreign key → DEPARTMENT.depID — NOT NULL

Untitled (PROJECT)

  • Key (proID) — int(10) — Primary key — NOT NULL
  • Field (proName) — char(30)
  • Field (department) — char(5)
  • Field (manage)