This course provides students with the background to design, implement, and use database management systems. It introduces the structures, requirements, functions, and evolution of database management systems. After covering conceptual data modeling and the entity relationship data model, the course focuses on the relational data model. Students learn commercial relational database implementations using languages such as Query By Example (QBE) and Structured Query Language (SQL). Concepts including data integrity, security, privacy, transaction processing, and ethical stewardship of data are introduced. Students implement a major database application project.
Prerequisite: (CIS 2200 & ZICK/ZKTP stdnt grp) or (STA BA Plan with 45 credits) Or (TechBus&Internet Business Minor & CIS 2200 & BUS 2000 or equivalent) or [CompSci-BS major & (CIS 2300 or MTH 3300)]