CH 3

Question 1

Define a database.

Answer 1

A collection of related data that is stored in a central location or in multiple locations (distributed).

Question 2

How are records accessed in a random-access file structure?

Answer 2

Records can be accessed in any order, regardless of their physical locations in storage media. This method is very fast and effective when a small number of records are processed. Records are often stored on magnetic disks, which are random access devices.

Question 3

What are the 5 components of DBMS?

Answer 3

• database engine
• data definition
• data manipulation
• application generation
• data administration

Question 4

What are 3 approaches to setting up a DDBMS?

Answer 4

• fragmentation: data tables are divided among multiple locations (horizontal, vertical and mixed).
• replication: each site stores a copy of the data in the organization’s database
• allocation: combines fragmentation and replication, with each site storing the data it uses most often.

Question 5

What are 3 components of a data model?

Answer 5

• data structure
• operations
• integrity rules

Question 6

Define online analytical processing (OLAP).

Answer 6

Uses multiple sources of information and provides multidimensional analysis. Generates business intelligence.

Question 7

What are 3 popular types of business analytics?

Answer 7

• descriptive
• predictive
• prescriptive analytics

Question 8

What are the 5 V’s of big data analytics? Why is “Value” the most important V?

Answer 8

• volume
• variety
• velocity
• veracity
• value (if there is no value, then the entire process of data collection and analysis would be a waste of resources)