Databases

1
Databases

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

2
Class References

• Text
• McFadden, Hoffer and Prescott, Modern Database
  Management
• Workbook from Crimson and Cream Copy Shop
• Notes and Handouts
• www.ou.edu/class/aschwarz
• www.ou.edu/database

3
Concepts

• Database Development and Design
• SQL using MS/SQL
• Management practice for modern distributed
  information systems
• MS Access application development

4
Tools

• MS/SQL
• Database management in the Microsoft engine
• MS Access
• Data management and program development using the
  Access GUI tools
• SQL

5
Objectives

• Data Management
• Build an Entity-Relationship model for a
  relational DBMS
• Implement the database in MS/SQL
• 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 Examinations (50)
• In-class, multiple-choice, essay and short answer
• Project and Exercises (15)
• A sequence of deliverables leading to a complete
  information system
• Exam (35)
• In-class, multiple-choice essay and short answer

7
(No Transcript)