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)