데이터베이스과제HW#2
테이블 (8)
COURSE (Untitled4)
- CNumber (Key) — 기본 키 — NOT NULL
- CName (Field)
- Desc (Field2)
- Hours (Field3)
- Level (Field4)
- Dcode (Key2) — 외래 키 → DEPARTMENT.Dcode — NOT NULL
DEPARTMENT (Untitled2)
- Dcode (Key) — 기본 키 — NOT NULL
- DName (Field)
- Number (Field2)
- Phone (Field3)
- College (Field4)
INSTRUCTOR (Untitled6)
- Number (Key) — 기본 키 — NOT NULL
- Name (Field)
- Degree (Key2) — 외래 키 → INSTRUCTOR_Degree.Degree — NOT NULL
- Research (Key3) — 외래 키 → INSTRUCTOR_Research.Research — NOT NULL
INSTRUCTOR_Degree (Untitled7)
- Degree (Key) — 기본 키 — NOT NULL
INSTRUCTOR_Research (CopyOfUntitled7)
- Research (Key) — 기본 키 — NOT NULL
MINOR (Untitled3)
- SNumber (Key) — 외래 키 → STUDENT.SNumber — NOT NULL
- Dcode (Key2) — 외래 키 → DEPARTMENT.Dcode — NOT NULL
SECTION (Untitled5)
- CNumber (Key) — 외래 키 → COURSE.CNumber — NOT NULL
- Number (Key2) — 외래 키 → INSTRUCTOR.Number — NOT NULL
STUDENT (Untitled)
- SNumber (Key) — 기본 키 — NOT NULL
- Sex (Field)
- Class (Field2)
- City (Field3)
- Zip (Field5)
- State (Field4)
- FirstName (Field6)
- LastName (Field7)
- SSN (Field8)
- Major (Key2) — 외래 키 → DEPARTMENT.Dcode — NOT NULL