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