Introduction to DBMS
Definition:
DBMS stands for Database Management System. It is software that helps to store, manage, and
retrieve data in an organized way. It provides an interface between users and the database.
Example:
MySQL, Oracle, MS SQL Server are examples of DBMS used to handle large amounts of structured
data.
Data
Definition:
Data refers to raw facts and figures without context. It has no meaning until it is processed.
Example:
Marks = 85, Name = 'Rahul', Roll No = 101 - these are data values.
Database
Definition:
A database is a collection of related data stored in an organized manner. It allows easy access,
management, and modification of data.
Example:
A student database contains tables for student info, attendance, marks, etc.
Database Management System (DBMS)
Definition:
DBMS is software that allows users to define, create, maintain, and control access to the database.
Example:
Oracle DBMS stores banking transactions, retrieves customer balances, and maintains accounts.
File System VS DBMS
Definition:
File System stores data in separate files manually, while DBMS uses a structured way to store data
using tables and relationships.
Example:
File System - Text files for each student record
DBMS - A student table in MySQL with rows and columns
Application of DBMS
Definition:
DBMS is used in many fields where data needs to be stored, processed, and accessed regularly.
Examples:
1. Banking - Account records and transactions
2. Education - Student records and results
3. Hospital - Patient details and reports
4. Airlines - Ticket booking and schedules
5. Online Shopping - Orders, products, customers
Data Abstraction
Definition:
Data abstraction is the process of hiding internal details of the database and showing only
necessary information to the user.
Example:
A student views marks and name but not how it's stored or where it's located.
Data Independence
Definition:
Data independence means changes in one level of database schema should not affect other levels.
Example:
If physical storage changes (hard disk to SSD), logical and view levels remain unchanged.
Database Schema
Definition:
Schema is the design or blueprint of the database. It describes how data is organized in tables and
relationships.
Example:
A schema may have Student table with (Roll_No, Name, Branch) and Marks table with (Roll_No,
Subject, Marks).
Overall Structure of DBMS
Definition:
The structure of DBMS includes components like users, software, query processors, transaction
manager, and the actual database.
Example:
Users send queries -> Query processor processes them -> Storage manager retrieves data from
DB.
Two-Tier Architecture
Definition:
In two-tier architecture, client directly communicates with the database server.
Example:
A desktop application connects directly to a database server to run queries.
Three-Tier Architecture
Definition:
In three-tier architecture, the client communicates with the application server, which then interacts
with the database server.
Example:
A web application where browser (client) sends request to web server (middle-tier), which fetches
data from DB.
Hierarchical Data Model
Definition:
Data is organized in a tree-like structure. Each child record has only one parent.
Example:
University -> Faculty -> Department -> Students
Network Data Model
Definition:
In this model, data is organized using records and sets, and each child can have multiple parents
(many-to-many relationship).
Example:
A student can enroll in multiple courses, and a course can have multiple students.
Relational Data Model
Definition:
Data is stored in tables with rows and columns. Tables are related using keys.
Example:
Student Table and Marks Table linked using Roll_No as a foreign key.