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

Instructor Class Description

Time Schedule:

Kalpana Viswanathan
CSS 475
Bothell Campus

Database Systems

Methods for obtaining requirements and designing database systems; differences between hierarchical, relational, and network database designs; techniques for designing and coding effective reporting procedures. Prerequisite: either CSS 263, CSS 341 or CSS 342; CSS 360; may not be repeated.

Class description

This course covers techniques for database design and reporting, as well as database system concepts necessary for implementation and optimization. The first part of the course will cover concepts and techniques useful in database design, reporting, and implementation, including the relational model, relational algebra, Structured Query Language (SQL), and normalization. The second part of the course will cover object role modeling and the phases of database design methodology (conceptual, logical, and physical). Additional topics, such as transaction management, query processing, and current trends will be addressed as time permits.

Student learning goals

Database design

Relational model and relational algebra

Structured Query Language (SQL)

Normalization

Object Role Modeling (ORM)

Phases of database design

General method of instruction

Recommended preparation

Pelase visit http://www.dreamspark.com and download SQL Server 2008 R2 Developer Edition. You can also get the same from the library.

Class assignments and grading

There will be four assignments. There will also be a group project in which you and some fellow students will design and implement a database using SQL Server, including conceptual, logical, and physical design stages and sample queries

Homework: 10% (Turning all of these in is important to your grade.) Quizzes: 15% (Best 3 out of 4 quizzes no make-up quizzes will be given.) Group project: 25% Midterm: 25% Final exam: 25% I use a linear grading scale such that 75% = 2.0, 85% = 3.0, 95% = 4.0.


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 Kalpana Viswanathan
Date: 01/02/2012