ICS322 – Database Management Systems

Welcome to ICS322 Database Management Systems

Instructor: Dr. Seung Hwan Kang (Ken)

2 / 2011

Provisional schedule:

Tuesday 12:00-2:00 p.m. PC301

Thursday 12:00-2:00 p.m. PC301

Course

ICS322 Database Management Systems 3 (2-2-5) credits

Prerequisite: ICS220 Data Structures and Algorithm Analysis
Course Description
This course introduces the concepts and techniques of database management systems. Key concepts will explore the application of information technology as a management productivity tool and the use of application programs to improve productivity.

Course Objectives

On successful completion of this subject, students should be able to:

  • demonstrate an understanding of fundamental database concepts, the typical database system components and functions;
  • understand the role of high-level conceptual data modeling in database design and develop the ability to design and implement conceptual schemas for database applications;
  • demonstrate knowledge of the relational database model and its basic characteristics and the relational algebra;
  • develop the ability to use SQL to create a database and specify retrieval queries and develop skills in database application development.

Reading Material

Required textbook

  • Abraham Silberschatz, Henry F. Korth and S. Sudarshan (2010) Database System Concepts, 6th edn., McGraw-Hill.

Supplementary reading materials

  • H. Garcia-Molina, J.D. Ullman, J. Widom. (2009) Database Systems: The Complete Book, 2nd ed., Prentice Hall
  • Jeffrey A. Hoffer, Mary B. Prescott and Heikki Topi (2009) Modern Database Management, 9th edn., Prentice Hall.
  • R. Elmasri, S. B. Navathe (2011) Fundamentals of Database Systems, 6th edn., Prentice Hall.
  • Raghu Ramakrishnan and Johannes Gehrke (2003) Database Management Systems, 3rd edn., McGraw-Hill.

Any readings and references are recommended only and are not intended to be an exhaustive list. Students are encouraged to use the library catalogue and databases to locate additional readings.