4/5 데이터베이스연구_2급 과제
테이블 (6)
Course (Untitled4)
- Course_ID (Key) — char(10) — 기본 키 — NOT NULL
- Course_Name (Field) — char(20)
Department (Untitled2)
- Dept_ID (Key) — char(10) — 기본 키 — NOT NULL
- Name (Field) — char(20)
- Office_Number (Field2) — char(10)
- student _ID (Key2) — char(10) — 외래 키 → Student.student _ID — NOT NULL
- Professor_ID (Key3) — char(10) — 외래 키 → Professor.Professor_ID — NOT NULL
- Course_ID (Key4) — char(10) — 외래 키 → Course.Course_ID — NOT NULL
Device (Untitled6)
- Device_ID (Key) — char(10) — 기본 키 — NOT NULL
- Name (Field) — char(20)
- Device_Type (Field2) — char(30)
- Field3
- internal_Code (Key2) — char(10) — 외래 키 → Wireless_user.internal_Code — NOT NULL
Professor (Untitled3)
- Professor_ID (Key) — char(10) — 기본 키 — NOT NULL
- Name (Field) — char(20)
- Office_Number (Field2) — char(10)
Student (Untitled)
- student _ID (Key) — char(10) — 기본 키 — NOT NULL
- Name (Field) — char(20)
- Adress (Field2) — char(30)
- Admission_Date (Field3) — char(20)
- Identification_code (Field4) — char(20)
- internal_Code (Key2) — char(10) — 외래 키 → Wireless_user.internal_Code — NOT NULL
Wireless_user (Untitled5)
- internal_Code (Key) — char(10) — 기본 키 — NOT NULL
- Student_ID (Field) — char(10)
- Name (Field2) — char(20)
- Password (Field3) — char(20)
- Field4