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)