系统分析论
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