Chapter 1: Database Concepts – Comprehensive Note
Learning Objectives
By the end of this chapter, you will understand:
Difference between data, information, and knowledge
What a database is, its types, and value in decision-making
Importance of database design
Evolution of databases from file systems
Flaws in file system data management
Components of a database system
Functions of DBMS
1. Introduction to Data, Information & Knowledge
Term Definition Key Points
Unprocessed, needs
Data Raw facts; building blocks of information formatting
Informati
on Processed data with context and meaning Reveals significance
Knowled Body of information + understanding Enables decision-
ge applied to a specific environment making
Summary: Data → Information → Knowledge → Good Decisions →
Organizational Survival
2. Why Databases?
Businesses store massive data (e.g., telecom: trillions of calls)
Need to store, manage, and retrieve data quickly
Database enables efficient storage & instant access
Used in:
Booking holidays
Supermarket purchases
Libraries
Internet
University systems
Video rentals
3. Database vs. DBMS
Term Definition
Databa Shared, integrated structure storing: • End-user data (raw facts) •
se Metadata (data about data)
Metada Describes: • Data characteristics • Relationships between data • Adds
ta value to data
Software that: • Manages database structure • Controls access to
DBMS data • Acts as intermediary between user and database
Key Role of DBMS:
Enables data sharing
Integrates multiple user views
Makes data management efficient & effective
4. Types of Databases
Classificati
on Type Description
One user at a time (e.g., desktop DB
By Users Single-user on PC)
Multiuser Multiple users simultaneously
→ Workgroup
DB Small group or department
→ Enterprise
DB Entire organization
By Centralized Data at one site
Classificati
on Type Description
Location
Distributed Data across multiple sites
Operational
By Usage DB Day-to-day operations (OLTP)
Data Historical data for decision-making
Warehouse (OLAP)
5. Why Database Design is Important
Focuses on structure to store & manage end-user data
Defines expected use of the database
Different DB types → different design approaches
Avoids redundant data
Poor design → Errors → Bad decisions → Organizational failure
6. Evolution: From File Systems to Databases
Stage Description
Manual File Paper folders in cabinets → slow,
Systems cumbersome
Computer File DP specialists created custom programs →
Systems complex
File System Issues Led to DBMS development
7. Problems with File System Data Management
Issue Explanation
Extensive 3GL
Programming Every task needs coding → time-consuming
Ad-hoc
Queries
Impossible No flexibility for new reports
Structural
Dependence Program tied to file structure
Data
Dependence Changes in structure break programs
Same data in multiple files → inconsistency
Data redundancy occurs in file systems when the same data
Data is stored in multiple places, leading to inefficiency, increased
Redundancy storage costs, and potential inconsistencies.
Data • Modification (update one, miss others) • Insertion (can’t
Anomalies add without full record) • Deletion (lose unrelated data)
Security Hard
to Implement Often omitted due to complexity
3GL vs 4GL:
3GL: How to do it (procedural)
4GL: What to do (declarative) → used in modern DBMS
8. DBMS Advantages
Advantage Benefit
Multiple
Improved data sharing users/apps
Better data integration Unified view
Advantage Benefit
Minimized Reduced
inconsistency redundancy
Improved access &
security Faster, safer
Timely, accurate
Better decision-making info
Increased productivity Less manual work
9. DBMS Functions
Function Role
Data Dictionary
Management Defines data & relationships
Data Storage
Management Stores data, forms, reports
Data Transformation Converts logical → physical requests
Security Management Enforces privacy & access rules
Multi-user Access
Control Allows concurrent access
Backup & Recovery Protects against data loss
Data Integrity
Management Enforces rules to prevent errors
Database Languages &
APIs Query language (e.g., SQL)
Communication
Interfaces Network access
10. DBMS Disadvantages
Drawback Explanation
Hardware, software,
Increased costs training
Management
complexity Needs skilled DBAs
Maintaining currency Upgrades required
Vendor dependence Locked into one system
Frequent upgrade
cycles Costly & disruptive
11. Database System Environment (5 Components)
text
1. Hardware
2. Software
├─ OS
├─ DBMS
└─ Applications & Utilities
3. People (Users, Admins, Designers)
4. Procedures (Instructions, Rules)
5. Data (End-user + Metadata)
12. Key Summary Points
Information comes from processed data stored in a database
DBMS manages and protects the database
Good database design = efficient, error-free system
File systems → obsolete due to redundancy, dependence, complexity
DBMS solves file system flaws
Databases evolved to support decision-making in modern organizations