일원관계(1)
테이블 (3)
COURSE (Untitled)
- CourseNo (Key) — char(10) — 기본 키 — NOT NULL
- Title (Field) — text
- CreditHours (Field2)
- CourseNo (Key2) — char(10) — 외래 키 → COURSE.CourseNo — NOT NULL
DEPARTMENT (Untitled3)
- deptNo (Key) — char(3) — 기본 키 — NOT NULL
- Name (Field) — char(10)
- managerNo (Field2) — char(2)
- budget (Field3) — char(5)
- employeeNo (Key2) — char(3) — 외래 키 → EMPLOYEE.employeeNo — NOT NULL
EMPLOYEE (Untitled2)
- employeeNo (Key) — char(3) — 기본 키 — NOT NULL
- firstName (Field) — char(10)
- lastName (Field2) — char(10)
- phon (Field3) — char(10)
- deptNo (Field4) — char(3)