Database is maintained by keeping only relevant data and updating existing data in a timely manner.
This is achieved by issuing proper insert, update and delete operations.
Incorrect data leads to incomplete information. Databases which hold transaction details, any inaccuracies lead to misinformation to its users.
Both the above lead to serious issues in data maintenance and prove the database ineffective. This indicates manhandling of the database.
No maintenance
Database is maintained when only relevant information is present. Irrelevant information includes information like information of past students, old information of current students, etc.
For students who have completed their courses and left, the database should be updated by removing data of such students.
Also, for newly enrolled students, their enrolment should reflect in the official records.
In case of changes in any of the student information, timely update operations should be performed to keep only current data in the database.
All these operations should be done timely in order to avoid any discrepancies in the real data and updated data in the system.
Incorrect data
In situations where incorrect data is input in the student database, incorrect data will be recorded for that particular student. Incorrect data can be related to ssn, name, address, course details and fees payment.
In case of incorrect transaction details like fees payment, this incorrect data will reflect in the student record as well as will affect the overall earnings of the school.
For enrolled students, correct enrollment details regarding the course and classroom should be recorded. Any error in this data will cause the student inconvenience and the respective student will be at loss.
Also, taking advantage of this situation, any outsider acting as an enrolled student, can gain access to the school.
This leads to mismatch of information and can lead to fraud situations against the educational institute.
