Attendance tracking
Modelling attendance at a university, then analysing a year group.
- Type
- Databases
- Context
- Pair project, BUT year 1 (SAE 2.04)
- Year
- 2025
- Technologies
- SQL, Looping, Python, pandas, Jupyter
First, design the database that tracks student attendance at every session: data dictionary, functional dependencies, conceptual model in Looping, then the SQL script. Ten tables, from programmes down to one student’s attendance at one session.
The database has three roles, secretary, teacher and director, each with its own views and permissions: teachers can read the lists and correct attendance for their own sessions, without touching anything else.
Then, in Python with pandas, analyse the results and absences of a year group of 57 students over three years: merging and cleaning the files, then statistics. Absences drop from 632 in the first year to 67 in the third, and students from general and technological high-school tracks are almost evenly split, against the 50% quota set for IUTs.
- Conceptual model, functional dependencies and SQL script
- Three roles, with views and permissions
- Data analysis in Python, pandas and Jupyter