Make your own free website on
Robert Morris College

CI-310 : October 4, 2000

CI-310 Information Systems Applications, 3 credits Admin/ General
Wednesday evenings, 6:00 - 8:50 pm Hale 306 Schedule
Instructor: Ed Quigley 724.774.2088
Dept. Head: Dave Wood, Ph.D. 412.262.2788 Links

  • Return Quiz One-Two
  • Return Assignment Three
  • Distribute Quiz Three
  • Collect Personal Project Definitions
  • Distribute Group Project Possibilities


Chapter 6: Managing Data Resources

DBMS: data base management system

Existing Problems with the Traditional File Environment

Solution? The Database!

A collection of data organized to serve many applications efficiently by centralizing the data and minimizing redundant data.

Types of Databases

Designing Databases

Two steps: conceptual design and physical design.
Entity-Relationship Diagram (see figure 6-13)
Streamlining: normalization. 1NF, 2NF, 3NF, 4NF.
Centralized vs. Distributed Databases.

Database Trends

Multidimensional Data Analysis (aka OLAP- online analytical processing) (figure 6-17)
Data Warehousing and Data Marts
A data warehouse is a database that integrates current and historical data throughout the company, from different systems and sources. It permits compilation of a big-view without interfering with existing, disparate legacy operational systems.

A data mart is a subset of a data warehouse in which some of the company's data is placed into a new database for a small, specific group of users.

Hypermedia Databases fields consisting of linked multi-media

Web-Linked Databases.

Management Requirements for DB Systems

Database is a way of life; it is more of an organizational (political and $$$ ) issue rather than a choice between Access and Oracle.

Summary, p. 203- 204.

To Do For Next Class, 10/11/00