• ISSN [ Online ] : 3139-0862

Volume 1 - Issue 4, September - October 2026

  • Home
  • September - October 2026

Design and Implementation of a Centralized Academic Project Archive System Using MySQL

📑 Paper Information
📑 Paper Title Design and Implementation of a Centralized Academic Project Archive System Using MySQL
👤 Authors Nilanjan Mane, Lokesh Patil, Varad Jamdar
📘 Published Issue Volume 1 Issue 5
📅 Year of Publication 2026
🆔 Unique Identification Number IJCSED-V1I5P3
📝 Abstract
Academic project records in educational institutions are often scattered across spreadsheets, folders and individual memory, which makes earlier work hard to find, compare and reuse. This paper presents the design and implementation of the Academic Project Archive System, a centralized relational database built with MySQL Server and MySQL Workbench. The schema, named project archive, contains 14 tables that model projects, students, teams, guides, domains, technologies, competitions, documents, reviews and project outputs. Four junction tables resolve many-to-many relationships, and 13 foreign-key constraints enforce referential integrity. The implementation consists of SQL scripts for schema creation, sample-data loading, joins, filtering, grouping, nested subqueries, three views and reporting queries. Executing the scripts on a sample dataset of 50 projects (IDs 301 to 350) produced domain-wise, status-wise, year-wise, technology and competition summaries, for example 34 completed and 16 in-progress projects across 13 domains. The study also records design limitations, including the absence of uniqueness and check constraints, which allowed a duplicate enrolment number in the sample data. The contribution is not a new database technique but a documented, reproducible schema that links projects with competition outcomes and publication or patent records, together with an honest account of its limits. No user interface, performance benchmark or user study is reported.
📝 How to Cite
Nilanjan Mane, Lokesh Patil, Varad Jamdar, "Design and Implementation of a Centralized Academic Project Archive System Using MySQL" International Journal of Computer Science and Engineering Development, V1(5): Page(09-16) November - December 2026. ISSN: 3139-0862. www.ijcsed.com. Published by Scientific and Academic Research Publishing.