Which applications are more amenable to using a spreadsheet vs. a relational dat

label Business
account_circle Unassigned
schedule 1 Day
account_balance_wallet $5

Which applications are more amenable to using a spreadsheet vs. a relational database?  Why?

Apr 13th, 2015

Both spreadsheets and databases are used for managing data.  The computer-age brought about these new applications that could perform complex calculations and print out the data.  Currently, Microsoft, Excel, and Lotus 1-2-3 are the most commonly used spreadsheet applications.  Databases organize information on a specific subject utilizing tables of information entered for various purposes.  Data can be gathered by querying, sorting, filtering, etc.  Databases also use records to structure the tables.  Databases can sometimes be trickier to learn for basic applications.

Many companies make use of both databases and spreadsheets.  For example, a company might need to print invoices and track customers' contact information (spreadsheet), but they also need to quickly determine what an increase/decrease in prices of sales would do to the company (database).

Basically, use a database for:

-  information in a large amount that is unmanageable in spreadsheet form

-  maintaining records for ongoing use

-  the subject information changes often (addresses, price, etc.)

-  generating reports

Use a spreadsheet for:

-  crunching numbers and performing automatic calculations  

-  tracking simple lists of data

-  easily creating charts and graphs

-  creating "what-if" scenarios


Apr 13th, 2015

Did you know? You can earn $20 for every friend you invite to Studypool!
Click here to
Refer a Friend
...
Apr 13th, 2015
...
Apr 13th, 2015
Sep 23rd, 2017
check_circle
Mark as Final Answer
check_circle
Unmark as Final Answer
check_circle
Final Answer

Secure Information

Content will be erased after question is completed.

check_circle
Final Answer