Task

Tables (5)

course (Untitled5)

  • studno (Key) — Foreign key → student.studno — NOT NULL
  • lecno (Key2) — Foreign key → lecture.lecno — NOT NULL
  • profno (Key22) — Foreign key → lecture.profno — NOT NULL

department (Untitled3)

  • deptno (Key) — Primary key — NOT NULL
  • dname (Field)
  • number (Field2)

lecture (Untitled4)

  • lecno (Key) — Primary key — NOT NULL
  • profno (Key2) — Foreign key → professor.profno — NOT NULL
  • lname (Field)

professor (Untitled2)

  • profno (Key) — Primary key — NOT NULL
  • name (Field)
  • idnum (Field2)
  • userid (Field3)
  • deptno (Field4)

student (Untitled)

  • studno (Key) — Primary key — NOT NULL
  • name (Field)
  • idnum (Field2)
  • profno (Field3)
  • deptno (Field4)