학생관리
테이블 (4)
Professor
- professor_number — int — 기본 키 — NOT NULL
- professor_name — varchar(20)
- professor_phone — varchar(25)
- major — varchar(50)
Score
- student_number — int — 외래 키 → Student.student_number — NOT NULL
- subject_number — varchar(20) — 외래 키 → Subject.subject_number — NOT NULL
- score — char(5)
- professor_number — int — 외래 키 → Professor.professor_number — NOT NULL
Student
- student_number — int — 기본 키 — NOT NULL
- major — varchar(50)
- student_name (name) — varchar(20)
- password — varchar(20)
- phone_number (phonenumber) — varchar(25)
Subject
- subject_number — varchar(20) — 기본 키 — NOT NULL
- credit — int
- subject_name — varchar(50)
- professor_number (professor_number2) — int — 외래 키 → Professor.professor_number — NOT NULL
- student_number — int — 외래 키 → Student.student_number — NOT NULL