학사관리

테이블 (5)

Course relation (과목테이블)

  • Course ID (과목번호) — NOT NULL — 기본 키 — NOT NULL
  • Student number (학번) — NOT NULL — 외래 키 → Student relation.Student number — NOT NULL
  • Professor ID (교수번호) — NOT NULL — 외래 키 → Student relation.Professor ID — NOT NULL
  • Course ID (과목번호2) — NOT NULL — 외래 키 → Student relation.Course ID — NOT NULL
  • Student number (학번2) — NOT NULL — 외래 키 → Student relation.Student number — NOT NULL
  • Course name (과목명) — NOT NULL
  • Credit (학점) — NOT NULL

Department relation (학과테이블)

  • Department ID (학과번호) — NOT NULL — 기본 키 — NOT NULL
  • Student number (학번) — NOT NULL — 외래 키 → Student relation.Student number — NOT NULL
  • Professor ID (교수번호) — NOT NULL — 외래 키 → Student relation.Professor ID — NOT NULL
  • Course ID (과목번호) — NOT NULL — 외래 키 → Student relation.Course ID — NOT NULL
  • Student number (학번2) — NOT NULL — 외래 키 → Student relation.Student number — NOT NULL
  • Department name (학과명) — NOT NULL
  • Department phone number (학과전화번호) — NOT NULL — NOT NULL
  • Teaching assistant in charge (담당조교) — NULL — NOT NULL

Professor relation (교수테이블)

  • Professor ID (교수번호) — NOT NULL — 기본 키 — NOT NULL
  • Course ID (과목번호) — NOT NULL — 외래 키 → Course relation.Course ID — NOT NULL
  • Student number (학번2) — NOT NULL — 외래 키 → Course relation.Student number — NOT NULL
  • Professor ID (교수번호2) — NOT NULL — 외래 키 → Course relation.Professor ID — NOT NULL
  • Course ID (과목번호2) — NOT NULL — 외래 키 → Course relation.Course ID — NOT NULL
  • Student number (학번22) — NOT NULL — 외래 키 → Course relation.Student number — NOT NULL
  • Professor name (교수이름) — NOT NULL
  • Major (전공) — NOT NULL
  • Department name (학과명) — NOT NULL
  • Professor phone number (교수전화번호) — NOT NULL

Scholarship relation (장학금테이블)

  • Scholarship ID (장학금번호) — NOT NULL — 기본 키 — NOT NULL
  • Student number (학번) — NOT NULL — 외래 키 → Student relation.Student number — NOT NULL
  • Professor ID (교수번호) — NOT NULL — 외래 키 → Student relation.Professor ID — NOT NULL
  • Course ID (과목번호) — NOT NULL — 외래 키 → Student relation.Course ID — NOT NULL
  • Student number (학번2) — NOT NULL — 외래 키 → Student relation.Student number — NOT NULL
  • Scholarship Name (장학금이름) — NOT NULL
  • Scholarship amount (장학금) — NOT NULL

Student relation (학생테이블)

  • Student number (학번) — NOT NULL — 기본 키 — NOT NULL
  • Professor ID (교수번호) — NOT NULL — 외래 키 → Professor relation.Professor ID — NOT NULL
  • Course ID (과목번호) — NOT NULL — 외래 키 → Professor relation.Course ID — NOT NULL
  • Student number (학번2) — NOT NULL — 외래 키 → Professor relation.Student number — NOT NULL
  • Student Name (학생이름) — NOT NULL
  • College (소속대학) — NOT NULL
  • Department name (학과명) — NOT NULL
  • Academic adviser (지도교수) — NULL
  • Resident registration number (주민번호) — NOT NULL