2026-06-07
Ch 10 Recovery and Concurrency PPTX Updated
The latest Ch 10 Recovery and Concurrency Control PPTX has been synchronized to the data folder, and the Week 13 materials row now links both the PDF and PPTX files directly.
Database Systems
Covers DB fundamentals, data modeling, SQL, normalization, and transaction management in a systematic 15-week curriculum.
Textbook: Kim Yeonhui, "IT CookBook: Introduction to Databases", 3rd ed., Hanbit Academy
Lecture slides are self-contained; textbook purchase is optional.
Prerequisite: Basic programming (recommended)
Sync baseline: data/DB시스템 (2026-06-07)
Lecture slides are self-contained; textbook purchase is optional.
Prerequisite: Basic programming (recommended)
Sync baseline: data/DB시스템 (2026-06-07)
Book info: detail page
Announcements
Notices
2026-06-06
Ch 10-11 Late-Term Materials Added
The Ch 10 Recovery and Concurrency Control and Ch 11 Security and Authorization slide decks were uploaded to the data folder in PDF and PPTX formats, and the Week 13-14 rows now link directly to the PDFs.
2026-06-06
Ch 7-11 Exercise Solutions Added
Exercise solution materials for Ch 7 SQL, Ch 8 Database Design, Ch 9 Normalization, Ch 10 Recovery and Concurrency Control, and Ch 11 Database Security were uploaded and linked on the lecture materials table.
2026-05-26
Ch 9 Normalization Materials Added
The Ch 9 Normalization slide deck was uploaded to the data folder in PDF and PPTX formats, and the Week 12 row on this page now links directly to the PDF.
2026-05-17
Ch 8 Database Design Materials Added
The Ch 8 Database Design slide deck was uploaded to the data folder in PDF and PPTX formats, and the Week 11 row on this page now links directly to the PDF.
2026-04-12
Ch 7 SQL Section Materials Added
The Ch 7 SQL materials were reorganized into Sections 1-3 in the data folder, and the Week 9-10 rows on this page were linked to the corresponding PDFs.
2026-04-12
Ch 6 Exercise Solutions PDF Added
The Ch 6 Relational Algebra exercise problem-and-answer deck was uploaded as a PDF and linked on the Week 7 materials row.
2026-03-30
Ch 5 Exercise Solutions PDF Added
The Ch 5 exercise problem-and-answer deck was exported to PDF in the data folder and linked on the lecture materials table.
2026-03-30
Ch 6 Relational Algebra Slides Revised
The Ch 6 Relational Algebra slide deck was updated in both PDF and PPTX formats in the data folder. The materials table continues to serve the latest PDF at the same path.
2026-03-28
Ch 4 Exercise Solutions (PPT Version) Added
The Ch 4 exercise solution files (PPT version) were uploaded from the data folder, and only the PDF was linked on the lecture materials table.
2026-03-28
Ch 6 Relational Algebra Slides Added
The Ch 6 Relational Algebra slide files were uploaded from the data folder, and only the PDF was linked on the lecture materials table.
2026-03-28
Ch 5 Relational Data Model Slides Added
The Ch 5 Relational Data Model slides were uploaded from the data folder and linked on the lecture materials table.
2026-03-28
Ch 3 Exercise Word Version Added
The Ch 3 Database Systems exercise Word-version file was uploaded from the data folder and linked on the lecture materials table.
2026-03-24
Revised Ch 3 Slides and Exercise Solutions Added
The revised Ch 3 Database Systems slide deck and the Ch 3 exercise solutions (PPT version) were uploaded from the data folder and linked on the lecture materials table.
2026-03-23
Ch 4 Data Modeling Slides Added
The Ch 4 Data Modeling (ER Model) slides were uploaded from the data folder and linked on the lecture materials table.
2026-03-02
Preview-Based Policy Sync
Course objectives, front/back-half curriculum (Weeks 1-7 and 9-15), textbook/reference policy, and inquiry guidance were synchronized from the Ch.0 Preview slides.
2026-03-02
Grading Weights Finalized
Quizzes/Homework 10% · Midterm 40% · Final 40% · Attendance & Core Competency 10%.
2026-03-02
Office Hour Update
Office hours are Mon/Tue 11:00-12:00 and Thu 12:00-13:00. Appointment is recommended.
Lecture Materials
Slides & Schedule
Assignments
Evaluation Plan
| Component | Weight | Details | Status |
|---|---|---|---|
| Quizzes & Homework | 10% | Periodic quizzes + SQL practice tasks | Active |
| Midterm | 40% | Coverage: Chapters 1–6 (written) | Planned |
| Final | 40% | Coverage: Chapters 7–11 (written) | Planned |
| Attendance & Core Competency | 10% | 3 late arrivals = 1 absence; from the 3rd absence, 1 point deduction per 2 absences | Applied |
Detailed task schedules will be posted progressively. Files are uploaded to data/DB시스템 first, then linked here.
Operations
Upload & Deadlines
| Item | Last Upload | Next Deadline | Note |
|---|---|---|---|
| Lecture Materials (Preview-Ch11) | 2026-06-07 | Published 3 days before each class | Added Ch 7-11 exercise solutions, Ch 10 recovery/concurrency materials, and Ch 11 security materials; linked Ch 10 PDF/PPTX on the site |
| Quiz/Homework | 2026-03-02 (policy notice) | Announced progressively | Includes SQL practice tasks |
| Midterm | 2026-03-02 (coverage notice) | Week 8 | Coverage: Ch 1-6 |
| Final | 2026-03-02 (coverage notice) | Week 15 | Coverage: Ch 7-11 |
| Date | Category | Change |
|---|---|---|
| 2026-06-07 | Materials | Uploaded the latest Ch 10 Recovery and Concurrency Control PPTX and linked both PDF/PPTX on the Week 13 row |
| 2026-06-06 | Materials | Uploaded the Ch 10 Recovery and Concurrency Control exercise solution files in PDF/PPTX and linked them on the Week 13 row |
| 2026-06-06 | Materials | Uploaded the Ch 10 Recovery and Concurrency Control deck in PDF/PPTX and linked it on the Week 13 row |
| 2026-06-06 | Materials | Uploaded Ch 11 Security and Authorization and Ch 11 Database Security exercise solution files in PDF/PPTX and linked them on the Week 14 row |
| 2026-06-06 | Materials | Uploaded Ch 7 SQL, Ch 8 Database Design, and Ch 9 Normalization exercise solutions and linked them on the lecture materials table |
| 2026-05-26 | Materials | Uploaded the Ch 9 Normalization slide deck in PDF/PPTX and linked the PDF on the Week 12 row |
| 2026-05-17 | Materials | Uploaded the Ch 8 Database Design slide deck in PDF/PPTX and linked it on the Week 11 row |
| 2026-04-12 | Materials | Uploaded the Ch 7 SQL Section 1-3 slide decks in PDF/PPTX and linked them on the Week 9-10 rows |
| 2026-04-12 | Materials | Uploaded the Ch 6 exercise problem-and-answer deck in PDF/PPTX and linked it on the Week 7 row |
| 2026-03-30 | Materials | Exported the Ch 5 exercise problem-and-answer deck to PDF and linked it on the lecture materials table |
| 2026-03-30 | Materials | Uploaded revised Ch 6 Relational Algebra slides in PDF and PPTX |
| 2026-03-28 | Materials | Uploaded the Ch 4 exercise solution files (PPT version) and linked only the PDF on the site |
| 2026-03-28 | Materials | Uploaded the Ch 6 Relational Algebra slide files and linked only the PDF on the site |
| 2026-03-28 | Materials | Uploaded the Ch 5 Relational Data Model slides |
| 2026-03-28 | Materials | Uploaded the Ch 3 exercise Word-version file |
| 2026-03-24 | Materials | Uploaded revised Ch 3 slides and exercise solutions (PPT version) |
| 2026-03-23 | Materials | Uploaded the Ch 4 Data Modeling slides |
| 2026-03-13 | Materials | Uploaded revised Ch 3 slides and Ch 2 exercise solution deck |
| 2026-03-06 | Operations | Added upload/deadline/history tables |
| 2026-03-02 | Grading | Updated to 10/40/40/10 grading policy |
| 2026-03-02 | Policy | Updated office hours (Mon/Tue 11-12, Thu 12-13) |
| 2026-03-02 | Materials | Synchronized Preview and Ch 1-3 files |
Contact
Course Inquiry
Office: Convergence Science Bldg. 2F, Room 24221 (Ext. 2561)
Email: sangdonpark@dju.kr
Office Hours: Mon/Tue 11:00-12:00, Thu 12:00-13:00 (appointment recommended)
Email subject format: [DB][Student ID] Topic