David M Kroenke
I S 480
Examines the business need for database processing. Discusses database development and administration, including data modeling, role normalization, use of SQL for DDL, and DML. Students practice converting data models to database design. Covers application development for Web databases, data warehouses, OLAP. Prerequisite: I S 310; may not be repeated. Offered: AWSp.
Revised description: The business need for database processing. Databases vs. lists. Data modeling, entity-relationship model, IDEF1X, and UML. Normalization. Database design. SQL for DDL and DML. Data and database administration. Enterprise-class DBMS products. Web databases. Data warehouses and OLAP. Distributed database processing.
Lectures, in-class and out-of-class group projects, problem solving.
Class Assignments and Grading
Problems solving assignments.
Project quality and exam results. See syllabus on course web site for specifics.