연습
테이블 (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)