Notes and Study Materials



The file processing system method of organizing and managing data was a definite improvement over the manual system. The traditional file processing system well in data management for a long time.

However, there exist different disadvantages of file system data management.


Problems in the Traditional File System Data management Processing



The different problems with the File System Data management Processing are as follows.

Add a comment



In the article problems with the traditional File Processing System, you have seen the different problems with the existing traditional File Processing system. So, to overcome those problems, the Database Management System was Introduced. 


what is a database management system(DBMS)


"A database management system (DBMS) is a collection of programs that manages the database structure and controls access to the data stored in the database".  

The DBMS serves as the intermediary between the user and the database. The database structure itself is stored as a collection of files, So, we can access the data in those files through the DBMS.

The DBMS receives all application requests and translates them into the complex operations required to fulfill those requests. The DBMS hides much of the database’s internal complexity from the application programs and users.



Database Management SystemDBMS Advantages and Disadvantages


Add a comment

Different Database Types



A DBMS can support many different types of databases. There exist different database types according to the number of users, the database location(s), and the expected type and extent of use.


Different types of databases


Different Types of Databases

1. Different Database Types: Depending On Number of Users


The number of users determines whether the database is classified as single-user or multiuser.


Single User Database:

Add a comment



The term database system refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.

The five major components of database management system are 




Procedures, and



Components of Database Management SystemDBMS


Components of Database Management System(DBMS) with diagram


Add a comment



DBMS performs several important functions that guarantee the integrity and consistency of the data in the database. The most important functions of Database Management System are


Data Dictionary Management,

Data Storage Management,

Data Transformation and Presentation,

Security Management,

Multi user Access Control,

Backup and Recovery Management,

Data Integrity Management,

Database Access Languages andApplication Programming Interfaces and

Database Communication interfaces.


Functions of Database Management System DBMS

Functions of DBMS

Add a comment

What is Data model and the importances of Data Models in DBMS



Data models can facilitate interaction among the designer, the applications programmer, and the end user.

A well-developed data model can even foster improved understanding of the organization for which the database design is developed.  In short, data models are a communication tool.

The Importance of Data Models


The Importance of the Data Modelling

Add a comment

Relationship and types of Relationships in DBMS:



A relationship describes an association among entities. For example, a relationship exists between customers and agents that can be described as follows: an agent can serve many customers, and each customer may be served by one agent.

Data models use three types of relationships: one-to-many, many-to-many, and one-to-one.

Add a comment

Page 1 of 12