Système de gestion des examens nationaux

Exam Management System

• National exams are managed by the academic inspection, involving students of the specific academy.
• Students must complete a numbered registration form by December 31st of the academic year.
• This form includes student name, date of birth, school, and the exam name.
• Each school is identified by a unique code, name, address, and city.
• Each exam consists of several subjects with different weighting.
• All exams occur on the same date within the academy.
• Exam questions are created by a committee of teachers meeting at the academic inspection at least two months before the exam date.
• Marking/correction happens the day after the exam.
• Teacher details include staff number, name, phone, address, city, and school.
• Student results are compiled on a form for the examination board.
• The final decision on student admission is communicated by the academic inspector.

Data Model

• Entities of the data model:

  • Establishment
  • Student
  • Department
  • Examination board
  • Command
  • Client
  • Examination
  • Question paper editing committee
  • Exam marks spreadsheet
  • University
  • Exam subject

• Exam can have multiple subjects.

• A question paper editing committee is for a single exam.

• A question paper editing committee is for a specific group of exams.

• Each student is registered in one establishment.

• A student can be registered for multiple exams.

• Each mark sheet is for a single student.

• A mark sheet can relate to multiple subjects.

Communication Model

• Students submit their registration forms to their school before the deadline.
• Schools send a list of registered students to the academic inspection for validation.
• The academic inspector communicates exam details (subjects, dates, etc.) and notices to teachers.
• Teachers receive questions to prepare.
• Teachers/schools communicate important practical information to students.
• Students take the exams.
• Exam scores are sent to the examination board.
• The academic inspector sends the final admission decision.

Questions on the Case Study

• Identifying entities in the data model: Students, schools, departments, examination committees, instructors, exam subjects, student marks and grade records, etc.
• Exam characteristics: Exams can have multiple subjects, one subject per exam. A single exam can have multiple questions. An examination committee is designated for each exam.
• Student registration: A student can be registered in multiple establishments, one establishment per student.
• Marking sheets: Each mark sheet is for a single student and can be linked to multiple exam subjects.
• Relationships between entities: Defining the relationships between students, schools, and exams (e.g., many-to-many)
• Primary keys and foreign keys: Which database features uniquely identify each element and/or link between entities?
• Exam relationship: The relationship between Exams and Subjects, is one-to-many (one exam can have multiple subjects). Which primary or foreign keys dictate this relationship?
• Exam and Examination Committee relations: The relationship between Exams and the committees that write the exam questions. Is it one-to-one or one-to-many?
• Students and exams: What does each student's relationship to exams mean (one-to-one, one-to-many)?

Other Information

• Unique exam identifier: The attribute that identifies an exam uniquely. (e.g., exam ID).
• Relationship Keys: Foreign Keys are usually used to link entities. The questions refer to establishing appropriate relationships between entities.
• Relationship Cardinalities: Defining whether a relationship is one-to-one, one-to-many, or many-to-many.