Search | Directories | Reference Tools
UW Home > Discover UW > Student Guide > Course Catalog 

Instructor Class Description

Time Schedule:

Russell C. Fish
I S 480
Seattle Campus

Database Management

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.

Class Description

Robust access to enterprise data is a key concern for every organization. This course focuses on the design of database schemas and the implementation of database systems. To effectively develop database applications, a thorough understanding of database terminology, data modeling methods, and structured query language (SQL) is necessary. When a complete, robust design is available, the implementation process begins. Issues surrounding database development provide valuable insight into the modeling phase, as well as positive feedback for future projects.

This course covers both of these issues by providing a solid understanding of the database modeling and design process, and by offering students the opportunity to design small but useful applications using the Microsoft Office suite of tools, and in particular Microsoft Access 2000.

Recommended preparation

This course assumes that the student has successfully completed IS300 (Introduction to Information Systems) and IS320 (Fundamentals of Application Programming). A moderate to high level of comfort with the Visual Basic programming language is assumed, and limited instruction on basic programming issues (material covered in chapters 1-9 of Burrows and Langford) is provided.

Class Assignments and Grading

Database development/programming assignments in Access/VBA

The course grade is determined using the percentages below: Assignments: 35% First Exam: 30% Second Exam: 35%

The information above is intended to be helpful in choosing courses. Because the instructor may further develop his/her plans for this course, its characteristics are subject to change without notice. In most cases, the official course syllabus will be distributed on the first day of class.
Additional Information
Last Update by Russell C. Fish
Date: 01/04/2002