Introduction to Databases

Introduction to Databases explains how data is stored, organized, managed, retrieved, and protected using database systems.

Computer Awareness Introduction to Databases Competitive Exams

Introduction to Databases explains how data is stored, organized, managed, retrieved, and protected using database systems. Databases are used in banking, schools, hospitals, railways, online shopping, government portals, mobile apps, and almost every modern information system. This chapter is useful for computer awareness, IT basics, competitive exams, and digital literacy.

What is a Database?

A database is an organized collection of related data that can be easily stored, searched, updated, and managed. Instead of keeping information randomly, a database stores data in a structured form.

For example, a school database may store student names, roll numbers, classes, marks, attendance, fees, and exam results. A bank database stores customer details, account numbers, transactions, balances, and loan information.

Quick idea: A database stores data in an organized way, and a DBMS helps users create, manage, update, and retrieve that data.

Term	Meaning	Example
Data	Raw facts and figures	Name, age, marks, mobile number
Database	Organized collection of related data	Student database, bank database
DBMS	Software used to manage databases	MySQL, Oracle, MS Access
Table	Data arranged in rows and columns	Students table, Products table
Record	One complete row of data	One student's details
Field	One column or attribute	Name, Roll Number, Marks

“A database gives structure to data and makes information easy to find.”

Computer Awareness Tip

Key points

A database stores organized data.
DBMS means Database Management System.
Tables store data in rows and columns.
A row is called a record.
A column is called a field.
SQL is commonly used to work with relational databases.

database DBMS table record SQL

Visual Understanding

These diagrams show how databases store information and how users interact with database systems.

Database Structure

A database usually contains multiple tables related to a particular application or organization.

Table, Rows, and Columns

Tables are the most common way of storing data in relational databases.

User, DBMS, and Database

A DBMS acts as a bridge between the user or application and the actual database.

Simple SQL Query Idea

SQL commands help users create, insert, update, delete, and retrieve data.

Important Concepts and Examples

Database

A structured collection of related data stored for easy access and management.

Student database
Bank database
Hospital database
Library database

DBMS

Software that helps create, maintain, update, secure, and retrieve data from databases.

MySQL
Oracle Database
MS Access
SQL Server

Table

A database object that stores data in rows and columns.

Students table
Employees table
Products table
Orders table

SQL

Structured Query Language used to work with relational databases.

Create table
Insert data
Update data
Retrieve data

Record

A complete row in a table representing one item, person, or transaction.

One student
One employee
One bank transaction
One product order

Field

A column in a table that stores a particular type of data.

Name
Roll number
Mobile number
Email address

Primary Key

A field that uniquely identifies each record in a table.

Student ID
Employee ID
Account number
Order ID

Foreign Key

A field used to link one table with another table.

Student ID in marks table
Customer ID in orders table
Department ID in employees table
Book ID in issue table

Rule: Database stores the data. DBMS manages the database. SQL is used to communicate with relational databases.

Types of Databases

Type	Meaning	Example / Use
Relational Database	Stores data in tables with rows and columns	MySQL, Oracle, SQL Server
Flat File Database	Stores data in a simple file format	CSV file, text-based records
Hierarchical Database	Stores data in tree-like parent-child structure	Older business systems
Network Database	Allows complex many-to-many relationships	Advanced legacy systems
Object-Oriented Database	Stores data as objects	Engineering and complex data applications
NoSQL Database	Stores data in flexible formats such as documents or key-value pairs	MongoDB, Redis, Cassandra
Cloud Database	Database hosted and accessed through cloud platforms	Azure SQL, Amazon RDS, Google Cloud SQL
Distributed Database	Database spread across multiple locations or servers	Large enterprise and global systems

Exam approach: For basic computer awareness, relational database is the most commonly asked type because it uses tables, rows, columns, keys, and SQL.

Common SQL Commands

Command	Purpose	Simple Example
CREATE	Creates a database object such as table	`CREATE TABLE students (...);`
INSERT	Adds new records into a table	`INSERT INTO students VALUES (...);`
SELECT	Retrieves data from a table	`SELECT * FROM students;`
UPDATE	Modifies existing records	`UPDATE students SET marks = 90;`
DELETE	Removes records from a table	`DELETE FROM students WHERE id = 1;`
ALTER	Changes table structure	`ALTER TABLE students ADD email VARCHAR(100);`
DROP	Deletes a database object	`DROP TABLE students;`

Important: In real systems, commands like DELETE and DROP must be used carefully because they can remove data.

Common Types of Questions

Definition Questions

Questions asking the meaning of database, DBMS, table, record, and field.

What is database?
What is DBMS?
What is record?
What is field?

SQL Questions

Questions based on SQL commands and their uses.

SELECT
INSERT
UPDATE
DELETE

Key Questions

Questions based on primary key, foreign key, and unique identification.

Primary key
Foreign key
Candidate key
Unique key

Database Type Questions

Questions based on relational, NoSQL, cloud, and distributed databases.

