Data base and Business Intelligence Chapter 6

All of the following are issues with the traditional file environment except

• data inconsistency

• inability to develop specialized applications for functional areas

• lack of flexibility in creating ad-hoc reports

• poor security

• data sharing

What is a database?

• grid made up of rows and columns used to store information.

• collection of information that is stored on a computer.

• sheet that has controls that are used to view and enter information

• group of information about a person, thing, or event.

What is a table?

• grid made up of rows and columns used to store information.

• collection of information that is stored on a computer.

• sheet that has controls that are used to view and enter information

• group of information about a person, thing, or event.

What is a record?

• grid made up of rows and columns used to store information.

• collection of information that is stored on a computer.

• sheet that has controls that are used to view and enter information

• group of information about a person, thing, or event.

What is a field?

• one piece of data in a record.

• collection of information that is stored on a computer.

• sheet that has controls that are used to view and enter information

• group of information about a person, thing, or event.

In a table a record is organized in a ------------------

• Table

• Row

• Cell

• Field

Business intelligence (BI) is a broad category of application programs which includes

• Decision support
• Data mining
• OLAP
• All of the mentioned

Business Intelligence include

• Data collection

• Data analysis

• Data Reconciliation

• All of the above

Who create a BI solution

• Data Engineer

• Data Analyst

• Data Scientist

• All of the above

Which module of BI handles data integration

• Data Modeling

• ETL

• Data Gathering

• None of the above