Transcript Databases MIS 3353 A. B. Schwarzkopf 305d Adams Hall

Databases
MIS 3353
A. B. Schwarzkopf
305d Adams Hall
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
Concepts
Database Development and Design
SQL using MS/SQL
Management practice for modern
distributed information systems
MS Access application development
Tools
MS/SQL
Database management in the Microsoft engine
MS Access
Data management and program development
using the Access GUI tools
SQL
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
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