연습

테이블 (8)

COURSE (Untitled)

  • Course ID (Key) — 기본 키 — NOT NULL
  • Name (Field)
  • Cost (Field2)
  • Duration (Field3)

ENROLMENT (Untitled2)

  • Student ID (Key) — 외래 키 → COURSE.Course ID — NOT NULL
  • Course ID (Key2) — 외래 키 → STUDENT.Student ID — NOT NULL

INSTRUMENT (Untitled6)

  • Staff ID (Key) — 기본 키 — NOT NULL
  • Staff ID (Key2) — 외래 키 → STAFF.Staff ID — NOT NULL
  • Name (Field)
  • Manufacturer (Field2)
  • Qunatity (Field3)

INVOICE (Untitled7)

  • Invoice Number (Key) — 기본 키 — NOT NULL
  • Student ID (Key2) — 외래 키 → STUDENT.Student ID — NOT NULL
  • Name (Field)
  • Student Information (Field2)
  • Total Amount Due (Field3)

REGISTRATION (Untitled8)

  • Invoice Number (Key) — 외래 키 → INVOICE.Invoice Number — NOT NULL
  • Student ID (Key2) — 외래 키 → INVOICE.Student ID — NOT NULL
  • Course ID (Key3) — 외래 키 → COURSE.Course ID — NOT NULL

SCHEDULE (Untitled4)

  • Course ID (Key) — 외래 키 → COURSE.Course ID — NOT NULL
  • Staff ID (Key22) — 외래 키 → STAFF.Staff ID — NOT NULL
  • Staff ID (Key222) — 외래 키 → STAFF.Staff ID — NOT NULL
  • Date (Field)
  • Time (Field2)
  • Day (Field3)
  • Class Room (Field4)

STAFF (Untitled5)

  • Staff ID (Key2) — 외래 키 → INSTRUMENT.Staff ID — NOT NULL
  • Staff ID (Key22) — 외래 키 → INSTRUMENT.Staff ID — NOT NULL
  • Name (Field)
  • Address (Field2)
  • Phone Number (Field3)
  • Date of Birth (Field4)
  • Degree (Field5)

STUDENT (Untitled3)

  • Student ID (Key) — 기본 키 — NOT NULL
  • Name (Field)
  • Address (Field2)
  • Date of Birth (Field3)
  • Phone Number (Field4)
  • Age (Field5)