compare the difference between file-Based system vs.realation databases

*We can efficiently do work using file-based systems, but we can do even more work using relational database systems. However, a common person who is not familiar with the basics of databases may not be able to access the second method. File-based systems are easier to use than relational database systems, but with the latter, we can accomplish more work. Examples of file-based systems include Windows File Manager, while examples of relational database systems include database management systems.

              Watch This video:

The video discusses the advantages of using a database management system over a file system. The speaker highlights seven points that support this argument.

Firstly, file systems can lead to data redundancy and inconsistency as data can be duplicated in different files. In contrast, database management systems store all data in one central location, which helps to prevent inconsistencies.

Secondly, accessing data in a file system can be difficult, especially when trying to filter or query the data. Database management systems provide tools for easy data access.

Thirdly, file systems can lead to data isolation, meaning that unauthorized users can easily access data. Database management systems, on the other hand, restrict access to data based on user permissions.

Fourthly, data in file systems can be easily corrupted or modified accidentally. However, database management systems have mechanisms to ensure data integrity.

Fifthly, in file systems, updates can be incomplete or inconsistent. Database management systems ensure that updates are atomic, meaning that they are either completed successfully or not at all.

Sixthly, file systems can lead to concurrent access anomalies when multiple users access and modify the same data at the same time. Database management systems have mechanisms to prevent this.

Finally, file systems can be difficult to secure. Database management systems have built-in security features to protect data.

Overall, the speaker argues that database management systems are more efficient and reliable than file systems for storing and managing data. 

                *Thankyou*