Database - Introduction to Database - Discussion

What is the meaning of spreadsheet?

Database table has the constraints for each cell (row or column) so, it is restricted to store the data in the database, where as in the spreadsheet no constraints are applicable, you can enter any character it accepts.

Any data in the database it will be stored in the table not in the spreadsheet.

Spread sheet contain rows and columns but Table it contained all these Table is the suitable for that.

What is difference between spreadsheet and table?

Table have some restrictions to store data. But spreadsheet not have restrictions.

The database is in fact an interactive or alive spreadsheet from the computer component perspective. If you look at how all data is processed in a computer, there is a spreadsheet like grid at the root level.

I disagree with the idea that there is a huge difference between a spreadsheet and a table.

The spreadsheet and the table are for all purposes the same.

Whenever attempting to explain what a database IS, to naive persons, I liken it to a spreadsheet, and explain that the rows are records, tuples, and the columns are fields.

Invariably, I explain that the spreadsheet was never intended for data storage use, but rather it was intended to calculate.

The fact is that wherever a database is needed, you'll see a spreadsheet or millions of them populating like rabbits in a computer.

We should just differentiate - a spreadsheet is a FLAT FILE, and a database is generally a layered and connected set of spreadsheets.

Data is stored in tables which contains rows and columns, while data is not stored in spreadsheet.

Database contains spreadsheets and spreadsheets contain table.

Further tables contain rows and columns where data is stored.

Database is a table which the relationship between the row and a column because of it data, so it can't be considered as a spreadsheet. But it set a connection between a row and a column because of it's data which has been stored in it. And moreover spreadsheet can't store the data in it.