1. Introduction
A Database Management System (DBMS) is system software for creating and managing databases. It provides users and programmers with a systematic way to create, retrieve, update, and manage data. It serves as an interface between the database and the end-users or application programs, ensuring that data is consistently organized and remains easily accessible.
Why is it important? Without a DBMS, managing large amounts of data would be chaotic, insecure, and inefficient. DBMS ensures data integrity, security, and concurrent access.
2. Key Concepts & Terminology
An organized collection of structured information, or data, typically stored electronically in a computer system.
A collection of related data held in a table format within a database. It consists of columns and rows.
A specific characteristic or property of a table. Example: `Name`, `Age` in a Student table.
A single entry in a table representing a set of related data. Example: `(1, "John", 20)`.
3. SQL Command Classification
SQL (Structured Query Language) commands are grouped into several categories based on their function:
- DDL (Data Definition Language): Defines the structure of the database.
CREATE: Creates a new table/database.ALTER: Modifies an existing database structure.DROP: Deletes a table/database.TRUNCATE: Removes all records but keeps the structure.
- DML (Data Manipulation Language): Manages data within tables.
INSERT: Adds new rows.UPDATE: Modifies existing rows.DELETE: Removes specific rows.
- DQL (Data Query Language): Retrieves data.
SELECT: Fetches data from the database.
Advantages
- Reduced Data Redundancy: Minimizes duplicate data.
- Data Integrity: Ensures accuracy and consistency.
- Data Security: Control access to data.
- Better Data Sharing: Multiple users can access data simultaneously.
Disadvantages
- Cost: High initial setup and maintenance cost.
- Complexity: Requires skilled personnel to manage.
- Performance: Can be slower than file systems for simple tasks.
Summary
In this experiment, we set up a DBMS environment and explored the fundamental building blocks of a database: Tables, Columns, and Rows. We learned that DDL commands build the skeleton (structure), while DML commands add the flesh (data). Mastering these basic commands is the first step toward becoming a database administrator or developer.