Unless otherwise indicated, a grade of C or higher is required for all prerequisite
This course covers database design and the use of database management systems. It
includes an introduction to the relational model, relational algebra, and SQL. It
also covers XML data including DTDs and XML Schema for validation, and an introduction
to the query and transformation languages XPath, XQuery, and XSLT. The course includes
relational design principles based on dependencies and normal forms. Additional database
topics introduced are indexes, views, transactions, authorization, integrity constraints,
triggers, on-line analytical processing (OLAP), and emerging NoSQL (Not only SQL)
databases for cloud and desktop computing.
Grade Option (Letter Grade or Pass/No Pass)
Lecture hours/semester: 48-54
Homework hours/semester: 96-108
Recommended: Eligibility for ENGL 838 or ENGL 848 or ESL 400.