Database management is the foundation of any information systems. In this course, students will have ample opportunity to learn the theoretical concept of relational database in the context of information systems. Database management systems are used to effectively store, access and manipulate data as well as provide data security, data sharing and data integrity. This course emphasizes on both theories and hands-on experiences and most of the concepts will be explained through practical examples. The course work includes a term project in which students are required to design and implement a relational database for business firms. Microsoft ACCESS and PHPMyAdmin will be used as the main software package for students to gain hands-on experience. In-depth tutorials on commercial database management systems including Oracle and SQL Server will be given as well.

CILO-1: Describe the concepts and principles of database systems. CILO-2: Explain how to design Entity Relationship Models (ER-models) to represent database application scenarios. CILO-3: Apply the steps to convert the ER-models to relational tables and formulate SQL queries on data. CILO-4: Use the normalization process to improve the database design. CILO-5: Develop a real database system to help firms to solve practical problems.