Computer Studies

11. Databases

Introduction to Databases

A database is an organized collection of related data stored in a structured format so it can be easily accessed, managed, and updated. Databases are widely used in modern computer systems to store and manage large amounts of information efficiently.

Organizations such as banks, hospitals, schools, and businesses rely on databases to store records such as customer information, transactions, student details, and inventory data.

Instead of storing information in separate files, databases allow data to be organized in a structured way, making it easier to search, retrieve, update, and analyze.

Data vs Information

Understanding the difference between data and information is fundamental in database systems.

Data

Data refers to raw, unprocessed facts and figures that have not yet been organized or interpreted.

Data may consist of numbers, text, symbols, or measurements.

Examples of data:

Ali
85
Karachi
2025

Individually, these values do not provide meaningful understanding.

Characteristics of data:

• Raw and unorganized
• Lacks context or meaning
• Used as input for processing
• Stored in databases for further use

Information

Information is processed and organized data that has meaning and value.

When data is arranged and interpreted properly, it becomes useful for decision-making.

Example:

Student Name: Ali
Marks: 85
City: Karachi
Year: 2025

This structured form provides clear meaning.

Characteristics of information:

• Processed and meaningful
• Organized and structured
• Useful for analysis and decision-making
• Derived from data

In simple terms:

Data → Processing → Information

Database Concepts

A database is a structured system used to store, organize, and manage related data so it can be easily accessed and manipulated.

In early computer systems, data was stored in separate files using a file-based system. However, this approach had many problems such as duplication of data, difficulty in searching records, and lack of security.

Databases were introduced to overcome these limitations.

Key Features of Databases

Organized Data Storage
Data is arranged in structured formats such as tables, making it easier to manage.

Data Sharing
Multiple users or applications can access the same database simultaneously.

Data Integrity
Databases ensure that stored data remains accurate and consistent.

Data Security
Access to sensitive data can be restricted using authentication and permissions.

Data Independence
Changes in the database structure do not necessarily affect application programs.

DBMS (Database Management System)

A Database Management System (DBMS) is software used to create, manage, and control databases.

It acts as an interface between users and the database, allowing users to store, retrieve, modify, and delete data easily.

Examples of DBMS software include:

• MySQL
• Oracle Database
• Microsoft SQL Server
• PostgreSQL
• SQLite

A DBMS provides tools and commands that help manage large databases efficiently.

Functions of DBMS

Data Storage
DBMS stores large volumes of data in a structured format.

Data Retrieval
Users can search and retrieve specific data quickly using queries.

Data Manipulation
DBMS allows users to insert, update, and delete records.

Data Security
DBMS controls who can access or modify certain data.

Data Backup and Recovery
DBMS provides mechanisms to protect data from loss due to system failure or errors.

Data Integrity
Rules and constraints ensure that stored data remains accurate and valid.

Tables, Records, Fields

Databases organize information using a tabular structure.

Tables

A table is the basic structure used to store data in a database.

It consists of rows and columns, similar to a spreadsheet.

Each table represents a specific type of data.

Example:

Student Table

Records

A record is a single row in a table.

Each record represents one complete set of information about an entity.

Example record:

This row contains all information about one student.

Fields

A field is a single column in a table.

Each field represents a specific attribute of the data.

Example fields in the student table:

• StudentID
• Name
• Age
• City

Each field stores a particular type of data for all records in the table.

Keys (Primary Key, Foreign Key)

Keys are special fields used in databases to uniquely identify records and establish relationships between tables.

Keys help maintain data integrity and prevent duplication.

Primary Key

A Primary Key is a field (or combination of fields) that uniquely identifies each record in a table.

Characteristics of a Primary Key:

• Each value must be unique
• It cannot contain NULL values
• It identifies each record uniquely

Example:

Student Table

Here StudentID is the primary key because each student has a unique ID.

Without a primary key, it would be difficult to uniquely identify records.

Foreign Key

A Foreign Key is a field in one table that refers to the primary key of another table.

Foreign keys create relationships between tables.

Example:

Student Table

Course Table

In the Course Table, the StudentID field is a foreign key that references the StudentID primary key in the Student Table.

This relationship allows data to be connected across multiple tables.

Conclusion

Databases play a critical role in modern information systems by organizing and managing large volumes of data efficiently. Understanding the difference between data and information helps clarify how raw data becomes meaningful knowledge. Concepts such as tables, records, and fields form the structural foundation of databases, while keys such as primary keys and foreign keys ensure accurate identification and relationships between data. Database Management Systems provide the tools required to store, retrieve, secure, and maintain data effectively, making them essential for businesses, organizations, and software applications.