SUBJECT- DATABASE
MANAGEMENT
BY – ISHA TRIPATHI
(FACULTY OF COMPUTER SCIENCE AND ENGINEERING)
, UNIT -1 DATABASES AND DATABASE USERS
What is Data ?
Raw facts or information that can be processed or analyzed. It can be
numbers, text, images, etc.
What is Database?
A collection of organized data that can be easily accessed, managed, and
updated. It stores data in a structured way.
What is DBMS (Database Management System) ?
Software that helps in creating, managing, and interacting with databases. It
provides tools for storing, retrieving, and modifying data efficiently. Examples
include MySQL, Oracle, and SQL Server.
, APPLICATIONS OF DBMS
• Banking: Manages accounts, transactions, and financial records.
• Airlines: Handles bookings, schedules, and availability.
• E-commerce: Supports catalogs, orders, and secure transactions.
• Healthcare: Stores patient records and billing.
• Education: Manages student data and course enrollments.
• Telecom: Tracks call records and billing.
• Government: Maintains census and taxation data.
• Social Media: Stores user profiles and posts efficiently.
, CHARACTERISTICS OF DATABASE APPROACH
Centralized Data Storage: Data is stored in a central
location, making it easier to manage and access.
Data Redundancy Reduction: It avoids duplication of data,
which reduces unnecessary storage and inconsistencies.
Data Integrity: Ensures that data is accurate and consistent
by enforcing rules and constraints.
Data Security: Provides controlled access to data, ensuring
only authorized users can access or modify it.
Data Independence: Changes in the database structure
do not affect how data is accessed or used by
applications.
MANAGEMENT
BY – ISHA TRIPATHI
(FACULTY OF COMPUTER SCIENCE AND ENGINEERING)
, UNIT -1 DATABASES AND DATABASE USERS
What is Data ?
Raw facts or information that can be processed or analyzed. It can be
numbers, text, images, etc.
What is Database?
A collection of organized data that can be easily accessed, managed, and
updated. It stores data in a structured way.
What is DBMS (Database Management System) ?
Software that helps in creating, managing, and interacting with databases. It
provides tools for storing, retrieving, and modifying data efficiently. Examples
include MySQL, Oracle, and SQL Server.
, APPLICATIONS OF DBMS
• Banking: Manages accounts, transactions, and financial records.
• Airlines: Handles bookings, schedules, and availability.
• E-commerce: Supports catalogs, orders, and secure transactions.
• Healthcare: Stores patient records and billing.
• Education: Manages student data and course enrollments.
• Telecom: Tracks call records and billing.
• Government: Maintains census and taxation data.
• Social Media: Stores user profiles and posts efficiently.
, CHARACTERISTICS OF DATABASE APPROACH
Centralized Data Storage: Data is stored in a central
location, making it easier to manage and access.
Data Redundancy Reduction: It avoids duplication of data,
which reduces unnecessary storage and inconsistencies.
Data Integrity: Ensures that data is accurate and consistent
by enforcing rules and constraints.
Data Security: Provides controlled access to data, ensuring
only authorized users can access or modify it.
Data Independence: Changes in the database structure
do not affect how data is accessed or used by
applications.
