과제1

테이블 (12)

Course (Untitled3)

  • Course Number (Key) — int — 기본 키 — NOT NULL
  • course name (Field)
  • description (Field2)
  • number of semester hours (Field3)
  • level (Field4)

Course_Section (Untitled9)

  • Course Number (Key) — int — 외래 키 → Course.Course Number — NOT NULL
  • Section Numver (Key2) — 외래 키 → Section.Section Numver — NOT NULL

Current Information (CopyOfUntitled7)

  • Student number (Key) — int — 외래 키 → Student.Student number — NOT NULL
  • city (Field)
  • state (Field2)
  • zip (Field3)
  • phone (Field4)

Department (Untitled2)

  • Department Code (Key) — int — 기본 키 — NOT NULL
  • name (Field)
  • office number (Field2)
  • office phone (Field3)
  • college (Field4)

Department_Course (Untitled8)

  • Department Code (Key) — int — 외래 키 → Department.Department Code — NOT NULL
  • Course Number (Key2) — int — 외래 키 → Course.Course Number — NOT NULL

Grade Report (Untitled5)

  • Student number (Key) — int — 외래 키 → Student_Grade.Student number — NOT NULL
  • Section Numver (Key2) — 외래 키 → Section_Grade.Section Numver — NOT NULL
  • letter grade (Field3)
  • numeric grade (Field4)

Permanent Information (Untitled7)

  • Student number (Key) — int — 외래 키 → Student.Student number — NOT NULL
  • city (Field)
  • state (Field2)
  • zip (Field3)
  • phone (Field4)

Section (Untitled4)

  • Section Numver (Key) — 기본 키 — NOT NULL
  • instructor (Field)
  • semester (Field2)
  • year (Field3)

Section_Grade (Untitled11)

  • Section Numver (Key) — 외래 키 → Section.Section Numver — NOT NULL

Student (Untitled)

  • Student number (Key) — int — 기본 키 — NOT NULL
  • name (Field) — varchar(30)
  • SSN (Field2)
  • sex (Field4) — varchar(1)
  • birthday (Field3)
  • class (Field5)
  • degree program (Field8)

Student_Department (Untitled6)

  • Student number (Key) — int — 외래 키 → Student.Student number — NOT NULL
  • Department Code (Key2) — int — 외래 키 → Department.Department Code — NOT NULL

Student_Grade (Untitled10)

  • Student number (Key) — int — 외래 키 → Student.Student number — NOT NULL