Table 3 illustrates a contrast of the roles between a Spreadsheet and Database
Difference Spreadsheet Database
1 Used to tabulate data and create graphs Used to store data so it can be retrieved by users
2 Cannot hold too much tabulated data Can hold large amounts of data at any time
3
Can be edited by users directly and manually Automatically updated by users indirectly via applications that enter data
4
Usually used in cases of presentations Commonly used in cases where a lot of data needs to be stored
In prospective: A spreadsheet can be used to tabulate data and create graphs based on that data, while a database can be used to store data so that it can be retrieved by users anywhere who have access. When it comes to data storage, a spreadsheet cannot hold too much tabulated data as it is impractical and proves to be difficult for the user to edit it. A database, on the other hand, is meant to hold a large amount of data, and can do so at any given time. When it comes to editing data, the data in a spreadsheet …show more content…
This services are not entered at a timely manner along with check in and checking out of customers and their inventory are not integrated. This lack of Data sharing can result in a loss of profits and resources. As data sharing could encourage different information technology systems and software applications to communicate amongst the different services, exchange data and use the information that has been exchanged across organizational boundaries in order to advance the effectiveness and increase their profits also if their able to integration their data at timely manners to a centralized system from a variety of sources to a condensed form billing customers would before