univvv

Tables (5)

classroom

  • building — varchar(15)
  • room_number — varchar(7)
  • capacity — numeric(4,0)

course

  • course_id — varchar(8)
  • title — varchar(50)
  • dept_name — varchar(20)
  • credits — numeric(2,0)

department

  • dept_name — varchar(20)
  • building — varchar(15)
  • budget — numeric(12,2)

instructor

  • ID — varchar(5)
  • name — varchar(20) — NOT NULL
  • dept_name — varchar(20)
  • salary — numeric(8,2)

section

  • course_id — varchar(8)
  • sec_id — varchar(8)
  • semester — varchar(6)
  • year — numeric(4,0)
  • building — varchar(15)
  • room_number — varchar(7)
  • time_slot_id — varchar(4)