Open In App

Difference between DBMS and Spreadsheet

Improve
Improve
Like Article
Like
Save
Share
Report

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 :

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


Last Updated : 03 Sep, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads