Database management system :an overview

Database Management System




Roopa P C A G B COLLEGE DVG 1

,Database Management System



Unit 1:
INTRODUCTION:

➢ Data: It is a collection of raw facts.
➢ Information: Processed Data has some specific meaning.
➢ Database: It is a collection of related information
➢ Database Management System: It is defined as a software system that
allows the user to define, create and maintain the database and provide
control access to the data.
Example: MYSQL, ORACLE, MONGODB, MICROSOFT SQL
SERVER.

APPLICATION OF DBMS:

# Business Applications
➢ Customer Relationship Management (CRM): DBMS is used to manage
customer data, interactions, and relationships.
➢ 2. Enterprise Resource Planning (ERP): DBMS is used to manage
business operations, including finance, human resources, and supply
chain management.
➢ 3. E-commerce: DBMS is used to manage online shopping platforms,
including product catalogs, customer information, and order processing.

# Financial Applications
➢ Banking Systems:is used to manage customer accounts, transactions, and
financial data.
➢ 2. Stock Trading Platforms: DBMS is used to manage stock prices, trading
data, and customer portfolios.
➢ 3. Insurance Systems: DBMS is used to manage policyholder information,
claims, and benefits.

# Healthcare Applications
➢ 1. Electronic Health Records (EHRs): DBMS is used to manage patient
medical history, treatment plans, and test results.
➢ 2. Hospital Management Systems: DBMS is used to manage patient
admissions, appointments, and billing information.
➢ 3. Medical Research Databases: DBMS is used to manage large datasets
of medical research, including patient information and clinical trial results.


Roopa P C A G B COLLEGE DVG 2

, Database Management System




# Educational Applications
➢ 1. Learning Management Systems (LMS): DBMS is used to manage
course materials, student grades, and assignments.
➢ 2. Student Information Systems: DBMS is used to manage student
records, including demographics, attendance, and academic performance.
➢ 3. Library Management Systems: DBMS is used to manage book catalogs,
borrowing records, and patron information.

# Government Applications
➢ 1. Census Data Management: DBMS is used to manage large datasets of
census data, including population demographics and socioeconomic
information.
➢ 2. Taxation Systems: DBMS is used to manage taxpayer information, tax
returns, and payment processing.
➢ 3. Law Enforcement Systems: DBMS is used to manage crime data,
suspect information, and case files.

# Other Applications
➢ 1. Social Media Platforms: DBMS is used to manage user data, posts,
comments, and likes.
➢ 2. Gaming Platforms: DBMS is used to manage game data, player
profiles, and leader boards.
➢ 3. Scientific Research Databases: DBMS is used to manage large datasets
of scientific research, including experimental results and observations.

DATABASE SYSTEM:
A database system is a collection of related components that work together to
manage and store data. The main components of a database system are:
# Hardware
1. Computer
2. Storage Devices
3. Input/Output Devices
# Software
1. Operating System
2. Database Management System (DBMS)
3. Application Programs

FILE SYSTEM:


Roopa P C A G B COLLEGE DVG 3