DBMS, Data Cleansing, Data Warehouse, Blogging, Intranet and Extranet

Solutions for Activity 4
1. DBMS will be used when we want to store large amount of records that might be
unmanageable in the spreadsheet form and that task is related to a specific object. Also
we may opt use database management files in cases we want to maintain the records that
are ongoing or those that are used daily. We may use DBMS where our own information
is subject to vary or change May it be changing the address, price change or anything
else. Lastly is DBMS will be applied when generating reports on the basis of the given
information?
2. We do data cleansing before the data is stored in a data warehouse so that we can detect
and correct or even to remove all the corrupted, inaccurate and the duplicated data in a
database. The idea here is to alter the data in any given storage resource to make sure
that the data to be stored is very correct and accurate (Jacob, 2011).
3. A data warehouse is the collection of all related corporate info and the data derived from
all the operational systems and the data sources externally (Geek, 2006).
Data Warehouse database Transactional Database
It is RDBMS with dernormalised table. It is Relational DB with a normalized
table
It is for analysis It is for OLTP
It is subject oriented Is functional data
4. Blogging are those skills that one may need in running and controlling a blog
(Djuraskovic, 2018).
Blogs have so popular and potential in businesses because:
- Blogs have provided very easy ways in which customers can be kept updated
- Have allowed one to build one trust and rapport with a prospect.
- Blogs has been used in making money (Duermyer, 2018).
5. Intranet is that private network that can only be accessed by only the internal people who
are working within a given organization and its purpose is providing a vehicle through
which communication is liked to that of the WWW which pertinent to the organization.
Extranet is also a private network that uses the internet and other methods of