Module 8.1- Introduction to Databases & the Value of Data

Question 1

What is a Database?

Answer 1

• a database is an organised collection of data that can be accessed, managed, and updated efficiently
• designed to store large volumes of information in a structured way, allowing users to retrieve specific pieces of data when needed
• play a key role in almost every digital system you interact with, from websites to banking systems

Question 2

The Value of Data vs Information

Answer 2

• Structured Organisation- data is stored in tables or other organised formats that make retrieval quick and easy
• Efficient Data Management- databases allow multiple users to access, update, and manage data simultaneously without conflicts
• Scalability- databases can handle vast amounts of data, making them ideal for both small and large organisations
• e.g. think of a database as a digital filing cabinet where every piece of data is neatly stored in labeled folders, making it easy to find exactly what you’re looking for

Question 3

Difference between Data & Information

Answer 3

• Data refers to raw facts or figures without context; could be a collection of numbers, names, dates, or even more complex data like sensor readings
• e.g. you have a list of numbers like 5, 10, and 15- by themselves, these numbers don’t tell you much
• Information is data that has been processed, analysed, or organised in a way that provides meaning or value
• when data is transformed into information, it becomes useful for decision-making
• e.g. if you know that these numbers represent daily sales figures, and you calculate the total or average sales for the week, you’ve turned raw data into valuable information that can guide business decisions
• data on its own doesn’t help much, but when a database processes and organises it, it becomes information that can inform business strategies, optimise operations, or enhance customer experiences

Question 4

Database vs Spreadsheet

Answer 4

• Spreadsheets- a spreadsheet is a grid-based tool (like Microsoft Excel or Google Sheets) used for organizing and calculating data
• great for smaller datasets and simple calculations, but as your data grows in size and complexity, managing it with a spreadsheet becomes cumbersome

Best for:
- individual projects, simple calculations, and lightweight data storage

• Databases- a database, on the other hand, is designed to handle large amounts of structured data
• unlike a spreadsheet, a database can manage relationships between different sets of data, allow multiple users to access it at the same time, and ensure data integrity

best For:
- large datasets, managing complex data relationships, and multi-user environments

Question 5

Database vs Spreadsheet (part 2)

Answer 5

• Data Volume- databases are built to handle massive datasets, whereas spreadsheets can become slow and unmanageable as data grows
• Multi-User Access- databases allow multiple users to access and modify data simultaneously without conflicts, whereas spreadsheets often struggle with version control and simultaneous editing
• Data Integrity- databases enforce strict rules (like using primary and foreign keys) to ensure data accuracy and consistency
• spreadsheets are more prone to human error, especially when used for large or complex data
• e.g. if you’re tracking daily expenses, a spreadsheet might be sufficient- but if you’re managing customer records for a business with thousands of clients, a database is the better choice due to its ability to handle complex queries and relationships between different datasets