Database Systems

Catalog description

This course provides an introduction to modern database systems. It covers conceptual modeling and database design, formal database design theory, relational data model and SQL, query optimization, external hashing and indexing, and transaction processing, etc. In addition, this course provides fundamental theory, and methodologies of Data Mining. Students will be asked to apply the data mining knowledge for real world problem solving. Prerequisites: Undergraduate studies in CS, particularly CS 44200 or its equivalent. Permission of department required. Typically offered Fall Spring Summer. Course Learning Outcomes 1. Understand the fundamental theory and concepts of DBMS, including: Conceptual Design and Entity Relationship Modeling; Relational Algebra and Calculus; Logical Database Design; Using SQL for Data Definition and Manipulation; Physical Database Design and Tuning. 2. Understand the theory and methodologies of Data Mining with a focus on classification and clustering. 3. Develop a real world application program using data mining technologies and skills. View Class Schedule