Components of DBMS – A DBMS software is partitioned into several modules or components and each module or component is assigned a specific operation to perform. While designing a DBMS, its interface must be taken into account with the OS as some of the functions of DBMS are supported by OS to provide basic services…

Components of Database – A database system involves four major components – Data Hardware Software Users   (Components of Database) Data –  Data stored in database system is partitioned into one or more database.  A database is both integrated and shared. By Integrated, means that database can be thought as unification of several distinct data…

DBMS vs File System To understand the difference between DBMS vs File System, we should know the disadvantages of file processing system first. Disadvantages of File Processing System – Duplicate Data – As all files are independent of each other, so, duplicate data may be present in more than one files. Inconsistency – Inconsistency means different copies…

Advantages and Disadvantage of DBMS Advantages  of DBMS – Minimal Redundancy Inconsistency can be avoided Sharing of Data Standards can be enforced Search Capability Integrity Privacy and Security The interface with the Past The interface with the future Physical Data Independent Logical Data Independence Tunability Data Migration Simplicity Powerful User Languages Conflicting requirements can be…

Database and DBMS Introduction Database Database is the collection of interrelated data. or collection of related information stored so that it is available to many users for different purposes. The content of database  is obtained by combining data from all the different sources in an organisation. Database Management System (DBMS)  DBMS is a software used to…