⚙️ What is a DBMS?

A DBMS (Database Management System) is the software interface that allows users to create, manage, and interact with a database — the “container” for your data.

It handles:

• Data definition and structure
• Data manipulation (CRUD operations)
• Access control and security
• Ensures data integrity, security, and efficient access

Examples: PostgreSQL, MySQL, Oracle

🔗 Relational vs. Non-Relational Databases

Relational Databases

• Store data in tables with rows & columns.
• Tables are related — you can query across them using keys and joins.
• Best when your data is predictable in size and structure, and relationships matter.

Examples: MySQL, PostgreSQL, Oracle

Non-Relational Databases

• Also called NoSQL databases.
• More flexible — can store data as key-value pairs, documents, graphs, or wide-column stores.
• Better for dynamic, flexible, or unstructured data that might change over time.