과제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)