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