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%
Attendance10%

Lecture Schedule

WeekLecture Topics and Contents
Week 1Database Systems
Week 2Relational Data Models and Constraints
Week 3Relational algebra
Week 4Relational algebra
Week 5SQL
Week 6SQL
Week 7SQL
Week 8Midterms
Week 9Database Design and ER Models
Week 10Database Design and ER Models
Week 11Physical Database Design
Week 12Normalization of Relationships
Week 13Views and System Catalogs
Week 14Transaction
Week 15Database Security and Rights Management Final Exams
Week 16RESERVED