Information Technology for Business: Database, Blogging & Networks

This assignment solution delves into various aspects of information technology relevant to business operations. It begins by differentiating between database management systems and spreadsheets, highlighting their respective applications in data tracking and analysis. The importance of data cleansing in maintaining high data quality within a data warehouse is discussed, emphasizing its role in extraction, transformation, and loading processes. The solution defines a data warehouse as a relational database designed for querying and analysis, contrasting it with transactional databases. It also elucidates the concept of business blogging as a marketing tactic to enhance online visibility. Furthermore, it distinguishes between intranets, used for internal communication and resource sharing, and extranets, which extend access to business partners and vendors. The document concludes with a list of references used in compiling the information.

Running head: INFORMATION TECHNOLOGY FOR BUSINESS
Information Technology for Business
Name of the Student
Name of the University
Author’s note

1INFORMATION TECHNOLOGY FOR BUSINESS
1. Database Management Systems versus Spreadsheets
A database application could be used for selecting the desired application. One of the
major points of difference between the spreadsheet applications and database is that the
information stored within spreadsheets could be performed within a file system while data stored
within a data is quickly accessible with some commands, which are quickly addressable.
The examples are:
 It is easy to track a list of data and also be able to create “What-if” scenarios. They would
also be used for the creation of graphs and charts based on the data.
 The use of spreadsheets have become powerful for the purpose of data management.
2. Cleansing of Data
The cleansing of data would mean a process of ensuring that the data would be kept
according to a high standard whenever it would be kept in a data warehouse. This would be an
extremely expensive and a time consuming process. These includes numerous processes that
includes extraction, transformation and loading of data. The process of cleansing of data would
be mainly executed within the area of staging of data (Manning 2015).
3. Data Warehouse
A data warehouse could be defined as a relational database that would be designed for the
purpose of querying and analysis rather than their use for the processing of transactions.
The data warehouse differs from a transactional database as it contains some historical
data that would be resultant from the transactional data. It could also include data derived from
other sources.

2INFORMATION TECHNOLOGY FOR BUSINESS
4. Blogging
Business blogging could be defined as a marketing tactic, which makes use of blogging
for the purpose of making a business and the related website to be much more visible on the
online platform. A business blog could be defined as a marketing channel, which would help in
supporting the growth of the business.
5. Intranet and Extranet
Intranet could be defined as a network that would be used only by employees within an
organization. It could be used as a purpose of sharing the information of a company and the
computing resources among their employees. The primary purpose is for facilitating the way of
communication and trading within an organization and their business partners.
An extranet is a private network, which makes use of Internet technology and the system
of public communication for sharing the business information with the suppliers, partners,
vendors and other businesses (Chen and Kamal 2016).

3INFORMATION TECHNOLOGY FOR BUSINESS
6. References
Chen, W. and Kamal, F., 2016. The impact of information and communication technology
adoption on multinational firm boundary decisions. Journal of International Business
Studies, 47(5), pp.563-576.
Manning, A., 2015. Cleansing Your Data. In Databases for Small Business (pp. 145-165).
Apress, Berkeley, CA.