Task1_3

Tables (5)

Course (Untitled2)

  • 강좌 번호 (Course Number) — integer — Primary key
  • 분반 (Description) — Integer
  • 학기시수 (Number of Semester hours) — integer
  • 수준 (level) — Character
  • 제공부서 (offering department) — Character String
  • 강좌 이름 (Course Name) — Character String — NOT NULL
  • name — character string — Foreign key → Department.name
  • department code — character string — Foreign key → Department.department code — NOT NULL
  • social security number — integer — Foreign key → Student.social security number
  • student number — integer — Foreign key → Student.student number

Department (Untitled)

  • name — character string — Primary key
  • department code — character string — Primary key — NOT NULL
  • office number — character string
  • office phone — character string
  • college — character string

Grade report (Untitled3)

  • social security number — integer — Foreign key → Student.social security number
  • student number — integer — Foreign key → Student.student number
  • student — character string
  • section — character string
  • letter grade — character string
  • numeric grade — Character

Section (Untitled4)

  • section number — integer — Primary key
  • instructor — character string
  • semester — character string
  • year — integer
  • course — character string
  • social security number — integer — Foreign key → Student.social security number
  • student number — integer — Foreign key → Student.student number

Student (Untitled5)

  • social security number — integer — Primary key
  • student number — integer — Primary key
  • Student's name — character string
  • current address and phone — character string
  • permanent address and phone — character string
  • birthdate — integer
  • sex — character string
  • class — character string
  • major department — character string
  • minor department — character string
  • degree program — character string
  • city — character string
  • state — character string
  • zip of the student's permanent address (Field) — character string
  • student's last name — character string
  • name (name2) — character string — Foreign key → Department.name
  • department code — character string — Foreign key → Department.department code — NOT NULL