What is DBMS?

• A DBMS is the software that manages the database.
• It reads SQL instructions and performs the requested operations.
• Ensures data is stored securely, efficiently, and correctly.

Simple analogy:

• SQL = the language you speak to the database.
• DBMS = the translator and manager that understands your instructions and manipulates the data in the database.

How DBMS Works with SQL:

1. You write an SQL command.
2. DBMS interprets it.
3. DBMS executes it on the database.
4. You get the result (data retrieved, updated, deleted, or inserted).

Key Idea:

• SQL = the language to interact with the database
• DBMS = the system that executes SQL instructions and manages the data