MIS 5113 Information Access Management Fall, 2000
Norman, OK
INSTRUCTOR: A. B. Schwarzkopf
305D Adams Hall
(405)3255703 Office or
(405)364-3893 Home
e-mail:
web site www.ou.edu/class/aschwarz/
Text: The Concepts of Database Management, Pratt and Adamski, Course Technology, 2000. ISBN 0-619-00057-0
A Guide to SQL Using ORACLE, Pratt, Course Technology, 1998. ISBN 0-7600-6923-8
MIS 5113/MIS3353: Workbook, Fall 2000, Database. Available at Crimson and Cream Copy Shop in the OU Union
A VB text to be specified.
Modern information systems are geared to providing users access to information when they need it in whatever form they want. Many MIS professionals have full time careers designing and managing databases and the associated access programs that they require. We will begin this course covering the basics of relational database design and data retrieval. You will learn how to use entity models to design a database, write SQL code to access it and use a modern graphical database development tool to create the database.
End user computing is used in modern MIS literature to refer to any computer system in which the use does some of the coding. Primary examples of this kind of system are decision support systems and data warehouses. The methods for developing and managing DSS systems apply to the wider class of EUC systems. These methods include extracted subject area databases ("data warehouses"), prototyping development techniques, and information center organizations. You will use the methods of DSS to structure the development of access systems for data and develop a prototype system using MS Visual Basic.
The course will include practical exercises that familiarize students with modern databases and high level reporting languages. This project is typical of the EUC life cycle in which a programmer must develop a database, build batch retrieval programs and then automate them with menus. You will do this in small project teams of 2-3 people. The project has several deliverables. None of them alone are particularly hard but they all depend on each other. IT IS ESSENTIAL THAT STUDENTS KEEP UP.
PowerPoint slides that will be presented in class can be obtained from my web site: www.ou.edu/class/aschwarz. The slides currently posted are the ones I used for this course last year. As I make changes I will update the slide sets and date the web page so you can tell when updates have been posted. We will use this location to coordinate schedules and activities.
Grades will be based on 1 test, various in class exercises and projects, and a final examination. We will discuss relative weights in class.
Any student in this course who has a disability that may prevent him or her from fully demonstrating his or her abilities should contact me personally as soon as possible so we can discuss accommodations necessary to ensure full participation and facilitate your educational opportunities.
MIS 5113, Information Access Management
Approximate Schedule
Week / Date / Topic / Chapter Assignment / HomeworkDatabase Management
1 / 8/23 / Intro / DB Management, Ch. 1,2
2 / 8/30 / Data Modeling 1 / DB Management, Ch. 6 / · SQL Relationship Queries
· DB Mgt, Ch 2, Premiere 10-19
3 / 9/6 / Data Modeling 2 / · Baby-Sitter Exercise
· E/R 1 Exercises
4 / 9/13 / Normalization / DB Management, Ch. 5 / · E/R 2 Exercises
5 / 9/20 / Physical Design / DB Management, Ch 3
Guide to SQL, Ch. 1-4 / · Normalization Exercises
6 / 9/27 / DB Management, Ch. 4
Guide to SQL Ch. 5, 6 / · SQL Ch. 3, Premiere Products (even)
· SQL Ch. 4, Premiere Products (even)
7 / 10/4 / Functions of a DBMS / DB Management, Ch. 7 / · SQL Ch. 5, Premiere Products (even)
8 / 10/11 / Management Issues / DB Management, Ch 8, 9 / · SQL, Ch 6, Premiere Products (even)
9 / 10/18 / Catch Up / · Design Project 1.
10 / 10/25 /
Quiz
Information Access11 / 11/1 / Data Warehousing / · VB-1 Exercise
12 / 11/8 / Dialog 1 / · MDBMS Exercise
13 / 11/15 / Dialog 2 / · VB-2 Exercise
11/22 /
Thanksgiving
14 / 12/29 / Management / · Design Project 215 / 12/6 /