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)