4 - Business intelligence & acces labs (H6)

Question 1

Data

Answer 1

Internal or external

Structured or unstructured

Question 2

Taxonomy of business intelligence

Answer 2

1. Descriptive analytics - understand past & present
2. Predictive analytics - predict future
3. Prescriptive analytics - make decisions or recommendations to achieve the best performance

Question 3

Database system consists of

Answer 3

Data
Software
Hardware
Users

Question 4

zoeken in data dmv:

Answer 4

SQL (structured query language)

Question 5

Database systems allow users to

Answer 5

1. Organise
2. Store
3. Update
4. Delete
5. Retrieve

Question 6

Rational databases allow:

Answer 6

1. Data to be grouped into tables

2. sets relationships between tables

Question 7

Table relationships 3 types

Answer 7

One to one
One to many
Many to many

Question 8

Design grid to add:

Answer 8

Tables
Fields
Sort
Show
Criteria