Logo
×

DBMS Tutorial | Database Management System

Database Management System (DBMS) tutorial is all about managing and maintaining the data effectively. Our DBMS tutorial is designed for beginners as well as professionals.

What is Data?

Data is a real-world entity or an object. Data is a distinct piece of information or facts that need to be processed. It can be in any form like text, number, picture, measurements, and bytes.
Example: Ankit, Delhi, 12, 80.

What is Information?

When data are processed, organized, structured, and interpreted in a given context, so as to make them useful and meaningful, they are called information.  
Example: Name - Ankit, City - Delhi, Class – 12, Marks – 80.

what is Information

What is Database?

A database is an organized collection of inter-related data, which helps in insertion, deletion, and retrieval of data efficiently. The database is also used to organize the data or information in the form of tables, views, schemas, reports, etc.


Note: Using the database, you can easily access, update, and delete any information.

Database Management System (DBMS)

A database management system or DBMS is a software used for creating and managing the data in the database easily and effectively. It is basically a set of programs that allow users to store, modify/update, and retrieve information from the database as per the requirements. DBMS also provides security and protection to the database. DBMS acts as a middle layer between the database and the user.

Example: MySQL, MS SQL Server, Oracle, SQL, DB2, Microsoft Access, etc. are different types of database management system.

Characteristics of DBMS

There are various characteristics of a database management system, but following are some important characteristics:

  • A database management system (DBMS) should be able to store any kind of data in a database.
  • Any database management system should be able to support ACID (atomicity, consistency, isolation, durability) properties.
  • The Database management system allows more than one users to access the same database at the same time.
  • Backup and recovery are the two main methods that allow users to protect their data from damage or loss.
  • It provides multiple views for different users in one organization.
  • DBMS follows the concept of normalization to minimize the redundancy of a relation.
  • It provides users query language, using which they can easily insert, retrieve, update, and delete the data in a database.

Advantage of DBMS

  • Minimal data redundancy or data duplicacy.
  • Easy access to data from the database using the query language.
  • DBMS provides backup and recovery methods which create an automatic backup of data from software and hardware failures and restores the data if required.
  • Minimized data consistency.
  • Better data integration.
  • DBMS can applies integrity constraint to the data in the database.
  • DBMS increases consistency and reduces updating errors.

Disadvantages of DBMS

  • A database management system is complex and time consuming to design.
  • Cost of software and hardware is high to run DBMS software.
  • DBMS consumes a large amount of main memory as well as a huge amount of disk space to make it run efficiently.
  • If the database is damaged because of any software or hardware failure, all the application programs will be implicitly affected, which are dependent on it.
  • Initial training is required for all the users and programmers to use the DBMS software.

DBMS Concepts

DBMS ER Model

DBMS Relational Model

DBMS Normalization

DBMS Transaction

DBMS Indexing

Misc

Related Topics

Applications of DBMS

There are various fields where a database management system is used. Following are some applications which make use of the database management system: 1. Railway Reservation System: In the railway reservation...

7 minutes read.

Generalization in DBMS

Generalization in DBMS In the database management system, generalization is a concept combining the common attributes of two or more lower-level entity and form a new higher level with the common...

3 minutes read.

Aggregate Functions in DBMS

Aggregate Functions in DBMS: Aggregate functions are those functions in the DBMS which takes the values of multiple rows of a single column and then form a single value by...

2 minutes read.

DBMS Keys: Primary, Super, Candidate, Foreign

In database management system, keys play an important role which is used for identifying unique records by the combination of one or more fields in the database table. Keys also allows you to...

3 minutes read.

ER Diagram for Company Database in DBMS

What is ER Diagram? An ER diagram (short for Entity Relationship Diagram), also known as an ERD, is a diagram that shows the relationships of a set of entities stored in...

7 minutes read.

Structure of DBMS

DBMS means Database Management System, which is a tool or software used to create the database or delete, or manipulate the database. Query Processor, Storage Manager, and Disk Storage are the...

3 minutes read.

Evaluating DBMS

There are various database management systems available in the market. Each type has its features and can be used for varied purposes. The large number of DBMS makes it difficult...

4 minutes read.

What is a Cloud Database

Cloud computing is the process of commoditizing data storage and processing time using standardized technologies. Cloud databases are databases that are hosted on cloud computing platforms such as Salesforce, GoGrid,...

4 minutes read.

What is a Database

A database is a structured collection of data that is often kept electronically on a computer system. Typically, a database is managed by a database management system (DBMS). Together, the...

9 minutes read.

Advantages of B-Tree in DBMS

A self-balancing search tree is the B-Tree. It is assumed that everything is in the main memory in most other self-balancing search trees (such as AVL and Red-Black Trees). We must...

3 minutes read.

Functional Dependencies

Functional Dependencies (FD) in the relational database management system occurs when one attribute in a relation uniquely determines other attribute in that relation. It describes the relation between the attributes. The term functional...

2 minutes read.

ER Model: Entity Relationship Diagram (ERD) with Examples

ER model stands for Entity-Relationship Model. It is a high-level data model diagram which defines the conceptual view of the database. It is a blueprint or design of a database that will...

2 minutes read.

Disadvantages of DBMS

Disadvantages of DBMS With the vast list of advantages, there are some following disadvantages or limitations of the database management system. 1. High Cost The high cost of software and hardware is the...

2 minutes read.

Serializability in DBMS

Serializability in DBMS Serializability is the concept in a transaction that helps to identify which non-serial schedule is correct and will maintain the database consistency. It relates to the isolation property of transaction in...

3 minutes read.

Network model in DBMS

Network model: The many-to-many relationship between the database constraints is represented hierarchically by the Network Model in DBMS. It is a straightforward and straightforward database model. Due to the Network Model...

4 minutes read.

3- Tier Architecture in DBMS

Three-tier architecture is an application software architecture that arranges the output into three parts or tiers that are:  the presentation tier, where the user interacts with the application; the application...

4 minutes read.

DBMS Tutorial | Database Management System

Database Management System (DBMS) tutorial is all about managing and maintaining the data effectively. Our DBMS tutorial is designed for beginners as well as professionals. What is Data? Data is a real-world...

5 minutes read.

ACID Properties in DBMS

A transaction in a database has the following four properties, known as ACID properties. These properties are used to maintain the consistency of the database in the case of system failure and concurrent...

4 minutes read.

Relational Integrity Constraints

Relational Integrity Constraints are the set of rules that can be used to maintain the data integrity during an insert, delete and update operations into a table. These constraints are checked in the...

2 minutes read.

Levels of Locking in DBMS

There are several levels of locks that can control the access to the elements stored at various levels in the Database. There can be multiple levels of the locks. These...

6 minutes read.