DBMS Basics
Computers · DBMS मूल बातें · 12 facts
1
DBMS stands for Database Management System
2
SQL is language used to manage relational databases
3
MySQL, Oracle, PostgreSQL are popular RDBMS
4
Primary Key uniquely identifies each record in a table
5
Foreign Key links two tables together
6
Normalization reduces data redundancy in databases
7
SELECT, INSERT, UPDATE, DELETE are basic SQL commands
8
Table is collection of related data in rows and columns
9
NoSQL databases handle unstructured data (MongoDB)
10
ACID properties ensure database transaction reliability
11
ER diagram shows relationships between database entities
12
Cloud databases store data on remote servers