Understanding Database Fundamentals

What is data?

• Data is a form of currency.

• Data is a physical object.

• Data is a type of software.

• Data is information that is collected and analyzed.

What are the examples of data?

• Boolean data

• Examples of data include numerical data, categorical data, text data, time series data, and image data.

• Graph data

• Spatial data

How is information different from data?

• Information is processed data that has meaning, while data is raw, unprocessed facts.

• Data is always more valuable than information.

• Data and information are the same thing.

• Information is a type of data that is unprocessed.

What are the characteristics of information?

• The characteristics of information include accuracy, relevance, timeliness, completeness, and clarity.

• Informativeness, redundancy, obsolescence, and ambiguity.

• Complexity, subjectivity, inconsistency, and vagueness.

• Accessibility, affordability, popularity, and entertainment value.

Define a database.

• A database is a physical storage device for computer files.

• A database is an organized collection of data that can be easily accessed, managed, and updated.

• A database is a collection of random files without any structure.

• A database is a type of software used for web development.

What are some examples of databases?

• MySQL, PostgreSQL, MongoDB, Oracle Database, Microsoft SQL Server, Firebase, SQLite

• PowerPoint Presentation

• Google Docs

• Excel Spreadsheet

What does processed data mean?

• Processed data is data that has been transformed from its raw form into a more usable format.

• Processed data is data that is only visualized without any analysis.

• Processed data is data that has not been altered from its original state.

• Processed data refers to data that is only stored without any modifications.

Why is context important in information?

• Context is important because it helps to clarify the meaning and relevance of information.

• Context is only necessary for visual information.

• Context only complicates the interpretation of data.

• Context is irrelevant to understanding information.

How does relevance affect decision-making?

• Relevance complicates decision-making by introducing unnecessary details.

• Relevance enhances the quality of decisions by focusing on pertinent information.

• Relevance only matters in group decisions, not individual ones.

• Relevance has no impact on the decision-making process.

What types of data can be stored in a database?

• Only text and numbers

• Images and videos only

• Only structured data like SQL

• Text, numbers, dates, binary data, structured data (e.g., JSON, XML)