Objective 2: Explain how files and databases are used in organizations

Question 1

Organize

Answer 1

Databases are used to hold information that is useful in an organization and it may be used to organize or arrange data in such a way that will improve the efficiency in data response in an organization.

Question 2

Store

Answer 2

A computerized database is used to store data in tables.

Question 3

Search & Retrieve

Answer 3

Databases allows organizations to locate and retrieve information
quickly through use of given criteria, such as specific key terms.

Question 4

Eliminate Redundancies

Answer 4

Databases are helpful in eliminating redundancies thus, removing repetition of data.

Question 5

Data Mining:

Answer 5

Generally, data mining is the process of analyzing data from different perspectives and summarizing it into useful information - information that can be used to increase revenue, cuts costs, or both. For example, companies often use Search Engine Optimization (SEO) techniques to determine and learn about the interests of potential customers. It is then through data mining
that these businesses are able to retrieve and store meaningful information that will allow them to gain or persuade potential customers.

Question 6

Data warehousing:

Answer 6

Is the electronic storage of a large amount of information by a business. Data warehousing is more suitable to support an entire corporation environment. Warehoused data must be stored in a manner that is secure, reliable, easy to retrieve and easy to manage.The purpose of data warehouse is to analyze historical data.

Question 7

Data Mart:

Answer 7

This is the micro version of data warehouse. It is more useful or suitable to support
small organizations with very few departments. Data mart is often built and controlled by a single department within an organization, eg: Technology, sales, finance, marketing, etc.