a
Tables (3)
Student (student)
- Key (studentNum) — VARCHAR(100) — Primary key — NOT NULL
- Field (studentName) — VARCHAR(100)
- Field (major) — VARCHAR(100)
- Field (password) — VARCHAR(100)
Subject
- Key (subjectNum) — VARCHAR(100) — Primary key — NOT NULL
- Field (propessor) — VARCHAR(100)
- Field2 (subjectName) — VARCHAR(100)
- Field3 (prerequisiteSubject1) — VARCHAR(100)
- Field4 (prerequisiteSubject2) — VARCHAR(100)
takeSubject
- Key (studentNum) — VARCHAR(100) — Foreign key → Student.Key — NOT NULL
- Key (subjectNum) — VARCHAR(100) — Foreign key → Subject.Key — NOT NULL