test

Tables (5)

Untitled (Student)

  • Key (std_id) — int — Primary key — NOT NULL
  • Key (dept_id) — int — Foreign key → Untitled4.Key — NOT NULL
  • Field (std_name) — varchar(100)
  • Field2 (height) — int

Untitled (Professor)

  • Key (prof_id) — Primary key — NOT NULL
  • Key (dept_id) — int — Foreign key → Untitled4.Key — NOT NULL
  • Field (prof_name)

Untitled2 (Course)

  • Key (course_id) — Primary key — NOT NULL
  • Key (prof_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (course_name)
  • Field3 (start_date)
  • Field4 (end_date)

Untitled3 (Std_Course)

  • Key (std_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (course_id) — Foreign key → Untitled2.Key — NOT NULL

Untitled4 (Department)

  • Key (dept_id) — int — Primary key — NOT NULL
  • Field (dept_name) — varchar(255)