hsu-ERD

Tables (6)

Copy Of Untitled (COURSE)

  • Key (course_id) — INT — Primary key — NOT NULL
  • Field (title) — VARCHAR(100)
  • Field2 (credit) — INT

Copy Of Untitled2 (CLASS)

  • Key (class_id) — INT — Primary key — NOT NULL
  • Field (year) — INT
  • Field (semester) — INT
  • Field (division) — VARCHAR(10)
  • Field (classroom) — VARCHAR(20)
  • Field (enroll) — INT
  • Key (prof_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Key (course_id) — INT — Foreign key → Copy Of Untitled.Key — NOT NULL

Untitled (STUDENT)

  • Key (stu_id) — INT — Primary key — NOT NULL
  • Field (name) — VARCHAR(50)
  • Field3 (address) — VARCHAR(50)
  • Field4 (year) — INT
  • (dept_id) — INT — Foreign key → hi.dept_id — NOT NULL

Untitled (PROFESSOR)

  • Key (prof_id) — INT — Primary key — NOT NULL
  • Field (name) — VARCHAR(50)
  • Field2 (year_emp) — INT
  • Field3 (position) — VARCHAR(30)
  • Field (resident_id) — CHAR(13)
  • (dept_id) — INT — Foreign key → hi.dept_id — NOT NULL

Untitled (TAKES)

  • Key (class_id) — INT — Foreign key → Copy Of Untitled2.Key — NOT NULL
  • Key (stu_id) — INT — Foreign key → Untitled.Key — NOT NULL
  • Field (grade) — CHAR(10)

hi (DEPARTMENT)

  • (dept_id) — INT — Primary key — NOT NULL
  • Field (dept_name) — VARCHAR(50)
  • Field2 (office) — VARCHAR(50)