DB_university

Tables (7)

Classroom (classroom)

  • Building (building) — varchar(15) — Primary key — NOT NULL
  • Room number (room_number) — varchar(20) — Primary key — NOT NULL
  • Capacity (capacity) — numeric(4,0)

Course (course)

  • Course id (course_id) — varchar(8) — Primary key — NOT NULL
  • Dept name (dept_name) — varchar(20) — Foreign key → Department.Dept name — NOT NULL
  • Title (title) — varchar(50)
  • Credits (credits) — numeric(2,0)

Department (department)

  • Dept name (dept_name) — varchar(20) — Primary key — NOT NULL
  • Building (building) — varchar(15)
  • Budget (budget) — nemeric(12,2)

Instructor (instructor)

  • ID — varchar(5) — Primary key — NOT NULL
  • Dept name (dept_name) — varchar(20) — Foreign key → Department.Dept name — NOT NULL
  • Name (name) — varchar(20)
  • Salary (salary) — numeric(8,2)

Section (section)

  • Course id (course_id) — varchar(8) — Primary key — NOT NULL
  • Sec id (sec_id) — varchar(8) — Primary key — NOT NULL
  • Semester (semester) — varchar(8) — Primary key — NOT NULL
  • Year (year) — numeric(4,0) — Primary key — NOT NULL
  • Building (building) — varchar(15) — Foreign key → Classroom.Building — NOT NULL
  • Room number (room_number) — varchar(20) — Foreign key → Classroom.Room number — NOT NULL
  • Time Slot id (time_slot_id) — varchar(4)

Student (student)

  • ID — varchar(5) — Primary key — NOT NULL
  • Name (name) — varchar(20)
  • Total Credit (tot_cred) — numeric(3,0)

Teaches (teaches)

  • ID — varchar(5) — Primary key — NOT NULL
  • Course ID (course_id) — varchar(8) — Primary key
  • Sec ID (sec_id) — varchar(8) — Primary key
  • Semester (semester) — varchar(6) — Primary key
  • Year (year) — numeric(4,0) — Primary key
  • Course id (course_id2) — varchar(8) — Foreign key → Section.Course id — NOT NULL
  • Sec id (sec_id2) — varchar(8) — Foreign key → Section.Sec id — NOT NULL
  • Semester (semester2) — varchar(8) — Foreign key → Section.Semester — NOT NULL
  • Year (year2) — numeric(4,0) — Foreign key → Section.Year — NOT NULL
  • Building (building) — varchar(15) — Foreign key → Section.Building — NOT NULL
  • Room number (room_number) — varchar(20) — Foreign key → Section.Room number — NOT NULL