File System v/s Database Management System DBMS

For Complete YouTube Video: Click Here

In this class, we will understand File System v/s Database Management System DBMS.

We have already discussed the definitions of Data, Database, and Database Management Systems DBMS.

Table of Contents

This discussion will clearly distinguish the problems that we come across with the file system.

To understand this, we will take an example of a university where the data is stored using a file system.

For example, consider that the university has four departments, as shown below.

A new student joining the university has to provide his name, phone number, and personal details at all the departments.

Let’s assume that the name and phone number of the student are Penumacha Vikram Varma and 1234567890.

In the process, he has provided his name as Penumacha Vikram Varma and 1234567890 at the administrative department.

At the administrative department, he is given a unique ID as 3313, and he has to provide this number in all the departments.

He has provided the name, phone number, and ID in the Library as P Vikram Varma, 123456790, and 3313.

If we closely observe, the student has given the name Penumacha Vikram Varma as P Vikram Varma, and there is a mistake in the phone number.

Similarly, at the hostel, he has mentioned the name and phone number as Vikram Varma and 1234567890.

At the sports department, he has mentioned Vikram and 1234567890.

The image below shows the details that the student has provided in all the departments.

From the above image, what can we identify?

The details of the same student’s name, phone number, ID, and other details are there in all the departments.

That creates a lot of repetition and wastes a lot of space.

The data is redundant.

In the DBMS, we store the data in the central space, and every detail is stored only once.

All the details are stored inconsistently in all the departments.

The name and student are different in each department.

These kinds of inconsistencies are possible in file system management.

In DBMS, we can avoid all these kinds of problems.