work

Tables (5)

Professor (Untitled2)

  • professor PK(professor_id) (Key) — Primary key — NOT NULL
  • professor_id (Field)
  • professor_name (Field2)
  • department_id (Field3)

course (Untitled3)

  • pk_course(course_id) (Key) — Primary key — NOT NULL
  • course_id (Field)
  • course_name (Field2)
  • start_date (Field3)
  • end_date (Field4)
  • professor_id (Field5)

department (Untitled)

  • department PK(department_id) (Key) — Primary key — NOT NULL
  • department_id (Field)
  • department_name (Field2)

student (Untitled5)

  • student PK(student_id) (Key) — Primary key — NOT NULL
  • student_id (Field)
  • student_name (Field2)
  • height (Field3)
  • department_id (Field4)

student_course (Untitled4)

  • student_id (Field)
  • course_id (Field2)