DBMS Basics
Computers · DBMS मूल बातें
📋Quick Overview
DBMS (Database Management System) is software for creating and managing databases. A database is an organized collection of data. SQL (Structured Query Language) is used to interact with databases. Types include RDBMS (relational — tables), NoSQL, and Object-oriented DBMS. Popular RDBMS: MySQL, Oracle, PostgreSQL, MS SQL Server.
⭐
SQL = Structured Query Language — used for CRUD operations: Create, Read, Update, Delete
⭐
Primary Key: uniquely identifies each record; Foreign Key: links two tables
📖DBMS Basics
| Concept | Description |
|---|---|
| Table/Relation | Organized data in rows & columns |
| Row/Tuple/Record | Single entry in a table |
| Column/Attribute/Field | Property of data (name, age, etc.) |
| Primary Key | Unique identifier for each row |
| Foreign Key | Links to primary key of another table |
| SQL | Language to query databases |
| Normalization | Reducing data redundancy |
| ACID Properties | Atomicity, Consistency, Isolation, Durability |
📝Key Points
- •Table/Relation: Organized data in rows & columns
- •Row/Tuple/Record: Single entry in a table
- •Column/Attribute/Field: Property of data (name, age, etc.)
- •Primary Key: Unique identifier for each row
- •Foreign Key: Links to primary key of another table
- •SQL: Language to query databases