🎓 Student Projects (College Reports) · Database ERD
Online Examination System ER Diagram
Database design for online exams: courses, exams, questions and options, attempts, answers and results.
Drawing diagram…
What this diagram shows
- Questions with options for MCQs
- One attempt per student per exam, with each answer stored
- Result linked to the attempt
Prompt used
ER diagram for an online examination system: Student, Examiner, Course, Exam (belongs to a course, set by an examiner, with start time and duration), Question (in an exam, type MCQ or descriptive, marks), Option (for MCQ questions, with a correct flag), Attempt (a student taking an exam), Answer (an attempt's answer to a question) and Result (score and grade for an attempt).
Mermaid code
erDiagram
COURSE ||--o{ EXAM : has
EXAMINER ||--o{ EXAM : sets
EXAM ||--|{ QUESTION : contains
QUESTION ||--o{ OPTION : offers
STUDENT ||--o{ ATTEMPT : makes
EXAM ||--o{ ATTEMPT : "taken in"
ATTEMPT ||--|{ ANSWER : records
QUESTION ||--o{ ANSWER : "answered by"
ATTEMPT ||--|| RESULT : produces
STUDENT {
int student_id PK
string name
string email
}
EXAMINER {
int examiner_id PK
string name
}
COURSE {
int course_id PK
string title
}
EXAM {
int exam_id PK
int course_id FK
int examiner_id FK
datetime start_time
int duration_min
}
QUESTION {
int question_id PK
int exam_id FK
string type
int marks
}
OPTION {
int option_id PK
int question_id FK
string text
boolean is_correct
}
ATTEMPT {
int attempt_id PK
int student_id FK
int exam_id FK
datetime submitted_at
}
ANSWER {
int answer_id PK
int attempt_id FK
int question_id FK
string response
}
RESULT {
int result_id PK
int attempt_id FK
decimal score
string grade
}Related templates
Library Management System Use Case Diagram
Who uses a college library system and what each of them can do: members, the librarian and the system administrator.
Library Management System ER Diagram
The database of a library system: books and their copies, authors, members, loans, reservations and fines, with keys and cardinality.
Library Management System Data Flow Diagram (Level 1)
How data moves through a library system: members and the librarian, the main processes, and the data stores they read and write.
Library Management System Class Diagram
The main classes of a library system with attributes, methods and UML relationships.
Library Management System Sequence Diagram (Issue a Book)
The steps when a member borrows a book: checks, loan record and the copy status update.
Online Examination System Use Case Diagram
What students, examiners and the administrator do in an online examination system.