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