10. Database & DBMS (MS Access Basics)

🔹 10. Database & DBMS (MS Access Basics)

(KPSC Group-C Non-Technical / FDA / SDA – Very Important Topic)

10.1 Introduction to Data & Database

In government offices, huge amounts of information are handled daily, such as:

Employee records

Citizen details

Financial data

Exam results

Beneficiary lists

To manage such large data efficiently, databases are used.

10.2 What is Data?

Definition:

Data is a collection of raw facts and figures that have no meaning by themselves.

Examples:

12345

Ravi

2024

₹5000

These become information only after processing.

10.3 What is a Database?

Definition:

A database is an organized collection of related data stored electronically in a computer system.

Simple Meaning:

A database is like a digital record book where information is stored systematically.

10.3.1 Examples of Databases in Daily Life

Bank customer database

Aadhaar database

School student database

Hospital patient database

📌 Very relevant for government exams.

10.4 Need for Database

Why databases are required:

Stores large data efficiently

Easy retrieval of information

Avoids data duplication

Improves data security

Saves time and effort

10.5 Traditional File System vs Database System

File System

Database System

Data redundancy

Less redundancy

Poor security

High security

Difficult search

Easy search

No central control

Centralized control

📌 Difference-based MCQs are common.

10.6 What is DBMS?

Definition:

DBMS (Database Management System) is software used to create, store, manage, and retrieve data from a database.

Simple Meaning:

DBMS acts as a bridge between users and database.

10.6.1 Examples of DBMS

MS Access

MySQL

Oracle

SQL Server

PostgreSQL

📌 For KPSC, focus mainly on MS Access.

10.7 Functions of DBMS (VERY IMPORTANT)

DBMS performs the following functions:

Data storage

Data retrieval

Data update

Data deletion

Data security

Backup and recovery

Data integrity

📌 Often asked as “Which of the following is NOT a function of DBMS?”

10.8 Advantages of DBMS

Reduces data redundancy

Ensures data consistency

Improves data security

Provides backup and recovery

Supports multiple users

10.9 Disadvantages of DBMS

High initial cost

Requires technical knowledge

Complex system

Needs regular maintenance

📌 Both advantages & disadvantages are exam-relevant.

10.10 Types of Databases (Basic Awareness)

10.10.1 Centralized Database

Stored at one location

Example: Bank server

10.10.2 Distributed Database

Stored at multiple locations

Connected through network

10.10.3 Relational Database (IMPORTANT)

Data stored in tables

Uses rows and columns

Example: MS Access, MySQL

📌 Most KPSC questions are from relational database.

10.11 RDBMS (Relational Database Management System)

Definition:

RDBMS is a DBMS where data is stored in the form of tables and relationships exist between tables.

Examples:

MS Access

MySQL

Oracle

📌 RDBMS is a favorite MCQ topic.

10.12 Basic Database Terms (VERY IMPORTANT)

10.12.1 Table

A table is a collection of rows and columns

Similar to an Excel sheet

10.12.2 Field

Column in a table

Represents one type of data

Example: Name, Age

10.12.3 Record

Row in a table

Complete information about one person

10.12.4 Primary Key

Definition:

A Primary Key uniquely identifies each record in a table.

Example:

Aadhaar Number

Employee ID

📌 Primary key cannot be duplicate or null.

10.12.5 Foreign Key

Used to connect two tables

Refers to primary key of another table

📌 Frequently asked difference: Primary Key vs Foreign Key.

10.13 Data Types (MS Access – Basic)

Text

Number

Date/Time

Currency

Yes/No

AutoNumber

📌 Questions often ask: Which data type is used for dates?

10.14 What is MS Access?

Definition:

MS Access is a database management software developed by Microsoft, used to store and manage data.

10.14.1 Features of MS Access

User-friendly

Table-based

Supports forms and reports

Suitable for small organizations

10.15 Components of MS Access (VERY IMPORTANT)

10.15.1 Tables

Store actual data

Basic building block of database

10.15.2 Queries

Definition:

Query is used to retrieve specific data from one or more tables.

Uses:

Search records

Filter data

Update records

📌 Queries are often compared with filters.

10.15.3 Forms

User-friendly interface

Used for data entry

📌 Forms reduce errors in data entry

10.15.4 Reports

Used to present data

Suitable for printing

Examples:

Salary report

Student result report

10.16 SQL (Basic Awareness)

Definition:

SQL (Structured Query Language) is used to interact with databases.

Basic SQL operations:

SELECT

INSERT

UPDATE

DELETE

📌 No deep SQL coding is asked, only basics.

10.17 Data Integrity

Definition:

Data integrity ensures accuracy and consistency of data in a database.

Types:

Entity integrity

Referential integrity

📌 Integrity is maintained using keys.

10.18 Database Security

Security methods:

Password protection

User permissions

Backup

Encryption

📌 Important for government data safety.

10.19 Backup & Recovery in DBMS

Backup: Copy of database

Recovery: Restoring data after failure

📌 Often linked with cyber safety.

10.20 DBMS in Government Offices

Examples:

Employee payroll system

Pension database

Land records

Exam result systems

📌 Shows practical application – exam-friendly.

10.21 Common MCQ Traps (VERY IMPORTANT)

Question

Correct Answer

DBMS full form-Database Management System

Table row-Record

Table column-Field

Unique identifier-Primary Key

MS Access is-RDBMS

10.22 Previous Year KPSC Question Patterns

Full form of DBMS

Identify database components

Primary key definition

Match table-field-record

MS Access components

10.23 How to Prepare DBMS for KPSC

✔ Learn definitions clearly

✔ Remember key terms

✔ Focus on MS Access

✔ Practice MCQs

✔ Revise tables & keys

✅ Conclusion

Database & DBMS is a high-weightage and easy-scoring topic for KPSC Group-C exams. Questions are direct and concept-based. With clear understanding of basics, scoring full marks is very achievable.