test
Tables (7)
advisor (Untitled3)
- I_ID (i_id) — INT — Foreign key → instructor.ID — NOT NULL
- S_ID (s_id) — INT — Foreign key → student.ID — NOT NULL
classroom (Untitled7)
- BUILDING (building) — VARCHAR(20) — Primary key — NOT NULL
- ROOM_NO (room_no) — VARCHAR(20) — Primary key — NOT NULL
- CAPACITY (capacity) — VARCHAR(20)
department (Untitled)
- DEPT_NAME (dept_name) — VARCHAR(20) — Primary key — NOT NULL
- BUILDING (building) — VARCHAR(20)
- BUDGET (budget) — INT
instructor (Untitled4)
- ID (id) — INT — Primary key — NOT NULL
- NAME (name) — VARCHAR(20)
- DEPT_NAME (dept_name) — VARCHAR(20)
- SALARY (salary) — INT
section (Untitled5)
- COURSE_ID (course_id) — INT — Primary key — NOT NULL
- SEC_ID (sec_id) — INT — Primary key — NOT NULL
- SEMESTER (semester) — VARCHAR(20) — Primary key — NOT NULL
- YEAR (year) — INT — Primary key — NOT NULL
- BUILDING (building) — VARCHAR(20) — Foreign key → classroom.BUILDING — NOT NULL
- ROOM_NO (room_no) — VARCHAR(20) — Foreign key → classroom.ROOM_NO — NOT NULL
student (Untitled2)
- ID (id) — INT — Primary key — NOT NULL
- NAME (name) — VARCHAR(20)
- TOTAL_GRADE (tot_grad) — INT
- DEPT_NAME (dept_name) — VARCHAR(20) — Foreign key → department.DEPT_NAME — NOT NULL
takes (Untitled6)
- ID (id) — INT — Foreign key → student.ID — NOT NULL