Week 2 - Organising Data and Database Applications

Question 1

What are the three levels of hierarchy in a data model?

Answer 1

1. Data Item - the lowest level and cannot be divided any further
2. Data Element - a logical collection of data items
3. Data Structure - a logical collection of data elements

Question 2

What is the name of the term that defines what is used for data storage in organisations?

Answer 2

Database Management System (DBMS)

Question 3

What are the five fundamental database structures?

Answer 3

1. Relational
2. Hierarchical
3. Network
4. Object-orientated
5. Multi-dimensional

Question 4

What are the four characteristics of “Big Data?”

Answer 4

1. Volume
2. Velocity
3. Variety
4. Veracity

Question 5

What is the benefit of analysis of Big Data?

Answer 5

To uncover hidden patterns, trends and relationships in data

Question 6

What can be found in a data warehouse?

Answer 6

Data that has been extracted from internal operational databases, from transactional systems of an organisation, plus web transactions and other external data.

Question 7

What use is a Data Warehouse to a manager and other decision makers?

Answer 7

It allows them to carry out on the spot analytics to support business decision making.