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

Instructor Class Description

Time Schedule:

Robert E. Larson
LIS 542
Seattle Campus

Conceptual Database Design

Introduction to relational database theory and technology from an information science perspective. Focuses on traditional transactional database theory, architecture and implementation in a user-centered systems context. Introduces set and graph theory, relational algebra, and data warehouses. Credit/no-credit only. Prerequisite: LIS 511 or LIS 540.

Class description

The course will have two distinct tracks: relational database skills and database theory.

Relational Database Skills

We will cover the techniques and skills of building and using a relational database application using Microsoft Access as the vehicle. A portion of each week will involve working with hands-on tutorial style exercises that will cover the skills required of someone called on to develop and implement a database. SQL querying will be covered in a combined skills and theory module.

Book (Required): Microsoft Office Access 2003: Comprehensive Concepts and Techniques, CourseCard Edition by Shelly, Cashman, Pratt, Last. ISBN: 1-4188-4363-6 Publisher: Thomson Course Technology

Database Theory

Each week will include readings (PDFs), lectures and online discussions of the following topics: systems analysis, information systems, data modeling, process modeling, relational modeling, normalizing a database, database security, client/server database concepts and advantages, XML and related technologies like RFID. There will be individual projects for each major topic.

Book (Required): None All readings will be PDFs or web based. Full list and downloads will be on the course website.

Student learning goals

General method of instruction

Each student will need Microsoft Access 2003 it is a part of Microsoft Office Professional.

We will use the ePost online discussion boards for weekly discussions, peer help and general course communication.

Students will select, or be assigned, a peer review partner to evaluate and offer feedback on all course module projects. The goal is to provide rapid feedback and support. Peer groups will be encouraged to implement IM (Windows Live Messenger) as well as email and ePost to facilitate this communication.

Recommended preparation

Class assignments and grading

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.
Last Update by Robert E. Larson
Date: 11/12/2006