Teaching method(s) (lecture, discussion, demonstration, lab exercise, etc.):

Informatics Training for CDC Public Health Advisors

Databases and Database Design
Instructor: William A. Yasnoff, MD, PhD July 22, 1997; 1:00pm

Teaching methods: Lecture, discussion; in-class exercise

Topics to be covered:

Basics of Databases

Basics of Database Management Systems

Principles of Relational Databases

Data Models

Database Design Issues

Learning objectives:

By the end of this session, students will be able to:

Explain the purpose of database management systems

Define key database management terms

Understand relational databases and their components

Describe good database design practices

Recognize the limits of their own knowledge

Exercise:

Interactively design and develop a new public health database.

Handouts:

Instructional materials

References & suggested readings

Codd EF: The Relational Model for Database Management. Reading, MA: Addison-Wesley, 1990.

Date CJ: An Introduction to Database Systems, 5th ed. Reading, MA: Addison-Wesley, 1990.

Duncan KA: Health Information and Health Reform. San Francisco: Jossey-Bass, 1994.

Reingruber MC, Gregory WW: The Data Modeling Handbook. New York: John Wiley & Sons, 1994.

Montgomery SL: Object-Oriented Information Engineering. Boston: AP Professional/Harcourt Brace, 1994.