系统分析论

Tables (4)

DEPARTMENT (Untitled)

  • derpartmentID (Key) — char(10) — Primary key — NOT NULL
  • deroartmentName (Field) — char(20)
  • derpartmentManager (Field2) — int(10)
  • manageStartDate (Field3) — date
  • SSN (Key2) — Char(10) — Foreign key → Employee.SSN — NOT NULL

Employee (Untitled2)

  • SSN (Key) — Char(10) — Primary key — NOT NULL
  • Name (Field) — Char(30)
  • Phone (Field2) — Char(13)
  • Address (Field3) — Char(50)
  • derpartmentID (Key2) — char(10) — Foreign key → DEPARTMENT.derpartmentID — NOT NULL

Project (Untitled3)

  • ProjectID (Key) — Char(10) — Primary key — NOT NULL
  • Name (Field) — Char(30)
  • Description (Field2) — Text

WORKS ON (Untitled4)

  • Ssn (Key) — Char(10) — Primary key — NOT NULL
  • ProjectID (Key2) — Char(10) — Primary key — NOT NULL
  • SSN (Key3) — Char(10) — Foreign key → Employee.SSN — NOT NULL
  • ProjectID (Key4) — Char(10) — Foreign key → Project.ProjectID — NOT NULL
  • Hours (Field) — Float