Fundamentals of Database Management Systems

📋 Course Outline

1. Data vs. Information
2. Database Definition
3. Types of Databases
4. Database Design Importance
5. File System Limitations
6. DBMS Functions
7. Database Environment
8. Data Redundancy Issues
9. Database System Evolution
10. Database Management Challenges

📖 1. Data vs. Information

🔑 Key Concepts & Definitions

• Data: Raw, unprocessed facts such as characters, numbers, images, or symbols that have no context or meaning on their own.
  Example: "12345" or a list of customer names.

• Information: Data that has been processed, organized, or formatted to provide meaning and support decision-making.
  Example: A report showing total sales per month.

• Knowledge: The understanding and insights gained from analyzing and interpreting information, enabling informed decisions.
  Example: Recognizing sales trends over time to forecast future demand.

• Data Dependence: The reliance of data access and processing on the structure of data files, leading to inflexibility and complexity.
  Example: Changes in file structure require modifications in all programs accessing the data.

• Data Redundancy: The unnecessary duplication of data across multiple storage locations, often causing inconsistency.
  Example: Same customer data stored in different departmental files.