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.

In this course, students will build applications that interact with databases. Through programming exercises, students will work with multiple databases and programmatically invoke the advanced database processing operations that are integral to contemporary computing applications. Topics include the database drivers, the data layer, connectivity operations, security and integrity, and controlling database access.

An introduction to the theory and practice of designing and implementing database systems. Current software environments are used to explore effective database design and implementation concepts and strategies. Topics include conceptual data modeling, methodologies, logical/physical database design, normalization, relational algebra, schema creation and data manipulation, and transaction design. Database design and implementation projects are required.