Outline & Objectives

Course OutlineThis course will cover the fundamental concepts and several principles of Database design and Database system implementation. The goal of this course is to provide the practical knowledge about database desgin and implementaing database system S/W. This course will cover ER-modelling, Normalization theoty, Concurrency Control, Back up & Recovery.
Learning ObjectivesThe purpose of this course is to understand the functions and concepts of various software modules that make up a database system, and to acquire the basic knowledge to design a database in various application environments by acquiring various techniques and concepts for efficient database design.

Textbooks & References

TitleAuthor(s)PublisherYearISBN
Database LearningEuikyung HongSaengneung Publishing House2014
Fundamentals of Database SystemsElmasri/NavatheAddison Wesley20040-321-12226-7

Evaluation Criteria

Mid Term30%
Final Term40%
Assignments20%
Presentation5%
Attendance5%

Lecture Schedule

WeekLecture Topics and Contents
Week 1Fundamental Concepts of Database System
Week 25 Steps of Database Desgin
Week 3Introduction to Physical Storage
Week 4ER-modelling and Relational DB Design
Week 5How to use ER-Diagram
Week 6Fundamental Concepts of Relational Data Model
Week 7Relational Algebra and Calculus
Week 8Midterm Exam and Project Check
Week 9Functional Dependency and Normalization
Week 101st, 2nd, 3rd Normalization
Week 11How to use SQL
Week 12How to use SQL
Week 13Index file and B-tree Index
Week 14B-tree Index Addition/Deletion
Week 15Multi-dimensional Index and Hash Table
Week 16Final Exam and Project Evalation