Outline & Objectives
Course Outline | This 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 Objectives | The 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
Title | Author(s) | Publisher | Year | ISBN |
---|---|---|---|---|
Database Learning | Euikyung Hong | Saengneung Publishing House | 2014 | |
Fundamentals of Database Systems | Elmasri/Navathe | Addison Wesley | 2004 | 0-321-12226-7 |
Evaluation Criteria
Mid Term | 30% |
Final Term | 40% |
Assignments | 20% |
Presentation | 5% |
Attendance | 5% |
Lecture Schedule
Week | Lecture Topics and Contents |
---|---|
Week 1 | Database Systems |
Week 2 | Relational Data Models and Constraints |
Week 3 | Relational algebra |
Week 4 | Relational algebra |
Week 5 | SQL |
Week 6 | SQL |
Week 7 | SQL |
Week 8 | Midterms |
Week 9 | Database Design and ER Models |
Week 10 | Database Design and ER Models |
Week 11 | Physical Database Design |
Week 12 | Normalization of Relationships |
Week 13 | Views and System Catalogs |
Week 14 | Transaction |
Week 15 | Database Security and Rights Management Final Exams |
Week 16 | RESERVED |