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)