Information Access Management

1
Information Access Management

• MIS 5113
• A. B. Schwarzkopf
• 305d Adams Hall

2
Class References

• Text
• Whitten, Bentley and Dittman, Systems Analysis
  and Design Methods, 6the ed. McGraw-Hill-Irwin,
  2003.
• Pratt, A Guide to SQL, 6th ed, Course Technology,
  2003
• Notes and Handouts
• www.ou.edu/class/aschwarz

3
Concepts

• Data Management
• Process Analysis and Design
• Management practice for modern distributed
  information systems

4
Tools

• SQL Server
• Database management in the SQL engine
• MS Access
• Data management using the Access GUI tools
• SQL

5
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

6
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

7
(No Transcript)