Database Management System – Study Notes
Educational Reference Guide
This document is prepared as a general educational reference. Examples are simplified for learning
purposes.
Page 1
1. Introduction
A Database Management System (DBMS) is software used to create, store, organize, retrieve, update,
and protect data. A DBMS provides controlled access to information and helps applications work with
large amounts of structured data.
2. Database Models
Common database models include relational, document, key-value, graph, and column-oriented
models. Relational databases organize information into tables and are commonly accessed using
SQL.
3. Tables, Rows, and Columns
A relational table consists of columns and rows. Columns describe attributes such as employee name
or salary. Each row represents a particular record. A well-designed schema gives each field a clear
purpose and appropriate data type.
4. Primary Keys
A primary key uniquely identifies a record in a table. It should be stable and unique. A table normally
has one primary key, which may consist of one column or multiple columns called a composite key.
5. Foreign Keys
A foreign key represents a relationship between tables. It normally references a primary or unique key
in another table. Foreign keys help enforce referential integrity and prevent invalid relationships.
6. SQL Fundamentals
SQL is used to interact with relational databases. SELECT retrieves information, INSERT adds
records, UPDATE changes records, and DELETE removes records. CREATE and ALTER are used to
manage database objects.
7. Filtering and Sorting
The WHERE clause filters rows. ORDER BY sorts results. Conditions can use comparison and logical
operators. Careful filtering is important when working with UPDATE and DELETE statements because
an incorrect condition can affect many records.
8. Joins
Joins combine information from multiple tables. Common types include INNER JOIN, LEFT JOIN,
RIGHT JOIN, and FULL OUTER JOIN. Joins are useful when normalized data is distributed across
related tables.
9. Normalization
Page 2
Normalization is a design technique used to reduce unnecessary duplication and improve consistency.
Common normal forms include 1NF, 2NF, 3NF, and BCNF. Normalization should be balanced with
practical performance requirements.
10. Transactions and ACID
A transaction is a logical unit of database work. ACID represents Atomicity, Consistency, Isolation, and
Durability. These properties help databases maintain reliable results even when multiple operations
occur together.
11. Indexes
An index is a database structure that can improve lookup performance. Indexes are commonly created
on columns frequently used in filtering, joins, and sorting. However, indexes also consume storage and
can increase the cost of data modifications.
12. Backup and Recovery
Database backup strategies protect against accidental deletion, hardware failure, corruption, and other
incidents. Recovery procedures should be tested regularly rather than assuming that a backup alone
guarantees recoverability.
13. Security
Database security includes authentication, authorization, least-privilege access, encryption, auditing,
and secure application design. Credentials should not be hard-coded into source code.
14. Conclusion
A strong understanding of DBMS concepts helps developers and administrators design reliable data
systems. Tables, keys, SQL, joins, normalization, transactions, indexes, backup, and security form an
important foundation for database work.
End of Document
Page 3