Student Course Registration System

Tables (5)

Course

  • course_id — INT
  • course_code — VARCHAR(20) — NOT NULL
  • course_name — VARCHAR(200) — NOT NULL
  • credit — INT — NOT NULL
  • department — VARCHAR(100)

Course_Section

  • section_id — INT
  • course_id — INT — NOT NULL
  • professor_id — INT
  • semester — VARCHAR(20) — NOT NULL
  • year — INT — NOT NULL
  • classroom — VARCHAR(50)
  • schedule_time — VARCHAR(100)
  • capacity — INT

Enrollment

  • enrollment_id — INT
  • student_id — INT — NOT NULL
  • section_id — INT — NOT NULL
  • enroll_date — DATETIME — NOT NULL
  • grade — VARCHAR(5)

Professor

  • professor_id — INT
  • name — VARCHAR(100) — NOT NULL
  • office — VARCHAR(50)
  • email — VARCHAR(150)

Student

  • student_id — INT
  • name — VARCHAR(100) — NOT NULL
  • major — VARCHAR(100)
  • grade — VARCHAR(10)
  • email — VARCHAR(150)