Databases - topic 7

Question 1

What is a database?

Answer 1

A database is a computer application that allows data to be separated into tables and stored.

Question 2

What is a data repository system?

Answer 2

Data Repository is where the data is stored. In a relational database, data is stored in tables (rows and columns) like in an excel spreadsheet.

Question 3

What is a Database Management System?

Answer 3

Database Management System is the application layer that protects the data in the tables

Question 4

What is Garbage in, Garbage out?

Answer 4

some causes of this; customers, different standards, abbreviations, dodgy sources

Question 5

potential business effects resulting from low quality information include

Answer 5

• Inability to accurately track customers
• Difficulty identifying valuable customers
• Inability to identify selling opportunities
• Marketing to nonexistent customers
• Difficulty tracking revenue
• Inability to build strong customer relationships