This course surveys the fundamental concepts and theories used in organizing and structuring data that arise in a wide range of contexts (e.g. lab sciences, economic, social services, computing system performance, environmental sustainability). Course topics include data organization theory, basic relational model theory, normalization theory, relational algebra, data quality, data integrity and security, and mapping a data model into a database schema. Students will learn how to construct and use databases while maintaining the security and integrity of data as well as develop AI literacy in the context of data model design, learning how to apply and critique Artificial Intelligence responsibly and ethically. Hands-on assessments are included in this course.

This course builds on the basics of web page development that are presented in Web & Mobile I and extends that knowledge to focus on theories, issues, technologies, exploration of AI tools, as they apply to the design and development of web sites. An overview of web design concepts, including usability, accessibility, information architecture, and design process in the context of the web will be covered. Introduction to web site technologies, including HTTP, web client and server programming, and dynamic page generation from a database also will be explored.