d

Tables (11)

advisor

  • s_ID — varchar(5) — Primary key — NOT NULL
  • i_ID — varchar(5)

classroom

  • building — varchar(15) — Primary key — NOT NULL
  • room_number — varchar(7) — Primary key — NOT NULL
  • capacity — numeric(4,0)

course

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

department

  • dept_name — varchar(20) — Primary key — NOT NULL
  • building — varchar(15)
  • budget — numeric(12,2)

instructor

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

prereq

  • course_id — varchar(8) — Primary key — NOT NULL
  • prereq_id — varchar(8) — Primary key — NOT NULL

section

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

student

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

takes

  • ID — varchar(5) — Primary key — NOT NULL
  • course_id — varchar(8) — Primary key — NOT NULL
  • sec_id — varchar(8) — Primary key — NOT NULL
  • semester — varchar(6) — Primary key — NOT NULL
  • year — numeric(4,0) — Primary key — NOT NULL
  • grade — varchar(2)

teaches

  • ID — varchar(5) — Primary key — NOT NULL
  • course_id — varchar(8) — Primary key — NOT NULL
  • sec_id — varchar(8) — Primary key — NOT NULL
  • semester — varchar(6) — Primary key — NOT NULL
  • year — numeric(4,0) — Primary key — NOT NULL

time_slot

  • time_slot_id — varchar(4) — Primary key — NOT NULL
  • day — varchar(1) — Primary key — NOT NULL
  • start_hr — numeric(2) — Primary key — NOT NULL
  • start_min — numeric(2) — Primary key — NOT NULL
  • end_hr — numeric(2)
  • end_min — numeric(2)