#DBMS
In this video, you will learn what is file processing system. What are the drawbacks of File Processing System (FPS).
1. Data Redundancy:
It is possible that the same information may be duplicated/replicated in the different files which leads to data redundancy, results in memory wastage.
2. Data Inconsistency:
Because of data redundancy, it is possible that data may not be in consistent state.
3. Difficulty in Accessing Data:
Accessing data is not convenient and efficient in file processing system.
4. Limited Data Sharing:
Data are scattered in various files. Also different files may have different formats and these files may be stored in different folders may be of different departments.
So, due to this data isolation, it is difficult to share data among different applications.
5. Integrity Problems:
Data integrity means that the data contained in the database in both correct and consistent. For this purpose the data stored in database must satisfy correct and constraints.
6. Atomicity Problems:
Any operation on database must be atomic.
This means, it must happen in its entirely or not at all.
7. Concurrent Access Anomalies:
Multiple users are allowed to access data simultaneously. This is for the sake of better performance and faster response.
8. Security Problems:
Database should be accessible to users in limited way.
Each user should be allowed to access data concerning his requirements only.
This question always been asked in the University Exams for 5 marks or 10 Marks.
It is very important topic in DBMS subject.
🙏🙏🙏🙏🙏🙏🙏🙏
YOU JUST NEED TO DO
3 THINGS to support my channel
LIKE
SHARE
&
SUBSCRIBE
TO MY YOUTUBE CHANNEL
🙏🙏🙏🙏🙏🙏🙏🙏
Keep Smiling and Keep Learning......