Transcript Information Access Management MIS 5113 A. B. Schwarzkopf

Information Access
Management
MIS 5113
A. B. Schwarzkopf
305d Adams Hall
Class References
Text
Whitten, Bentley and Dittman, Systems Analysis
and Design Methods, 6the ed. McGraw-HillIrwin, 2003.
Pratt, A Guide to SQL, 6th ed, Course
Technology, 2003
Notes and Handouts
www.ou.edu/class/aschwarz
Concepts
Data Management
Process Analysis and Design
Management practice for modern
distributed information systems
Tools
SQL Server
Database management in the SQL engine
MS Access
Data management using the Access GUI tools
SQL
Objectives
Data Management
Build an Entity-Relationship model for a relational
DBMS
Implement the database
Normalize tables
Produce SQL coding to manage data
Application Development
Plan and design an application system
Implement an application in Access
Management Practice
Discuss critical IT management issues
Expectations
Mid Term Examination (40%)
In-class, primarily essay and short answer
Project and Exercises (20%)
A sequence of deliverables leading to a
complete information system
Exam (40%)
In-class, primarily essay and short answer