Information Access Management

MIS 5113 Fall 2000


Course Overview

Wednesday, 8/23/00

Course Syllabus

Word Document - Effective Business Communication

PowerPoint Presentation - Information Access Management

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

Homework (due 8/30/00) - 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"

Wednesday, 8/30/00

Instructions (due 9/6/00) - ORACLE Login Instructions

Exercise (due 9/6/00) Guide to SQL, Ch3, Premiere Products Exercises 1 - 23

Exercise (due 9/6/00) - CRUD Planning Exercise

Database Design and Management

PowerPoint Presentation - Fundamentals Data Modeling (Pratt Ch 6)

PowerPoint Presentation - Fundamentals of the SDLC

Wednesday, 9/6/00

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

Word Document - Entity/Relationship Modeling

Exercise (due 9/13/00) Guide to SQL, Ch4, Premiere Products Exercises 1 - 19

Exercise (due 9/13/00) Workbook Problems 6, 7, 10, Pages 9 & 13

Wednesday, 9/13/00

Exercise (due 9/20/00) Guide to SQL, Ch 5, Premiere Products Exercises

Wednesday, 9/20/00

PowerPoint Presentation - Normalization (From Pratt & Adamski))

PowerPoint Presentation - Normalization

Word - Normalization Rules and Examples

Wednesday, 9/27/00

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

Homework - Entity Modeling Exercise 2 (due 9/23/99)

Homework - Problems 1, 2, 3 due 10/4/00

Wednesday, 10/4/00

Wednesday, 10/11/00

PowerPoint - File Organization

Word - Fundamentals of File Organization

PowerPoint - Physical Design Concepts

PowerPoint Presentation - Physical Design

Word - Physical Design

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

Wednesday, 10/18/00

PowerPoint Presentation - Data Resources for Information Access: End User Computing

Visual Basic Introduction

Wednesday, 10/25/00

Mid-Term Exam

Wednesday, 11/1/00

PowerPoint Presentation - Introduction to Data Warehousing

PowerPoint Presentation - Data Warehousing: Building a database to support decision making

PowerPoint Presentation - Data Warehouse Design

Wednesday, 11/8/00

Wednesday, 11/15/00

PowerPoint Presentation - Prototyping

PowerPoint Presentation - Good Coding Practice for Prototyping

PowerPoint Presentation - Structure Development

PowerPoint Presentation - Objects

Wednesday, 11/22/00

Thanksgiving Holiday

Wednesday, 11/29/00

PowerPoint Presentation - Dialog Design 1: Basic Issues

PowerPoint Presentation - Dialog Design 2: Styles

PowerPoint Presentation - Dialog Design 3: User Profiles

PowerPoint Presentation - Good dialog designs

Wednesday, 12/6/00

Final Exam

Later Assignments -----------------------------------------

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

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

SQL statements in a relational DBMS. Coding is done after the physical design step in a real project.

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

SQL Users Guide: SELECT Statements

SQL Programming Assignment: SELECT Statements

END USER COMPUTING: Basic Issues

End User Computing: Development Methodologies

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)