University Database

Tables (6)

Completed (completed)

  • CourseID (course_id) — INT(9) — Primary key — NOT NULL
  • Student ID (student_id) — INT(9) — Foreign key → Student.Student ID — NOT NULL
  • Key (program_id) — INT(9) — Foreign key → Student.Key — NOT NULL
  • Grade (grade) — VARCHAR(255))
  • Marks (marks) — INT(3)

Course (course)

  • Course ID (course_id) — INT(9) — Primary key — NOT NULL
  • Key (program_id) — INT(9) — Foreign key → Program.Key — NOT NULL
  • Name (name) — VARCHAR(255)
  • Credit (credit) — INT(3)
  • Year (year) — VARCHAR(255)
  • Student ID (student_id) — INT(9) — Foreign key → Student.Student ID — NOT NULL
  • Course ID (course_id2) — INT(9) — Foreign key → Student.Course ID — NOT NULL
  • Key (program_id2) — INT(9) — Foreign key → Student.Key — NOT NULL
  • University ID (university_id2) — INT(9) — Foreign key — NOT NULL

Program (program)

  • Key (program_id) — INT(9) — Primary key — NOT NULL
  • Name (name) — VARCHAR(255)
  • Total Credit (total_credit) — INT(3)
  • Year (year) — VARCHAR(255)
  • University ID (university_id) — INT(9) — Foreign key → University.University ID — NOT NULL

Running Course (running course)

  • Course ID (course_id) — INT(9) — Primary key — NOT NULL
  • Student ID (student_id) — INT(9) — Foreign key → Student.Student ID — NOT NULL
  • Year (year) — VARCHAR(255)
  • Semester (semester) — VARCHAR(255)

Student (student)

  • Student ID (student_id) — INT(9) — Primary key — NOT NULL
  • Course ID (course_id) — INT(9) — Foreign key → Course.Course ID — NOT NULL
  • Key (program_id) — INT(9) — Foreign key → Course.Key — NOT NULL
  • Lats Name (last_name) — VARCHAR(255)
  • First Name (first_name) — VARCHAR(255)
  • Sex (sex) — CHAR(1)
  • Date of Birth (date_of_birth) — VARCHAR(255)
  • Student From (student_from) — VARCHAR(255)

University (university)

  • University ID (university_id) — INT(9) — Primary key — NOT NULL
  • University Name (university_name) — VARCHAR(255)