Exercise 2-배미연
테이블 (4)
Class (Untitled2)
- ClassCode (Field) — char(7) — 기본 키
- ClassName (Field4) — char(4)
- ClassTime (Field2) — time
- ClassLevel (Field3) — char(2)
- CourseName (Key) — char(4) — 외래 키 → Course.CourseName — NOT NULL
- MemberName (Key2) — char(10) — 외래 키 → Member.MemberName — NOT NULL
ClassEnroll (Untitled4)
- ClassLevel (Field4) — char(2) — 기본 키
- ClassEnrollmember (Field2) — int
- ClassNewmember (Field3) — int
- ClassCode (Field) — char(7) — 외래 키 → Class.ClassCode
Course (Untitled)
- CourseName (Key) — char(4) — 기본 키 — NOT NULL
- CourseNo (Field) — char(3)
- CourseManual (Field2) — char(100)
Member (Untitled3)
- MemberName (Key) — char(10) — 기본 키 — NOT NULL
- MemberAddress (Field) — char(30)
- MemberAge (Field2) — int
- ClassLevel (Field4) — char(2) — 외래 키 → ClassEnroll.ClassLevel