CSE 182 Introduction to Database Management Systems

Concepts, approaches, tools, and methodology of database design and utilization. Topics include the relational data model; modeling relationships between entities; dependencies and normal forms; commercial data management languages such as SQL (defining SQL data, SQL queries and modifications, views, indexes, constraints, and triggers); transactions; stored procedures and functions; access to databases from a programming language (Python); relational algebra; query execution plans; and non-relational data models such as JSON and XML. Involves database application development projects. Students that have taken and passed CSE 180 cannot receive credit for CSE 182.