A fundamental concept in computer science is distinguishing between databases and file systems.
Both databases and file systems store and manage data, but their objectives and operational methods differ significantly.
Databases are engineered for storing data in a structured manner. They employ tables to arrange data into rows and columns, facilitating the establishment of relationships between diverse datasets. This structure supports intricate queries and data manipulation, allowing for efficient handling of substantial data volumes and maintaining integrity via constraints and rules.
Conversely, file systems organize data as discrete files within a hierarchical framework. While offering a straightforward method for file storage and retrieval, they lack the sophisticated querying features and data interconnections inherent in databases. File systems are best suited for unstructured data and do not accommodate complex data operations.
Consequently, the core distinction is: Databases provide structured data with relationships, whereas file systems do not.
| RollNo | Name | Mobile | City |
| 1 | Arun | 91 | Delhi |
| 2 | Sanjay | 92 | Mumbai |
| 3 | Arun | 93 | Noida |
| 4 | Varun | 94 | Guwahati |
| 5 | Arti | 95 | Kolkata |
| List-I | List-II |
| (A) Controlled Data Sharing | (I) Same data maintained in different places does not match |
| (B) Data Isolation | (II) Limited Access given to users |
| (C) Data Dependence | (III) There is no mapping between two files |
| (D) Data Inconsistency | (IV) If the structure of a file is changed, all the existing programs accessing that file also need to be changed |