SWE5201 - Advanced Programming Database Software Engineering

Assignment Task

Introduction

Regent College London is a globally recognised educational institution that offers a broad spectrum of undergraduate and postgraduate programs to students from diverse cultural backgrounds. The college has developed a student information system to monitor student records, course offerings, and enrolment information to enhance student information management. As an accomplished software engineer specialising in and Visual Studio, the responsibility of developing this system to facilitate the effective management of student information has been entrusted to me.

The key objective of this project is to design, implement, and test a software application that adequately leverages advanced programming techniques, such as object/relational mappers, encapsulation, polymorphism, inheritance, interfaces, enumerations, refactoring, and design patterns. The system's primary purpose is to allow college staff members to display, insert, and delete student records and search for records displaying their progress in different modules. Moreover, the system must enable staff members to view a comprehensive list of courses each department offers, lists of students enrolled in various departments, and undergraduate/postgraduate courses available on each campus.

The project will appropriately use memory and file or database storage depending on the system's needs. The code will be thoroughly commented on, and any compilation errors will be eliminated before submission. An implementation report will accompany the code,

documenting the advanced programming techniques employed in the project, the development and evolution of the solution, the testing methodology used, and any significant deviations from the initial design and the justifications for those changes. Finally, the system will be presented to the lecturer in class on or before the deadline for submission.

Project Overview

The Student Information System for Regent College London aims to develop a software application to manage student records, course offerings, and enrolment effectively. The system enables authorised staff members to view, insert, delete, and search student records and lists of courses and enrolled students, providing enhanced data management capabilities.

Project Goals and Objectives

The project aims to provide a comprehensive and user-friendly system that enhances the management of Regent College London's student records and course information. The project aims to ensure that all data is securely and accurately stored and managed and to improve the efficiency and effectiveness of staff members in managing student records and course information. The project also aims to implement advanced programming approaches such as Object/Relational Mappers, Encapsulation, Polymorphism, Inheritance, Interfaces, Enumerations, Refactoring Design Patterns, etc., to ensure the development of a highly functional and advanced system.

Scope of the Project

The project's scope includes designing and developing the Student Information System application, including implementing appropriate database or file storage mechanisms for storing student and course information. The project also includes testing the system to ensure its accuracy and functionality, deployment of the system to the production environment, and ongoing maintenance and support as required.

Equirement Analysis and Design Phase

• Gather requirements and define project scope.
• Create a detailed design document.
• Determine technologies and tools to be used.
• Create a project plan and timeline.

Development Phase

• Implement the design and architecture defined in the planning phase.
• Ensure the system meets all requirements and specifications.
• Integrate appropriate database or file storage mechanisms.
• Test the system for accuracy and functionality.

Testing and Quality Assurance Phase

• Rigorously test the system to ensure accuracy and functionality.
• Identify and fix any bugs or issues that arise during testing.
• Ensure the system is fully functional and ready for deployment.

Deployment and Maintenance Phase

• Deploy the system to the production environment.
• Provide ongoing maintenance and support as needed.
• Identify and address any issues or bugs in the live system.
• Periodically update and enhance the system over time.

Project Team

• Project Manager: responsible for overall project management and coordination.
• Software Engineer: responsible for designing and developing the software application.
• Quality Assurance Engineer: responsible for testing and quality assurance.
• Database Administrator: responsible for managing database or file storage mechanisms.

Project Risks

• Delay in gathering requirements or defining project scope.
• Technical challenges in implementing advanced programming approaches or integrating database or file storage mechanisms.
• Bugs or issues discovered during testing that require significant rework or redesign.
• User adoption and training issues upon deployment.

Database Design

We will use Microsoft SQL Server as the database management system for the Student Information System. The database design will include the following tables:

The database design will be implemented using SQL Server Management Studio, which provides robust tools for managing and designing SQL Server databases.

Overall, the development phase will involve implementing the design and architecture defined in the planning phase. We will use a combination of tools and technologies, including Visual Studio, C#, .NET Framework, ORM frameworks, SQL Server, and Git, to develop a comprehensive and user-friendly Student Information System for Regent College London.

We will ensure that the system meets all requirements and specifications and is accurately and securely storing and managing student and course information. We will also implement appropriate testing methodologies, such as manual and automated unit testing, to ensure the system is fully functional and ready for deployment. Finally, we will document the development process, including the design and architecture, the code implementation, and the database design, to ensure that the system is maintainable and scalable over time.

Deployment and Maintenance Phase

The Deployment and Maintenance Phase is critical to the Student Information System for the Regent College London project. This phase follows the Testing and Quality Assurance phase. Its goal is to deploy the system to the production environment, provide ongoing maintenance and support as needed, identify and address any issues or bugs in the live system, and periodically update and enhance the system over time.

During this phase, the project team will deploy the system to the production environment, which involves moving the application from the testing environment to the live environment. It is crucial to ensure that the system is fully functional and ready for deployment and that all data is accurately and securely stored and managed.

Once the system is deployed, ongoing maintenance and support will be provided as needed. The project team will identify and address any issues or bugs in the live system, ensuring that the system is running smoothly and efficiently. The team will also periodically update and enhance the plan to meet new requirements or address any environmental changes.

It is important to note that this phase is ongoing, and the system will require regular maintenance and support to ensure that it continues to meet the needs of Regent College London and its users. It is also essential to comply with all relevant data protection laws and regulations and ensure the system is scalable to accommodate future student and course data growth. Additionally, the system must handle multiple concurrent users without performance issues and be user-friendly and easy to navigate.

This SWE5201 – Engineering has been solved by our PHD Experts at My Uni Paper.