PART 01 Database Overview
LESSON 01 File System and DBMS
LESSON 02 Independence and the Three-Level Schema
LESSON 03 Database Systems

PART 02 Data Storage and File Structure
LESSON 04 Database Storage and RAID
LESSON 05 File Design and Storage Structure
LESSON 06 B-Tree, Bitmap, and R-Tree
LESSON 07 Hashing and Scalable Hashing

PART 03 DATABASE DESIGN
LESSON 08 Database Design Process

PART 04 Data Modeling
LESSON 09 Data Modeling
LESSON 10 Entity Types and Relationship Types
LESSON 11: Extended ER Model and Logical Data Model

PART 05 Relational Data Structures
LESSON 12 Definition and Characteristics of Relationships
LESSON 13: Transforming Relations in the ER Model

PART 06 Relational Data Operations
LESSON 14 Characteristics and Types of Relational Algebra
LESSON 15: SEMI-JOIN AND OUTER JOIN
LESSON 16: Characteristics and Types of Relationship Interpretation

PART 07 Relational Database Language
LESSON 17 SQL and Data Definition Language
LESSON 18 Data Manipulation Basics
LESSON 19 Advanced Data Manipulation Language
LESSON 20 Creating and Manipulating Views
LESSON 21: Insert SQL, Dynamic SQL, and Stored Procedures

PART 08 Data Dependency and Normalization
LESSON 22: Anomalies and Functional Dependencies
LESSON 23 Types of regular forms

PART 09 INTEGRITY AND SECURITY
LESSON 24 Integrity Rules and Triggers
LESSON 25 DATABASE SECURITY

PART 10 Query Processing
LESSON 26 Query Optimization Process
LESSON 27 Internal Shape Conversion Rules
LESSON 28: Implementation and Cost of Relational Algebra Operations
LESSON 29: DATABASE TUNING AND QUALITY

PART 11 RECOVERY
LESSON 30: Transaction and Recovery Principles
LESSON 31 Basic Recovery Techniques
LESSON 32 ADVANCED RECOVERY TECHNIQUES

PART 12 Concurrent Control
LESSON 33 Concurrency Control and Transaction Scheduling
LESSON 34 Transaction Schedule
LESSON 35 Locking Techniques and Deadlocks
LESSON 36: Independence Levels and Advanced Concurrency Control Techniques

PART 13 DISTRIBUTED DATABASES
LESSON 37 Distributed Databases
LESSON 38 Web Databases
LESSON 39 XML

PART 14 Object-Oriented/Object-Relational Databases
LESSON 40 Object-Oriented, Object-Relational Databases

PART 15 Leveraging the Latest Databases
LESSON 41 Data Warehouse
LESSON 42 OLAP
LESSON 43: Data Mining Concepts and Association Rules
LESSON 44 Data Mining Applications
LESSON 45 Big Data
LESSON 46: DATABASE EVOLUTION MODELS

This book analyzes the previous questions for each of the 15 units in total, as well as the previous questions for the National Civil Service Examination Grade 7, National Civil Service Examination Grade 9, Seoul Metropolitan Government Examination Grade 7, Military Civil Service Examination Grade 7, Police Officer Candidate Examination, Supervisor, and Cyber ​​Examination published from the late 2000s to 2025, and distributes them by unit. It also includes explanations for all questions.

In-depth analysis of the latest exam questions and trends
The past exam questions for national, local, military, police, supervisor, and cybersecurity positions from 2010 to 2025 have been thoroughly analyzed and organized to include the relevant content.


Single volume of major university textbooks
We've compiled all the minor concepts scattered throughout major university textbooks and summarized them into explanations for each question.

What has been revised compared to the previous year
2024 Military Service Officer Grade 7, 2025 National Civil Service Officer Grade 9, 2025 National Civil Service Officer Grade 7, 2025 Military Service Officer Grade 7, 2026 (Implementation in 2025) Police Officer, 2025 Second Half Cyber ​​​​Service Career Recruitment Elective Subject (Database Theory)

* Some of the existing problems that contained errors or had unclear intentions have been deleted.
* Most of the existing commentary has been rewritten and numerous visual aids have been added to improve readability.

Acknowledgements

The technical and theoretical background of this textbook is based on the works of Professors Kim Yeon-hee, S. Sudarshan, and Abraham Silverscott.
I sincerely hope that all students who use this textbook will pass their exams.
Finally, I would like to express my gratitude to all the staff at Gian Edu who provided support, both materially and spiritually, in the publication of this book.