CS5054NP Advanced Programming and Technologies 1st sit Coursework - 01 Question Paper

CS5054NP Task A: System Development 

Please note that the scenario described below cannot be used as your coursework project. You are required to propose a new and original project idea that is distinct from any other projects from students and does not align with the provided project scenario.

Project Scenario 

For example, if we propose a Student Management System (SMS) named "CollegeApp",as our coursework project, the system would serve as a comprehensive web-based platform to manage student-related activitieswithin an educational institution. This project would allow students to explore key aspects of web development, including userauthentication, role-based authorization, data management, CRUD operations, and user interface design. 

The detailed information on system components is explained below:

1.Database Design and Development[5 marks] 

1. The database design will include a normalized data model capturing all essential entities and relationships, such as student records, courses, and user accounts, ensuring data integrity and minimizing redundancy. 
2. Relationships between entities will be mapped using foreign keys and constraints, and the database will be optimized for performance with indexing and transaction management to ensure efficient and consistent data operations. 
3. Backup and recovery mechanisms will be implemented to protect against data loss or corruption, ensuring the system's reliability and resilience. 

2.Admin Dashboard: [10 marks] 

1. The admin dashboard would enable administrators to manage student records by creating, updating, deleting, and viewingdetailed information such as personal data (e.g., name, date of birth, contact details) and academic data (e.g., courses enrolled, grades, attendance). 
2. Additionally, it would facilitate course management by allowing administrators to assign courses, manage course content, and organize class schedules. 
3. The system would also generate reportson student performance, attendance, and other academic metrics to aid in decision-making and planning. 
4. Furthermore, user management capabilities would allow the creation and management of user accounts with appropriate roles and permissions. 

3.User Portal: [10 marks] 

1. The student portal would provide students with a platform to manage their profiles, allowing them to log in, view, and updatetheir personal information, including contact details and passwords. 
2. Students would also have access to their academic records, such as grades, course enrollments, and attendance. The portal would enable students to access course- related materials, including lecture notes and assignments. 
3. The system will include a search feature that allows students to find specific information, such as courses or modules, using a search bar.

6. Frontend Design and Development:[5 marks] 

1. The user interface would be built usingJavaServer Pages (JSP)for dynamic content and CSSfor styling, ensuring a responsiveand user-friendly design that accommodates a range of devices, from desktops to mobile phones. The use of frameworks like Bootstrap and others is prohibited. You can use CSS media query and Flexbox properties for responsive design. 
2. JavaScript should be only used as needed for enhancing the design and user experienceof the application. The core functionality and server-side logic will be managed by the Java-based components of the system.

7.Additional Features: [5 marks] 

The system can improve with the inclusion of: 

1. About pageto provide information about the institution and the purpose of the SMS. 
2. Contact pageoffering support details and a form for inquiries and so on.

 CS5054NP Task B: Report (50 marks)

 Word Count: 16,000 (word count starts from introduction till conclusion.)

1.Introduction 

This section should include a clear and concise introduction to the project, covering the following elements: 

• Title: Provide a descriptive title for your project. 
• Purpose: Explain the purpose of the project and why it is being developed. 
• Audience: Identify the intended audience for your application. 
• Aims and Objectives: Outline the main aims and objectives that the project seeks to achieve. 
• List of Features: Identify the features to implement in your system and outline them in one line.

2. Wireframe [8 marks] 

• Present the wireframes of your application alongside your prototype designs, showing the layout and structure of the user interface. This should include all major screens, such as the login page, dashboard, and any other key pages. 

3.Java Classes Explanation [8 marks] 

• Provide a concise explanation of the Java classes used in your application. 

This section should include: 

1. Class Diagram: A visual representation of the classes, their relationships, and interactions. 
2. Methods Explanation: For each Java class, list the methods used and explain their purpose and functionality.

4.Test Cases [10 marks]

• When documenting your test cases, ensure that each test case is thoroughly detailed with a comprehensive test table and clear steps to achieve the expected result. This section should demonstrate the full range of tests conducted to validate the functionality and robustness of your project.

5.Coursework Development and Critical Analysis [10 marks] 

Document the development process of your coursework according to the team member, including the tools used to complete the system. For each tool, provide: 

• Tool Description: What the tool is and its primary purpose. 
• Usage: How the tool was used in the development process. 
• Evidence: Include screenshots or other evidence demonstrating the use of the tool. 
• You can take Database Tables and ER Diagrams as an example to start with.

-List of Database Tables: Identify and list the tables utilized within your application, such as Students, Courses, and Enrollments, each serving distinct roles in data management. 
-Entity-Relationship (ER) Diagram: Provide a comprehensive ER diagram that illustrates the relationships between these tables, highlighting primary and foreign keys. 
-Tool Utilized: Specify the tool employed, such as XAMPP, and its primary function in designing and managing the database schema. ------Application of the Tool: Detail how the tool was used to develop a complete database and generate the ER diagram, ensuring the integrity and efficiency of the data structure.
-Evidence: Include relevant evidence, such as screenshots of the database tables and the ER diagram, to substantiate your implementation process.