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