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