what is the advantage of DBMS over normal file system
Answers
Answered by
0
Advantages of DBMS
There are several advantages of database management systems. Chief among them are data redundancy and consistency, data sharing, integrity restrictions, and greater security.
Imagine we have a student named Jamie Wallis enrolled in a class of 300 in a school of 2,343 students. There are various pieces of information we need to store about this child and their class. A school will record personal details, like name, address, guardian, guardian contact details, emergency contact, date of birth, subjects studied, and more. In a flat file system, the student personal details table for Jamie's class alone would probably have 10 or more columns containing 300 rows. But that's not all.Data redundancy occurs when duplicate copies of the same data are stored in different places. With our student, Jamie, the teacher has to repeatedly input the name in every table it needs to appear, including the 11 subject tables. This is data redundancy. With a DBMS, data is stored in a one structured database, and data is inputted once in only one place. As a result, the teacher needs to key in Jamie's name just one time. In all other areas where this child's name is referenced, it will be taken from that particular data repository. The control of data redundancy in DBMS also saves storage space.
There are several advantages of database management systems. Chief among them are data redundancy and consistency, data sharing, integrity restrictions, and greater security.
Imagine we have a student named Jamie Wallis enrolled in a class of 300 in a school of 2,343 students. There are various pieces of information we need to store about this child and their class. A school will record personal details, like name, address, guardian, guardian contact details, emergency contact, date of birth, subjects studied, and more. In a flat file system, the student personal details table for Jamie's class alone would probably have 10 or more columns containing 300 rows. But that's not all.Data redundancy occurs when duplicate copies of the same data are stored in different places. With our student, Jamie, the teacher has to repeatedly input the name in every table it needs to appear, including the 11 subject tables. This is data redundancy. With a DBMS, data is stored in a one structured database, and data is inputted once in only one place. As a result, the teacher needs to key in Jamie's name just one time. In all other areas where this child's name is referenced, it will be taken from that particular data repository. The control of data redundancy in DBMS also saves storage space.
Answered by
0
because data are scattered in various files and files may be in different format , writing new application problems to retrieve the appropriate data is difficult duplication of data _ redundant data.
Similar questions