3.14 Database Management System

-

DBMS: -

  • DBMS stands for Database Management System.
  • DBMS is software used to store, organize, manage, and retrieve data easily.
  • DBMS helps businesses to store, protect, organize, and use their data efficiently.
  • It is used in banks, shops, hospitals, companies, and many other organizations.
  • Businesses generate a lot of data every day. DBMS helps them store this data safely and use it when needed.
  • Examples of DBMS: MySQL, Oracle, Microsoft SQL Server, PostgreSQL.

 

Role of DBMS in Business

1. Centralized Data Management: - DBMS stores data in an organized database in one place.

Example: A company can store all employee information in one database.

Benefit: Reduces duplicate data and mistakes.


2. Data Security and Safety: - DBMS protects data from unauthorized users. It also supports backup and recovery.

Example: Only authorized bank employees can access customer account information.


3. Better Decision Making: - DBMS helps businesses generate reports and analyze data.

Example: A shop can find which products are selling the most and plan future purchases.


4. Handles Large Amounts of Data: - DBMS can manage large amounts of data as a business grows.

Example: An online shopping website can store information about millions of customers and orders.

 

Uses of DBMS in Business

1. Banking and Finance: - Banks use DBMS to manage:

  • Customer accounts
  • Bank transactions
  • Loans
  • ATM transactions
  • Fraud detection

Example: When you withdraw money from an ATM, the transaction is recorded and the account balance is updated.

2. Retail and E-Commerce: - Shopping companies use DBMS to manage:

  • Products
  • Stock/inventory
  • Customer details
  • Orders
  • Payments

Example: When a customer buys a product online, the DBMS updates the order and stock information.

3. Healthcare: - Hospitals use DBMS to manage:

  • Patient records
  • Medical history
  • Doctor appointments
  • Billing
  • Treatment details

4. Human Resource Management (HRM): - Companies use DBMS to store:

  • Employee details
  • Attendance
  • Salary information
  • Leave records
  • Performance details

5. Supply Chain Management (SCM): - Companies use DBMS to track goods from suppliers to customers.

Example: A company can check where a product is, how much stock is available, and when it will be delivered.

Popular posts from this blog

2.4 Arrays in c programming

-
Image
  Arrays: - An array is a collection of elements of the same data type stored in contiguous memory locations. It is a derived data type and a homogenous data structure. It is a variable which can store multiple values of the same type under a single variable name, making it easier to manage and manipulate related data. The size of an array is fixed. To access the elements of an array, we use indexes or subscripts accordingly. array index or subscript is used to identify array elements address. Array index or subscript starts with 0 to n-1.   Declaration of an array: - The declaration of an array means telling the compiler to create an array variable and reserving memory for a fixed number of elements of the same data type. Initialization of an array: - Initializing an array means assigning initial values to its elements. Types of arrays: - Arrays are classified based on the number of dimensions they have:             ...
Read more

2.1 Control statements in C programming (sequential & conditional)

-
Image
Control statements in C: - C is a structure-orientated programming language; the statements that are used to control the flow of execution of a program are called control structures. The statements provide a specific order to execute the C program. In C programming, we have four types of control structures. Sequential control structures Conditional control structures Iterative control structures Jumping control structures   1) Sequential control structures: - The C program is a collection of instructions or set of statements which are executed sequentially in a user-specific order. No statement is slipped, and no statement is executed more than once.                   Syntax: -                Flow chart: -                Example: - Output: - 1) Conditional control structures: - It is also known as selection, branchi...
Read more

2.2 Control statements ( Iterative or looping control statements)

-
Image
  3)   Iterative control structures: - Iterative control structure is also called as looping control statements. Looping control statements are used to execute a block of code repeatedly as long as a given condition is true. Instead of writing the same code multiple times, loops help avoid writing repetitive code. Loop declaration and execution can be done in the following ways: Check the condition to start a loop. Initialize the loop with declares a variable. Executing the statements inside a loop. There are three main types of loops in C:                    a)  for loop.                    b)  while loop.                    c)  do while loop.   a) For loop: - For loop a best looping control structure which is used to execute the statement repeatedly as long as a giv...
Read more