Skip to content
Related Articles

Related Articles

Difference between DBMS and Spreadsheet

View Discussion
Improve Article
Save Article
  • Difficulty Level : Basic
  • Last Updated : 03 Sep, 2020
View Discussion
Improve Article
Save Article

1. Database Management System (DBMS) :
DBMS i.e, Database Management System is a set of programs to access the data which gives information about a particular enterprise. It performs operations like: creation, insertion, deletion, updating and retrieval of information. It is a general purpose software system that facilitates the process of defining, constructing and manipulating databases for various applications. It inter-relates the data.

Example –
MySQL, PostgreSQL, Microsoft Access.

2. Spreadsheet :
A file that exists of cells in rows and columns and can help arrange, calculate and sort data is known as Spreadsheet. It can have a numeric value, text, formulas and functions. It features columns and rows to keep inserted information legible and simple to understand. It is an electronic graph sheet.

Example –
Microsoft Excel, Lotus 1-2-3.

Difference between DBMS and Spreadsheet :

It is a collection of inter-related data.It is an electronic graph sheets with rows and columns.
It stores and retrieve the data.It stores and analyzes the data.
It provides support for data organizing and selecting.It provides support for complex calculations.
DBMS capacity is only limited by the computer.Spreadsheets hold limited amount of information.
It is more towards the linkage and organization of data.It is more towards calculations.
It can do simple calculations.It can do simple data organizing and selecting.
Efficient data handling.Inefficient data handling.
Example: MySQL, PostgreSQL, Microsoft Access.Example: Microsoft Excel, Lotus 1-2-3.

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!