Spreadsheets-databases-what are the differences??

Question

where can we use spreadsheets and where databases??

Answer 1

spreadsheet that would be excel - use spreadsheets to do balance sheets or income statements
database that would be access. - database just holds more room instead of the spreadsheet.

Answer 2

There are 4 properties of a database; without everybody of them, a database might then be in uncomplicated terms a repository of information (like spreadsheets), yet not a database. they are: Atomicity, Consistency, Isolation, and sturdiness. temporarily defined (when you consider which you probably did not ask) they recommend: a chain of strikes can take place with the database without being stricken by different tactics; information is consistent - with none variations with the help of everybody, the techniques may well be examine and re-examine and continually with the comparable outcomes; information may well be locked, with the intention to evade others from updating or examining the comparable information that i'm updating or examining - your strikes take place in finished isolation from others; and the database ensures that the techniques continually modern. With a spreadsheet, some issues may well be available, alongside with consistency and sturdiness. besides the undeniable fact that it would not have isolation, and without it you have not have been given the skill to permit different shoppers to get entry to the spreadsheet, so there's no isolation. in case you probably did enable different shoppers, consistency may well be misplaced, as each replace might overwrite the different person's updates. If this have been prevented, nicely... this spreadsheet may well be a database. (albeit, not an quite useful one - yet meets the definition.)

Answer 3

Phisically, a spreadsheet is a piece of paper with rows and columns for recording financial data for use in comparative analysis. An electronic spreadsheet is a table of values arranged in rows and columns. You can define what type of data is in each cell and how different cells depend on one another. The relationships between cells are called formulas, and the names of the cells are called labels.

A possible definition of database is that a database is a collection of records stored in a computer in a systematic way, so that a computer program can consult it to answer questions. The items retrieved in answer to queries become information that can be used to make decisions.

Answer 4

A spread sheet is well here is one dffinition : The compound word "spread-sheet" came to mean the format used to present bookkeeping ledgers—with columns for categories of expenditures across the top, invoices listed down the left margin, and the amount of each payment in the cell where its row and column intersect—which were traditionally a "spread" across facing pages of a bound ledger (book for keeping accounting records) or on oversized sheets of paper ruled into rows and columns in that format and approximately twice as wide as ordinary paper.

The data base is deffined as : A possible definition is that a database is a collection of records stored in a computer in a systematic way, so that a computer program can consult it to answer questions. The items retrieved in answer to queries become information that can be used to make decisions.

You could sort of think of the data base as the files in a filing cabinet, cross referenced.

Answer 5

You can understand the difference if you will read two wiki articles:
http://en.wikipedia.org/wiki/Spreadsheet
http://en.wikipedia.org/wiki/Database