In the context of global education, universities and institutions emphasize the importance of proficient academic information management systems. As traditional approaches to course data management become obsolete, there is a growing need to leverage digital transformation for academic management. This paper proposes a novel course database design that centralizes information about subjects, courses, staff, students, buildings, and grades. The database is designed to facilitate the overall academic progress of students by ensuring efficient record keeping, retrieval and updating. The architecture simplifies administrative tasks, underscores the importance of databases in modern educational institutions by providing in-depth student data to support personalized learning, enhance communication among stakeholders, and aid academic research. The conclusion of the experimental test is that a database designer should always ensure they pay attention to avoiding data redundancy and ensuring data diversity when processing data.