University-ER-Diagram-

Tables (4)

Attempts (attempts)

  • Attempt Token ID (attempt_token_id) — VARCHAR(11) — Primary key — NOT NULL
  • Course ID (course_id) — VARCHAR(11) — Foreign key → Course.Course ID — NOT NULL
  • Program ID (program_id) — VARCHAR(11) — Foreign key → Course.Program ID — NOT NULL
  • Student ID (student_id) — VARCHAR(11) — Foreign key → Student.Student ID — NOT NULL
  • Semester (semester) — CHAR(1)
  • Year (year) — VARCHAR(8) — NOT NULL
  • Mark (mark) — SMALLINT(3)
  • Grade (grade) — CHAR(3)

Course (course)

  • Course ID (course_id) — VARCHAR(11) — Primary key — NOT NULL
  • Program ID (program_id) — VARCHAR(11) — Foreign key → Program.Program ID — NOT NULL
  • Course Name (course_name) — VARCHAR(255)
  • Credit Points (credit_point) — FLOAT(3)
  • Year Commenced (year_commenced) — VARCHAR(8)

Program (program)

  • Program ID (program_id) — VARCHAR(11) — Primary key — NOT NULL
  • Program Name (program_name) — VARCHAR(255)
  • Credit Points (credit_point) — FLOAT(3)
  • Year Commenced (year_commenced) — VARCHAR(8)

Student (student)

  • Student ID (student_id) — VARCHAR(11) — Primary key — NOT NULL
  • Program ID (program_id) — VARCHAR(11) — Foreign key → Program.Program ID — NOT NULL
  • Given Name (given_name) — VARCHAR(255)
  • Sure Name (sure_name) — VARCHAR(255)
  • Date of Brith (date_birth) — VARCHAR(8)
  • Year Enrolled (enrollment_date) — VARCHAR(8)