Welcome to ICS322 Database Management Systems
Instructor: Dr. Seung Hwan Kang (Ken)
2 / 2011
Tuesday 12:00-2:00 p.m. PC301
Thursday 12:00-2:00 p.m. PC301
ICS322 Database Management Systems 3 (2-2-5) credits
Prerequisite: ICS220 Data Structures and Algorithm Analysis
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.
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.
- 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.