TEC Level 5 HND Computing: Database Design & Development Assignment 2

This report presents the implementation and evaluation of a database design and development project. It details the creation of various database tables, including students, majors, courses, student_course, and account tables, and explains how to add, edit, and delete data within these tables using SQL statements. The report also covers the development of user interfaces, including login forms and data display forms for student, course, and transcript information. Furthermore, it provides code snippets for performing various queries, such as displaying student data, adding new data, updating data, and deleting data. The report includes detailed testing procedures with test cases to verify the functionality of the database system, including data editing, data addition, user login, data deletion, and user logout. Finally, the report includes a technical document with an ERD, and a user document explaining how to use the system.