Kent Institute: DBFN212 Database Design and Development Project

This report details the design and development of a relational database for a college, addressing the need for efficient student progress tracking. The project encompasses the creation of an Entity Relationship Diagram (ERD) to visualize entities and relationships within the system, followed by normalization to optimize data storage and reduce redundancy. The report outlines database tables with their keys, fields, and sample data. It also includes SQL queries designed to retrieve specific information, such as student attendance, enrollment details, and the number of absentees per module. A concluding section summarizes the project and its outcomes, emphasizing the practical application of database design principles. The report also provides a comprehensive bibliography of relevant resources. This project showcases the practical application of database design principles, encompassing ER diagrams, normalization, table design, and SQL queries. The report also covers the implementation of the database for a college, focusing on student progress.