test

Tables (5)

enrollments

  • enrollment_id — INT
  • student_id — INT
  • subject_code — VARCHAR(10)
  • professor_id — INT

majors

  • major_id — INT
  • major_name — VARCHAR(50) — NOT NULL

professors

  • professor_id — INT
  • professor_name — VARCHAR(50) — NOT NULL

students

  • student_id — INT
  • student_name — VARCHAR(50) — NOT NULL
  • major_id — INT

subjects

  • subject_code — VARCHAR(10)
  • subject_name — VARCHAR(50) — NOT NULL
  • credit — INT