70 likes | 226 Views
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
E N D
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