Difference between DBMS and Spreadsheet
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
Share your thoughts in the comments
Please Login to comment...