학생관리

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