LIS 751.01

Database Management

Tom Corrigan, Instructor

Thursdays

6-9 pm

Contact Information:

Voice Mail: 847 604 1645

Course Description:

An introduction to database concepts, database design, and database implementation. Examines the role of data in the library/information environment and the application of database principles in information storage and handling. Students will have an active role in the analysis and design of a database system.

Required Texts:

Roff, Jason T. 2003. UML: A Beginner's Guide. New York: McGraw-Hill/Osborne. ISBN 0-07-222460-6.

Tittel, Ed. 2002. XML for Dummies, 3rd Edition. Foster City, CA: IDG Books Worldwide, Inc. ISBN 0-76-451657-4.

Course Objectives:

By the end of the course, the student will:

will have a working knowledge of modern relational database theory.
will have analyzed, designed and documented an appropriate database system using the Universal Modeling Language (UML).
will be knowledgeable in the use of Structured Query Language (SQL) for retrieving and presenting data from a relational database.
will understand the increasing role being played by the Extensible Markup Language (XML) and its subcomponents (XSLT, XPath and XQuery) in the database environment.

Assignments and Course Requirements:

Class Participation.

To get the most out of the learning experience, students are expected to have completed required readings and assignments before class and actively participate in the class discussions. Students are expected to contribute to class discussions, to ask questions, and to share experiences with other students.

UML Project.

Students will undertake a group project in the analysis, design and documentation of a database system. The project will serve as a practical learning experience in understanding the various issues in database development and management. The culmination of the project will be an oral presentation, approximately half an hour in duration, to the class.

Grading will be based on both class participation and the UML project. Since class participation will be so important, attendance at all classes will be critical. Likewise, so will successful participation in and completion of the course project.

Course Calendar:

Week 1:	Overview and Excel as a Database Tool
Week 2:	Relational Databases
Week 3:	Relational Databases (cont.) and Introduction to UML
Week 4:	UML: Use Cases
Week 5:	UML: Activity Diagrams
Week 6:	UML: Sequence Diagrams
Week 7:	UML: Collaboration Diagrams
Week 8:	UML: Implementation Diagrams
Week 9:	SQL Concepts and Tools
Week 10:	SQL (cont.) And Intro to XML
Week 11:	XML: Schemas, XPath and XSLT
Week 12:	XML: XQuery
Week 13:	Project Presentations
Week 14:	Review: Putting It All Together