Centralized database system for the system to easily handle


Problem Statement

There are a number of drawbacks that are associated with the current system that is followed in UNITEN

- Room for errors

The current system is hugely based upon the manual system which opens up the path for a number of errors.
The activities such as handling of student application, change in the student records, acknowledgement of the application received by the university, modification in the timetable and many others rely on the manual processes and thus, errors such as missing out of an important step, incorrect feeding of the information, loss of valuable information etc are very common.

- Increased staff and the cost associated with the same

Since there is a lesser application of automated systems and more reliance is on the manual processes, more and more staff is engaged in the same. It leads to a considerable share of the cost that can otherwise be saved if the automated systems are used in UNITEN.

- Increased possibility of malicious insider

When the entire functioning is relied upon the individuals, then there is an increased probability and possibility of malicious insider that may pass confidential information to the unauthorized sources.

- Slower processing

The productivity and efficiency of the automated systems would be far better than the manual systems. The process of a single registration of a student in a particular course will be easily 10 times of the entire registration process through automated systems. The slower processing is a major drawback that is involved with the current system.

- Lack of security

Security is a prime concern for the UNITEN management and administration and the same lacks in case of the manual systems. It becomes easier for the attackers and intruders to enter the premises and breach the security which would be difficult in case of an automated system.

- Duplication of data

The chances of duplication are huge in case of a manual system. There are scenarios when the same student gets enrolled in the same course more than once. Also, in case of an addition or a drop, the process gets repeated more than once leading to serious results and adverse impacts. Also, the matter worsens when such an error occurs in the accounts department related to the financial matters (Endeavour Solutions, 2013).

Proposed System

The proposed system is an automated system for the course registration and scheduling system of UNITEN.

It would be a web based system for registration, course offering, add/drop, and fee payment along with the scheduling system as well.

Following are the highlights of the proposed system:

- An online portal will be developed for computer systems and will also be accessible on the mobile devices for registration and scheduling.

- Login functionality for the students, faculty and the administrative department.

- The portal will provide a course catalogue along with the description, eligibility and fee structure specific to each and every course.

- Every single course will have a link for the registration form which would require the basic student information. On the basis of the information, an eligibility and validation check would be performed on the basis of data stored in the database.

- On success, the student will be re-directed to the fee payment page wherein there would be an option to use any of the payment gateways to complete the payment.

- A confirmation of payment will be sent over to the email address of the student and an option to save and print the receipt would also be provided.

- In order to add a new course, the student would be provided with an ability to pick an additional course and register for the same.

- The student database will automatically be updated once the changes are made and are confirmed.

- For the cancellation or the drop from the course, a request would be required to be made by the student which will be sent over to the head of the department for approval.

- On approval, the course information for the student will be updated and a refund would be initiated which shall be completed in a period of 7-10 days.

- Scheduling algorithm would be applied for the scheduling system which would be linked to the course and student information. It will be updated automatically in case of major additions or drops.

- The database would be centralized so that there are lesser chances of security attacks and the information would be accessible from a single source.

- There will also be an option of feedback present on the portal to understand the difficulties faced by the users and to receive the reviews as well.

Objectives

- Development of a reliable, faster and easy to understand automated system covering all the basic and advanced functionalities of the course registration and scheduling system for UNITEN.

- Centralized database system for the system to easily handle all of the information.

- Availability of the system at all times and from all the places to make sure that the system developed is of complete utility for the users.

Tasks and Deliverables:
- Based on the requirements elicited from the relevant stakeholders of the Course Registration and Scheduling System of UNITEN for Assignment 1:

a. Prepare the requirements specifications document of the proposed Enhanced Course Registration and Scheduling System.
b. Document your findings using the following outline:
1. Introduction
1.1 Purpose
1.2 Scope
1.3 Product overview
1.3.1 Product perspective
1.3.2 Product functions
1.3.3 User characteristics
1.3.4 Limitations
1.4 Definitions
2. References
3. Specific requirements
3.1 Functional requirements
3.1.1 System Feature 1
3.1.n System Feature n
3.2 Quality requirements
3.3 Constraints
4. Appendices
- Detailed descriptions for the above items can be found in ISO/IEC/IEEE 29148:2011 and IEEE Std 830-1998.

Rules and Requirements:
1. This is a group assignment/project - between 4 to 6 members (best in the same group as in Assignment 1).

2. This assignment/project is a mandatory course assessment and to be graded, that shall be solved and reported together with your group members.

3. Individual contribution to the project:
- After the project ends you will be asked to evaluate your own as well as your peers' contribution to the result and the overall working of the group. This can be used as one basis for the grading of an individual. It is very important that every group member contributes continuously to the project and group.

4. Other mandatory requirements:
- Proper and complete references to all supporting books/papers/info! Use referencing styles

- explained in the Report Writing Guideline available from https://sephiroth/spmsv2/ Text formatting: Calibri (not more than 11 points), single-spacing, justify paragraph

Request for Solution File

Ask an Expert for Answer!!
Other Engineering: Centralized database system for the system to easily handle
Reference No:- TGS01545324

Expected delivery within 24 Hours