Skip to content
Related Articles

Related Articles

Improve Article
Difference between DBMS and Spreadsheet
  • Last Updated : 03 Sep, 2020

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 :



DBMSSpreadsheet
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.

Attention reader! Don’t stop learning now. Get hold of all the important CS Theory concepts for SDE interviews with the CS Theory Course at a student-friendly price and become industry ready.

 

My Personal Notes arrow_drop_up
Recommended Articles
Page :