Information Access Management

MIS 5113 Fall 2000, OU Tulsa

Course Overview

Friday, October 6

Course Syllabus

Word Document - Effective Business Communication

PowerPoint Presentation - Information Access Management

Homework (due 8/30/00) - SQL Relationship Queries

Homework - Database Management Chapter 2, Premier Products Queries 10 - 19

Introduction

PowerPoint Presentation - Introduction to Database Management (Pratt, Ch 1)

PowerPoint Presentation - Relational Models (Pratt, Ch 2)

Word - Access Review"

Database Design and Management

PowerPoint Presentation - Fundamentals Data Modeling (Pratt Ch 6)

PowerPoint Presentation - Fundamentals of the SDLC

PowerPoint Presentation - Entity/Relationship Modeling (9/6/00)

Word Document - Entity/Relationship Modeling

PowerPoint Presentation - Normalization (From Pratt & Adamski))

PowerPoint Presentation - Normalization

Word - Normalization Rules and Examples

Friday, October 13, 2000

SQL Exercise (due 10/13/00) Database Management, Ch3, Premiere Products Exercises

E/R Exercise (due 10/27/00) Do all problems in the exercise set below.

Homework - Entity Modeling Exercise 2 (Practice Exercises)

PowerPoint Presentation - Functions of a DBMS (10/21/99)

PowerPoint - File Organization (OMITTED)

Word - Fundamentals of File Organization (OMITTED)

PowerPoint Presentation - Physical Design

Word - Physical Design

SQL statements in a relational DBMS: Supplemental information on SQL

PowerPoint Presentation - SQL Part 1: SELECT Statements (10/01/98)

SQL Users Guide: SELECT Statements

SQL Programming Assignment: SELECT Statements

PowerPoint Presentation - Dialog Design 1: Basic Issues (11/12/98)

Friday, October 27, 2000

Word - MS Access Introduction"

Word - MS Access Advanced FeaturesIntroduction"

Visual Basic Introduction

PowerPoint Presentation - Data Warehousing: Building a database to support decision making (11/4/99)

Omitted Material -----------------------------------------

Project - Soccer Association Database (due 10/25/00)

Homework - Entity Modeling Exercise 1 (due 9/16/99)

Word - Normalization Homework Exercises (10/7/99)

SYSTEMS DEVELOPMENT: SQL

END USER COMPUTING: Basic Issues

PowerPoint Presentation - Data Resources for Information Access: End User Computing (11/04/99)

PowerPoint Presentation - Data Resources for Information Access: End User Computing (11/04/99)

PowerPoint Presentation - Prototyping (11/18/99)

PowerPoint Presentation - Dialog Design 2: Styles (11/17/98)

PowerPoint Presentation - Dialog Design 3: User Profiles (11/17/98)

PowerPoint Presentation - Good dialog designs (-----)

End User Computing: Development Methodologies

PowerPoint Presentation - Prototyping 2 (OMIT)

PowerPoint Presentation - Structure Development (11/19/97)

PowerPoint Presentation - Objects (11/19/97)

End User Computing: Management Practices

PowerPoint Presentation - EUC Management (11/24/98)

PowerPoint Presentation - EUC Situational Leadership (12/3/97)

PowerPoint Presentation - IS Motivational Profiles (12/10/97)

PowerPoint Presentation - Managing IT Personnel (12/10/97)

Word Document - SQL Homework Answers (12/10/97)

PowerPoint Presentation - Telecommunication Principles (12/10/97)