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.
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-03-30)
Lecture slides are self-contained; textbook purchase is optional.
Prerequisite: Basic programming (recommended)
Sync baseline: data/DB시스템 (2026-03-30)
Book info: detail page
Announcements
Notices
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
| Week | Topic | Material |
|---|---|---|
| 1 | Ch 0 Preview — Course Introduction | Slides |
| 2 | Ch 1 Database Fundamentals | Slides · Lecture Note · Exercise Solutions (PPT Version) · Exercise Solutions (Word Version) |
| 3 | Ch 2 Database Management Systems (DBMS) | Slides · Lecture Note · Exercise Solutions (PPT Version) · Exercise Solutions (Word Version) |
| 4 | Ch 3 Database Systems (Three-Schema Architecture) | Slides · Exercise Solutions (PPT Version) · Exercise Solutions (Word Version) |
| 5 | Ch 4 Data Modeling (ER Model) | Slides · Exercise Solutions (PPT Version) |
| 6 | Ch 5 Relational Data Model | Slides · Exercise Solutions (PPT Version) |
| 7 | Ch 6 Relational Algebra | Slides |
| 8 | Midterm (Ch 1–6) | — |
| 9 | Ch 7 SQL (1) — DDL | Planned (DDL and data types) |
| 10 | Ch 7 SQL (2) — DML | Planned (SELECT/INSERT/UPDATE/DELETE) |
| 11 | Ch 8 Database Design | TBD |
| 12 | Ch 9 Normalization (1NF – BCNF) | TBD |
| 13 | Ch 10 Transactions, Recovery, Concurrency | TBD |
| 14 | Ch 11–12 Security · Big Data · Data Science | TBD |
| 15 | Final Exam (Ch 7–12) | — |
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–12 (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-Ch6) | 2026-03-30 | Published 3 days before each class | Added the Ch 5 exercise-solutions PDF and updated the revised Ch 6 Relational Algebra slides |
| 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-12 |
| Date | Category | Change |
|---|---|---|
| 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