What is the basic difference between spreadsheets and databases?

Answer 1

think of databases as being an entity that contains multiple spreadsheets (tables) that are related to one another.

example: Company X has a database of its customers. one table might have customer names and contact information. The column headings of this table might be: CustID, CustLastName, CustFirstName, CustEmail, CustPhone, CustAddress. (*note: "CustID" a unique number assigned to a customer is needed in case of more than one customer that happens to share the same exact name)

A second table could exist (eg: customer purchase history) that is related to the first table in that they both have a column in common: CustID, PurchaseNumber, ProductNumber, ProductName, NumberOfUnitsSold, Unit price.

Because both tables contain the column CustID, you would be able to connect a customer's contact info with their purchase history. For example, if you're shopping on Amazon or Alibaba, when you finalize your purchase, you will see on your screen summary information showing what you are purchasing and your shipping address information. They both can show on screen because the tables are connected, or "related," to one another by a common column of CustID.

Answer 2

Although several people can say they are similar, the truth is that no resemblance.
We can say that the data is stored in table form, by columns and rows, but there comes their similarity.
A database is a collection of tables that are related, with ability to operate a large volume of data, organize, compare, consult.

Answer 3

Databases are much more efficient.

Answer 4

The databases can keep your data with more security than spreadsheets, avoiding you to lose data in your daily tasks.

Answer 5

In sql you have a protocol for accessing datas but in spreadsheet this future isn't general

Answer 6

thanks to all