University

Tables (7)

Course (Untitled2)

  • course_id (Key) — Primary key — NOT NULL
  • title (Field)
  • dept_name (Key2) — Foreign key → Department.dept_name — NOT NULL
  • credits (Field2)

Department (Untitled)

  • dept_name (Key) — Primary key — NOT NULL
  • building (Field)
  • budget (Field2)

Section (Untitled4)

  • sec_id (Key2) — Primary key — NOT NULL
  • course_id (Key) — Foreign key → Course.course_id — NOT NULL

Student (Untitled6)

  • ID (Key) — Primary key — NOT NULL
  • name (Field)
  • dept_name (Key2) — Foreign key → Department.dept_name — NOT NULL

Takes (Untitled5)

  • ID (Key) — Primary key — NOT NULL
  • semester (Field)
  • year (Field2)
  • grade (Field3)
  • course_id (Key2) — Foreign key → Course.course_id — NOT NULL
  • sec_id (Key22) — Foreign key → Section.sec_id — NOT NULL

Teaches (Untitled7)

  • ID (Key) — Primary key — NOT NULL
  • semester (Field)
  • year (Field2)
  • course_id (Key2) — Foreign key → Course.course_id — NOT NULL
  • sec_id (Key22) — Foreign key → Section.sec_id — NOT NULL

instructor (Untitled3)

  • ID (Key) — Primary key — NOT NULL
  • name (Field)
  • salary (Field2)
  • dept_name (Key2) — Foreign key → Department.dept_name — NOT NULL