What is SI 572?

This course is an introduction to database management systems (DBMS). It covers both theoretical and practical aspects of DBMS, including database design, use, and implementation using the database language MySQL. An essential part of the course is a programming project through which students design and develop a practical database system.

Over the course of the semester, small student groups will work on the design and implementation of a database system. Students learn to examine a client's current batch of data and determine an efficient, user-friendly software system for database manipulation. Where applicable, this system can be web-based. The work is threefold:

1. Identifying the resources and needs of the client
2. Developing an efficient and user-friendly system for the client
3. Providing the clients with the resources necessary to actually use the software!

Why should I suggest a project?

The optimal client for these types of projects are individuals or organizations who have a great deal of data, but no efficient method for dealing with it. Do you have a large Excel spreadsheet? Would your current DB benefit from the ability of a web interface? Do you wish there was a way to personalize the searches you do in your data? Then you are a prime candidate.

Ideal Projects/Clients

Students in SI 572 need to have access to the data they will manipulate. If confidentiality is a concern, they can use fabricated data. Another key criterion is that a client representative should be available to meet with the students (in person or by phone) at least once near the beginning of the semester. In addition, the client representative should be responsive to occasional emails regarding feedback.

Client Benefits

The final results will depend upon the size of the project. The client will receive several reports detailing recommendations for DB creation and/or improvement. In many cases, the final project will include a new DB system with a manual for use.

Contact

Professor Charles (Chuck) Severance
University of Michigan School of Information
csev@umich.edu

Last day to accept fall proposals: August 31
Last day to accept winter proposals: December 31