This course addresses the analysis, design and implementation of relational database applications. The structured query language (SQL) is covered in depth along with standard problem domain and data modeling techniques. Implementation techniques and considerations are discussed and practiced extensively. Key concepts include analysis and design using a standardized notation such as the unified modeling language (UML), data model to logical schema conversion techniques, normalization, client-server architectures and web-based access to database systems (e.g. XML). Additional advanced topics covered include system security, transaction processing, data recovery techniques, and maintaining state for mobile devices. Design projects focus on implementing the key course concepts using state-of-the-art multi-user database software.
