Database

← Previous Next →

A database is an organized collection of data that is stored electronically and can be easily accessed, managed, and updated.
In simple words:
      • A database is a place where data is stored in a structured way.

Real-Life Example
Think of:
   • A school system storing student records
   • A bank storing customer account details
   • An e-commerce website storing product and order information
All of these use databases.
Types of Databases
1️⃣ Relational Database (RDBMS)
   • Data stored in tables
   • Tables have rows and columns
   • Tables are related using keys
   • Uses SQL
   • Example: MySQL, SQL Server, PostgreSQL

Features:
   • Structured format
   • Fixed schema
   • Strong relationships
   • ACID properties (reliable transactions)
2️⃣ Non-Relational Database(NoSQL)
   • Data is not stored in table format
   • Schema is flexible structure
   • Used for large-scale or unstructured data
   • Example: MongoDB

Types of NoSQL:
   • Document-based
   • Key-value
   • Graph
   • Column-based

Example Structure:

Customers Table

| CustomerID |	Name |

Orders Table

| OrderID | CustomerID | Amount |

CustomerID connects both tables.;


🔹 Why Do We Need a Database?
   • Store large amounts of data
   • Fast retrieval of data
   • Data security
   • Data consistency
   • Multi-user access
   • Backup and recovery

Simple Summary:
   • SQL → Language used to manage databases
   • Database → Organized collection of data
   • Relational Database → Data stored in tables with relationships
   • Non-Relational Database → Flexible storage (NoSQL)
   • DBMS → Basic database software
   • RDBMS → Advanced DBMS with table relationships
   • Microsoft SQL Server → Popular RDBMS used in enterprises

← Previous Next →
Topics