INF 385M - Database Management Principles and ApplicationsSchool of Information - The University of Texas at Austin
Fall, 2006

Course Catalog Description

Database management systems, including architecture, design, administration and implementation. Evaluation and use of database-management systems for microcomputers. (Graduate standing)

Extended Course Description

Principles and practices of database management and database design. Discussion and practice cover database application lifecycle, data dictionaries, relational database design, SQL queries, reports and other interfaces to database data, and documentation. Lectures also cover Web databases, multimedia databases, and ethical and privacy issues associated with database systems. Individual and group projects.

Objectives and Learning Outcomes

At the end of this course, students should:

Specific learning outcomes include being able to:

Outline

This course will concentrate on the fundamentals of database design, but will also include a substantial amount of time on other topics related to database management systems, such as the advantages and disadvantages of database management systems, the roles various people play in developing and managing these systems, and the range of different types of systems.

See the Schedule page for a detailed list of the topics that will be covered each week during the course, as well as any readings or assignments that should be done.

Resources

There is one required text for this course, which is available at the Co-op, online, and at local bookstores:

Hernandez, Michael J. (2003). Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design. Reading, MA: Addison-Wesley.

There are also a handful of required supplementary readings. These are listed on the Resources page and referenced on the Schedule page for the week in which they are to be read.

Several of the assignments in this course require that you use a database application program to create your own database. You will use Microsoft Access for most of these assignments; database software other than Access (e.g., MySQL or FileMaker Pro) might be an option for Assignment 7. We will spend some class time working with Access and MySQL, but you should expect to spend significant time outside class learning how to use these applications. Some resources for learning Access, MySQL, and other database topics are listed on the Resources page.

Assignments and Grading

There are no exams or formal papers in this course; instead, there are seven assignments designed to provide you with the opportunity to apply the concepts covered in class to database design problems similar to what you might encounter in a wide variety of information professions. Assignments 2 and 5 will be done partially in class and will not count towards your final grade. Each of the other assignments is worth a specific number of points, as noted in the assignment details. Your cumulative score on all graded assignments will largely determine your final grade for the course, with each assignment weighted like so:

Assignment 1 10%
Assignment 2 0%
Assignment 3 20%
Assignment 4 20%
Assignment 5 0%
Assignment 6 20%
Assignment 7 25%

Thus, the assignments total 95% of your final grade; the remaining 5% will be based on class participation and other indicators of level of effort.

All assignments are due at the beginning of class on the due date. Late assignments will only be accepted if the instructor grants permission, at least 24 hours before the due date, for the student to turn the assignment in late, on an agreed-upon date. Except in extreme circumstances, late assignments will be docked several points for each day they are late.

Assignments 4 and 7 will be done in groups of two or possibly three people, depending on the scope of the project.

Disability Accommodations

Any student with a documented disability (physical or cognitive) who requires academic accommodations should contact the Services for Students with Disabilities area of the Office of the Dean of Students at 471-6259 (voice) or 471-4641 (TTY for users who are deaf or hard of hearing) as soon as possible to request an official letter outlining authorized accommodations.

©Gary Geisler
geisler@ischool.utexas.edu
Last revised November 15, 2006