학사관리
테이블 (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