HC1041 IT for Business: Data Warehousing and Business Applications

This document presents a student's responses to discussion questions related to data warehousing, database management systems, and business applications. It covers the advantages of database management systems over spreadsheets, the importance of data cleansing, the differences between data warehouses and transactional databases, the potential of blogging for businesses, and the purposes of intranets and extranets. The discussion highlights the role of these technologies in improving data management, decision-making, customer engagement, and communication within and between organizations. Desklib offers a platform to explore more solved assignments and resources for students.

Running head: DATA WAREHOUSE
Data warehouse
Name of the Student
Name of the University
Author Note:

2
DATA WAREHOUSING
Discussion activity 4
1. Spreadsheets have become quite powerful for data management. What can be done
with database management systems that cannot be done with spreadsheet
applications? Give 2 examples.
Isolation of data and the duplication of the data are the significant benefits of the database
management systems over the applications.
2. What does it mean to cleanse data before it is stored in a data warehouse?
The storage of the data coming from the different sources in separate applications is done
with the help of the concept of data cleansing. Data cleansing is very much important for the
data which are about to enter the data warehouse1. Data cleansing may be also termed as data
scrubbing, the database administrators of the data ware houses uses this process in order to avoid
any kinds of complexities as it may have a direct negative impact on the overall business.
3. What is a data warehouse? How is it different from a transactional database?
Data ware house is defined as the type of warehouses which stores large amount of structured
and unstructured data from a wide range of sources. The managerial decisions of an organization
can be impacted by the effectiveness of the data warehouses.
The data which are related with the transactions are managed with the help of the
transactional database, rolling back of the data is possible in the transactional databases which
are not followed in the data warehouses.
4. What is blogging, and what potential does it have for businesses?
1 "Internet, intranet, extranet". in , , 2019, <http://bpastudio.csudh.edu/fac/lpress/471/hout/apps/interintraextra.htm>
[accessed 17 January 2019].

DATA WAREHOUSE
Blogging is defined as the type of act of posting content on a blog. It is one of the mediums
through which people can communicate with each other and express their opinions and concerns
about any specific topic.
Bloggers are used by business organizations based on schemes such as the cost per click,
their role help the business organizations in their online marketing’s. Customer engagement in a
business organization can be improved with the help of blogging2. Online visibility is improved
considerably with the help of the blogging.
5. What is an intranet and what purposes does it serve? What is an extranet, and what
purpose does it serve?
Intranet is defined as the type of private network which are there in the business
organizations, it includes the interlinked LAN’s. More than one gateways are important for the
working of the intranet, the accessibility of this network can be determined by the concerned
authorities based on the security and the privacy issues.
Extranet is defined as the type of private network which uses the internet technology and the
telecommunication systems. The extranet is used by the business organizations to deal with their
external stakeholders such as the suppliers and the other business partners.
2 "BBC - WebWise - What are intranets and extranets?", in Bbc.co.uk, , 2019,
<http://www.bbc.co.uk/webwise/guides/intranets-and-extranets> [accessed 17 January 2019].

4
DATA WAREHOUSING
Reference
"BBC - WebWise - What are intranets and extranets?". in , , 2019,
<http://www.bbc.co.uk/webwise/guides/intranets-and-extranets> [accessed 17 January 2019].
"Internet, intranet, extranet". in , , 2019,
<http://bpastudio.csudh.edu/fac/lpress/471/hout/apps/interintraextra.htm> [accessed 17 January
2019].