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