Information Access Management

MIS 5113 Summer 2003, Tulsa

Course Overview

Course Syllabus

Workbook

Week 1 *************************************************

Friday, 7/18/03 & Saturday, 7/19/03

Introduction

Introduction

Sustem Development

Strategic Frameworks for Project Justification

Modeling

Basic Modeling: ERD's and DFD's

Whitten, Chapter 8: Data Modeling and Analysis

Whitten, Chapter 9: Process Modeling

SQL in MS Access

SQL Tutorial Using MS Access

SQL Assignment, Due Friday, July 26, 2003

Database for use with the Access assignment above

Homework (due 7/25/03) - Read Whitten Chapters 8 & 9

Homework (due 7/25/03) - Modeling, Workbook p. 4 (UR Moving Company). Draw an ERD.

Week 2 *************************************************

Friday, 7/25/03 & Saturday, 7/26/03

Rules for DFD processing

Homework (due 8/01/03) - Modeling, Workbook # 7-16. Draw ERD's.

Week 3**************************************************

Friday, 8/01/03 & Saturday 8/02/03

Quiz 1 (Friday) Strategic justification, SQL, ERD's and DFD's

Design Level Documentation (from draft text, Van Horn et. al.)

Normalization

Functions of a DBMS

Sourcing Projects

The Acquisition Process

Week 4 **************************************************

Friday, 8/08/03 & Saturday 8/09/03

Managing IT Personnel

Quiz 2 (Saturday)

******************************OLD STUFF****************************

Classroom solutions from 7/27