Relational database
NoSQL database
Cloud database
Distributed database

Exam approach: Remember the basic chain: data → database → DBMS → table → row/record → column/field.

Quick Identification Bank

MySQL

Used to create and manage relational databases.

Category: DBMS

Students Table

Stores student records in rows and columns.

Category: Table

Student ID

Uniquely identifies a student record.

Category: Primary Key

SELECT

Used to retrieve data from a database table.

Category: SQL Command

Tip: In exams, MySQL, Oracle, MS Access, and SQL Server are commonly listed as DBMS examples.

Database Learning Flow

This flow helps revise database fundamentals for competitive exams.

Solved Examples

Question	Explanation	Answer
What is a database?	A database is an organized collection of related data that can be stored, searched, updated, and managed efficiently.	Organized collection of data
What does DBMS stand for?	DBMS is software used to create, manage, update, and retrieve data from databases.	Database Management System
What is a record in a database table?	A record is one complete row in a table. For example, one student’s full details form one record.	One row of data
What is a field in a database table?	A field is one column in a table. It stores one type of information such as name, age, or marks.	One column of data
Which SQL command is used to retrieve data?	SELECT is used to fetch or display records from a database table.	SELECT
What is a primary key?	A primary key uniquely identifies each record in a table.	Unique identifier
Is MySQL a DBMS?	Yes. MySQL is a relational database management system used to create and manage databases.	Yes
What is SQL used for?	SQL is used to create, insert, update, delete, and retrieve data from relational databases.	Working with databases

Note: In basic computer awareness, database questions are usually direct and definition-based.

Common Traps and Shortcuts

Common Traps

Confusing database with DBMS.
Confusing row with column.
Thinking SQL and DBMS are the same.
Calling every file a database.
Confusing primary key with foreign key.
Thinking relational database stores data without tables.

Useful Shortcuts

Database stores data.
DBMS manages data.
Table contains rows and columns.
Row means record.
Column means field.
Primary key uniquely identifies records.

Exam approach: For database questions, remember the hierarchy: database contains tables, tables contain records and fields.

Practice

A) Multiple Choice Questions

A database is:
A physical input device Organized collection of data Only a printer program A display device
DBMS stands for:
Data Backup Management Software Database Management System Digital Binary Machine System Data Browser Management System
In a table, a row is also called:
Field Record Database Query
Which SQL command is used to retrieve data?
INSERT SELECT UPDATE DELETE
A primary key is used to:
Delete all records Uniquely identify records Print documents Open web pages

B) Solve the Higher-Order Questions

Explain the difference between database and DBMS with one example each. (Hint: Database stores data; DBMS manages it.)
In a students table, identify three possible fields and one possible primary key. (Hint: Roll number can uniquely identify a student.)
Why is a primary key important in a database table? (Hint: It uniquely identifies each record.)
Write any four SQL commands and their uses. (Hint: SELECT, INSERT, UPDATE, DELETE.)
Give two examples each of relational database systems and NoSQL database systems. (Hint: MySQL and Oracle are relational; MongoDB is NoSQL.)

C) Match the Concept with the Correct Meaning

Concept	Correct Meaning
Database	Organized collection of related data
DBMS	Software used to manage databases
Table	Data arranged in rows and columns
Record	One row in a table
Field	One column in a table
Primary Key	Uniquely identifies each record

Computer Awareness Reminder

Databases are used to store organized data. A DBMS manages databases, SQL is used to query relational databases, and tables store data in rows and columns.

Task: Create one sample students table with five fields and mention which field can be the primary key.

Show Suggested Answers

Multiple Choice

Organized collection of data
A database stores related data in an organized form.
Database Management System
DBMS is software used to create and manage databases.
Record
A row in a table is called a record.
SELECT
SELECT is used to retrieve data from a table.
Uniquely identify records
A primary key uniquely identifies each record in a table.

Higher-Order Questions

Database and DBMS:
A database is an organized collection of related data. Example: student records database. A DBMS is software used to manage the database. Example: MySQL.
Students table fields:
Possible fields are Roll Number, Name, Class, Marks, and Mobile Number. Roll Number or Student ID can be used as the primary key.
Importance of primary key:
A primary key uniquely identifies each record, prevents confusion between similar records, and helps link tables properly.
SQL commands:
SELECT retrieves data. INSERT adds data. UPDATE changes existing data. DELETE removes records from a table.
Database examples:
Relational database systems include MySQL and Oracle Database. NoSQL database systems include MongoDB and Redis.

Concept Matching

Database → Organized collection of related data
DBMS → Software used to manage databases
Table → Data arranged in rows and columns
Record → One row in a table
Field → One column in a table
Primary Key → Uniquely identifies each record

Clue Explanation

A database contains tables. A table contains records and fields. A DBMS manages the database, and SQL is commonly used to communicate with relational databases.

Exam tips

Database stores organized data.
DBMS manages databases.
Table has rows and columns.
Row is called record.
Column is called field.
Primary key uniquely identifies records.

Practice MCQs

Learning Modules