Relational Database Management
System (RDBMS) - Detailed NCERT
Notes
🟢 Session 1: Introduction to Databases
Part B, Unit 3: Specific Skills (Database Management)
1. What is Data?
Data refers to raw facts, figures, and statistics collected for analysis or reference (e.g., student
names, marks, addresses).
2. What is a Database?
A Database is an organized collection of structured information, or data, typically stored
electronically in a computer system.
● Purpose: To manage, organize, store, and retrieve data efficiently.
● Analogy: Similar to a digital, organized filing cabinet.
3. Database Management System (DBMS)
A DBMS is software that allows users to define, create, maintain, and control access to the
database. It is the intermediary between the users and the database.
● Examples: MySQL, Oracle, Microsoft Access, PostgreSQL, and Base (in LibreOffice,
which is the focus of the NCERT curriculum).
4. Need for a Database Management System
● Data Redundancy Control: Prevents duplication of data, saving storage space and
avoiding inconsistencies.
● Data Consistency: Ensures the data stored is correct and reliable across all copies.
● Data Sharing: Allows multiple users or applications to access the same data
simultaneously.
● Data Security: Provides mechanisms (like passwords and permissions) to protect data
from unauthorized access.
● Data Integrity: Ensures the data follows predefined rules and constraints (e.g., age
🟢 Session 2: Relational Data Model and RDBMS
cannot be negative).
1. Relational Data Model
The most popular data model used today. In this model, data is organized into two-dimensional
tables, known as Relations.
2. Relational Database Management System (RDBMS)
An RDBMS is a DBMS specifically designed to manage relational databases.
● Key Feature: Data is stored in tables and the relationships between these tables are
defined and maintained.
3. Components of an RDBMS (The Structure)
Component Alternative Name Description
Table Relation The basic building block of an
RDBMS. A collection of related
data organized in rows and
columns.
Row Tuple / Record A single entry in a table,
representing a complete set of
information about one entity
(e.g., one student, one book).
Column Attribute / Field A single vertical entry in a table,
representing a specific type of
data (e.g., 'Student Name',
'Date of Birth').
Cell Data Item The intersection of a row and a
🟢 Session 3: Data Organization in Tables column, holding a single value.
1. Field (Column) Properties
Each column in a table must have specific properties defined:
● Field Name: A unique name identifying the data held in the column (e.g., Roll_Number).
● Data Type: Specifies the type of data that can be stored in the field (e.g., Text, Number,
Date/Time, Currency, Boolean/Yes/No). This enforces data integrity.
● Field Size: Defines the maximum storage size for the data in that field (especially
important for Text data).
2. Data Types (Crucial for Design)
● Numeric: Stores numbers (Integers, Decimals, Currency). Used for calculations.
● Alphanumeric/Text: Stores text, numbers (like phone numbers which aren't calculated),
and special characters.
● Date/Time: Stores calendar dates and time values.
● Boolean/Binary: Stores logical values (True/False, Yes/No, 0/1).
🟢 Session 4: Keys in RDBMS
Keys are vital elements in the RDBMS used to establish relationships between tables and
uniquely identify records.
1. Primary Key
● Definition: A column or a set of columns that uniquely identifies each record (row) in a
table.
● Rule 1 (Uniqueness): The values in the Primary Key column cannot be duplicated.
● Rule 2 (Non-Null): The Primary Key column cannot contain null (empty) values.
● Importance: The Primary Key is the backbone for linking tables and ensuring data
integrity.
● Example: In a Student table, the Roll Number is typically the Primary Key.
2. Composite Key (Candidate Key)
● Definition: A key that consists of two or more columns whose combined values
uniquely identify a record.
● Usage: Used when a single column is not sufficient to guarantee uniqueness (e.g.,
combining FirstName and LastName to uniquely identify a person, though even this might
not be sufficient, hence the need for a generated ID).
3. Foreign Key
● Definition: A column (or set of columns) in one table that refers to the Primary Key in
another table.
● Purpose: To link the two tables and establish a relationship between them.
● Rule: A Foreign Key value in the linking table must either match an existing value in the
Primary Key of the related table or be NULL.
● Example: In a Fees table, the column Student_Roll_Number acts as the Foreign Key,
🟢 Session 5: Objects in a Database (Beyond Tables)
referencing the Roll_Number (Primary Key) in the Student table.
While tables store the data, other objects are used to interact with and present the data:
1. Forms
● Purpose: Provides a user-friendly, graphical interface (GUI) for viewing, entering, and
modifying data one record at a time.
● Advantage: Simplifies data entry for end-users, reducing errors.
2. Queries
● Purpose: Used to retrieve (extract) specific information from the database based on
certain criteria or conditions.
● Core Function: Used for complex filtering, sorting, and performing calculations on data
across multiple tables.
● Language: Often written using SQL (Structured Query Language).
3. Reports
● Purpose: Used to present the data retrieved from tables or queries in an organized,
printed, and formatted manner.
● Feature: Reports cannot be used to modify data; they are purely for output and
presentation.
4. Database Setup Process Summary
1. Define: Identify the entities and their attributes (columns).
2. Design: Create the tables, define data types, and establish Primary and Foreign Keys.
3. Implement: Use RDBMS software (e.g., Base) to create the defined structure.
4. Populate: Enter data into the tables.
5. Utilize: Use Forms, Queries, and Reports to interact with the data.