과제1

테이블 (5)

Dept (CopyOfUntitled3)

  • dno (Key) — number — 기본 키 — NOT NULL
  • dname (Field) — varchar(30)
  • dtel (Field2) — varchar(30)
  • stno (Key2) — number — 외래 키 → Student.stno — NOT NULL
  • pno (Key3) — number — 외래 키 → Professor.pno — NOT NULL
  • lno (Key4) — number — 외래 키 → Lecture.lno — NOT NULL

Lecture (Untitled4)

  • lno (Key) — number — 기본 키 — NOT NULL
  • lname (Field) — varchar(30)
  • score (Field2) — varchar(30)
  • time (Field3) — varchar(30)
  • room (Field4) — varchar(30)

Professor (Untitled2)

  • pno (Key) — number — 기본 키 — NOT NULL
  • pdept (Field) — varchar(30)
  • pname (Field2) — varchar(30)
  • preno (Field3) — varchar(30)
  • padd (Field4) — varchar(30)
  • ptel (Field5) — varchar(30)
  • pmail (Field6) — varchar(30)
  • pphoto (Field7) — varchar(30)
  • pdno (Field8) — varchar(30)
  • stno (Key2) — varchar(30) — 외래 키 → Student.stno — NOT NULL
  • lno (Key3) — varchar(30) — 외래 키 → Lecture.lno — NOT NULL

Regist (Untitled5)

  • stno (Key) — number — 외래 키 → Student.stno — NOT NULL
  • lno (Key2) — number — 외래 키 → Lecture.lno — NOT NULL
  • pno (Key3) — number — 외래 키 → Professor.pno — NOT NULL
  • attend (Field) — varchar(30)
  • mscore (Field2) — varchar(30)
  • fscore (Field3) — varchar(30)
  • pscore (Field4) — varchar(30)
  • total (Field5) — varchar(30)
  • avg (Field6) — varchar(30)

Student (CopyOfUntitled)

  • stno (Key) — number — 기본 키 — NOT NULL
  • sname (Field) — varchar(30)
  • sreno (Field2) — varchar(30)
  • sadd (Field3) — varchar(30)
  • stel (Field4) — varchar(11)
  • smail (Field5) — varchar(30)
  • sphoto (Field6) — varchar(30)
  • sdept (Field7) — varchar(30)