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)