Week 1

Question 1

What is database design?

Answer 1

This refers to the activities that focus on the design of the data base structure which will be used to store and manage end-user data.

Question 2

How does data affect survival of businesses?

Answer 2

1. Data can be processed into information
2. Information can be used to reveal the meaning of the data
3. This information can be used to make key business decisions
4. Important decisions can make or break a business

Question 3

What are the benefits of a database?

Answer 3

• Improved data sharing
• Improved dart security
• Improved data intergration
• Minimised data inconsistencies
• Improved data access
• Improved decision making
• Increased end-user productivity

Question 4

What are the types of database classifications?

Answer 4

• Single-user OR multi-user databases
• Workgroup OR enterprise databases (BOTH multi-user databases)
• Centralised OR distrbuted (decentralised) databases
• Cloud Databases
• General purpose OR discipline specific
• Operational OR Analytical (most common classification)
• Structured data OR unstructured data

Question 5

What are online analytical processing (OLAP) tools?

Answer 5

These work together to provide an advanced data anlysis environemnt for retriving, processing and modedlling data from the data warehouse.

Question 6

What is social media?

Answer 6

Refers to the web and mobile tech that enables “anywhere, anytime and ways on” human interactions

Question 7

What are the components of an analytical database?

Answer 7

The analytical processing front-end

The data warehouse - this is a specialised data base what store data in a format optimised for decision making

Question 7

What are the components of an analytical database?

Answer 7

The analytical processing front-end

The data warehouse - this is a specialised data base what store data in a format optimised for decision making

Question 8

What is metadata?

Answer 8

It is data about that data within a database