A database management system is the software system that allows users to create, store and maintain a database and provides required result in form of report to users.
Benefits of DBMS over to file system:
Interface between database and users
A DBMS facilitates to end users to create, insert,view, modify and delete data in a database. The DBMS essentially serves as an interface between the database and end users or application programs, ensuring that data is consistently organized and remains easily accessible.
Controlling Data Redundancy:
In file-system the duplicated copies of the same data are created at many places. But in DBMS, all the data of an organization is integrated into a single database. For example, the student’ record file and the student’s result file contain several items that are identical. When they are converted into database, the data is integrated into a single database so that multiple copies of the same data are reduced to-single copy.
Data Sharing:
Users can share data simultaneously in DBMS.
Integrity Constraints:
Integrity constraints like primary key and foreign key can be applied to database so proper data stored in table and also uniqueness maintains.
TCCI-Tririd Computer Coaching Institute was formed in 2014. Diversified & focused on computer education and project training in various technologies, we specialize in computer course teaching and training to match the wide spectrum of IT applications across globe. TCCI has a faculty with experience of more than 9 years in the field of teaching of computer and IT field. Visit us at www.tccicomputercoaching.com
To Lean More Bopal-Ahmedabad
tccicomputercoaching 