2
Tables (4)
Course
- CourseID — INT — Primary key — NOT NULL
- CourseName — VARCHAR(100) — NOT NULL
- Credit — INT — NOT NULL
- ProfessorID — INT — Foreign key → Professor.ProfessorID
Enrollment
- EnrollmentID — INT — Primary key — NOT NULL
- CourseID2 — INT — Foreign key → Course.CourseID
- StudentID — INT — Foreign key → Student.StudentID
- Grade — CHAR(1)
- CourseID — INT — NOT NULL
Professor
- ProfessorID — INT — Primary key — NOT NULL
- Name — VARCHAR(100) — NOT NULL
- Department — VARCHAR(100) — NOT NULL
Student
- StudentID — INT — Primary key — NOT NULL
- Name — VARCHAR(100) — NOT NULL
- Grade — INT — NOT NULL