Faculty Contact Information:
John G. Meinke
UMUC - Unit 29216
APO AE 09102
meinkej@faculty.ed.umuc.edu
370-6762 DSN
49 (0) 6221 / 37 82 08 Civilian
49 (0) 6221 / 31 58 71 Fax
Home: Heidelberger Weg 2
69181 Leimen - St. Ilgen
49 (0) 6224 / 92 44 71
Class meeting times, weekends of 5/6, 19/20, and 26/27 June; 09.00-17.30
| |
Consultation:
Before and after class sessions
Via email (meinkej@faculty.ed.umuc.edu) which is checked regularly
Via the webboard: http://webboard.ed.umuc.edu/~mis | |
Required Texts and Readings:
| Rob, P., and Coronel, C. (2004). Database Systems: Design, Implementation, and Management (6th ed.). Boston, MA: Course Technology. | |
Supplementary Readings:
The standard for papers in the graduate program is the APA style. All participants in this course and all graduate INSS, MGMT, PUAD, and ECON courses should have a copy of the style guide:
American Psychological Association. (2001). Publication Manual of the American Psychological Association, 5th Edition. Washington DC: Author.
All graduate students should be prepared to utilize the UMUC online library at http://www.umuc.edu/library/.
The library contains a large number of full text academic journals that are free of charge and immediately available. The library homepage also contains a number of links related to improving students' research and writing skills. | |
Recommended Journals:
Publications of the various professional societies (such as ACM -- the Association for Computing Machinery, the IEEE Computing Society, and the various management professional societies) are strongly recommended. In addition, there are many trade journals (such as eWEEK) that MIS professionals should become familiar with, many of these being published both weekly and on-line.
In addition, you may find the following links useful:
Database Journal http://www.databasejournal.com
Up to the Minute News on Databases
http://www.newsnow.co.uk/newsfeed/?name=Databases
Experts Exchange on Databases http://www.experts-exchange.com/Databases/
Data Management Web Magazine http://www.dmreview.com
Data Management Association http://www.dama.org
Data Warehousing Institute http://www.dw-institute.com
Intelligent Enterprise Web Magazine on Databases
http://www.intelligententerprise.com/info_centers/database/
The Data Administration Newsletter http://www.tdan.com
| |
Course Description:
| 3 semester hours credit. Prerequisite: Either INSS 510, INSS 520, INSS 530, or permission of the Program Director. Examines database concepts and practices as they relate to business environments. Various database structures including relational and object-oriented are discussed. Concepts of distributed database architecture are explored. Design, development, and implementation of databases are examined. Organizational issues concerning the implementation of databases and the role of data in the decision-making process are examined. Decision support system architecture is reviewed with emphasis on the database component. Issues of intelligent databases are discussed. A database project is required. | |
Course Goals:
Upon completion of the course, participants should:
1. Understand and apply database concepts and practices
2. Understand relational and object-oriented database models, and how they compare to "traditional" models such as hierarchical and network.
3. Design and implement a relational database.
4. Understand and discuss issues associated with Internet database development. | |
Course Objectives:
At the conclusion of this course the student will be able to:
1. Describe, compare, and use tools of database design development and implementation, such as: Entity Relationship Diagrams (ERD), Relational schema, Table normalization, Structured Query Language (SQL), and ANSI/SPARC 3-level architecture - subschemas.
2. Discuss the advantages and issues of distributed database architecture and two- and three- tier database architectures,
3. Concurrency control and transaction management, .
4. Compare and contrast approaches to Security of databases
5. Define organizational issues and the responsibilities associated with database administration.
6. Discuss the role of data and information in decision making, and techniques such as data mining and data warehousing as used for decision support. | |
Grading Information:
Grades for this course will be assigned as follows:
A 90% +
B 80 – 91%
C 70 – 79%
F Below 70%
Please note that Bowie State University does not use "D" for graduate students. The grade F(a) is used to designate academic failure. F(n) is used to designate failure for non-completion. Grades of Incomplete or Withdrawal are governed by UMUC-Europe policies. For further details, please refer to the UMUC-Europe Graduate Catalog, available in your local Education Center or online at http://www.ed.umuc.edu/general_info/publications/catalogs.
| |
Course Requirements:
Graduate school at the masters level focuses on helping students obtain the education needed for success as professionals in their chosen fields. Thus, UMUC-Europe Graduate Programs and Bowie State University share the common goals of promoting excellence in academic scholarship through thoughtful inquiry and the skillful application of knowledge and theory for the betterment of society.
Grades for this course will be determined as follows:
25% midterm
25% final exam
15% paper and presentation
25% database and documentation
10% active and constructive participation, in-class work
| |
Description of Course Requirements:
Graduate Project:
By noon, Saturday 12 June, post to the MIS webboard a one-paragraph proposal describing the database you intend to design, and telling what software you will use to implement it. While awaiting approval, continue working on the design, under the assumption that the project is likely to be approved with possible scope adjustments.
If you do not have database software at home, please try to make plans to do the actual implementation in a UMUC computer lab. Most of your design work, the most critical part of the project, will not require use of the database software.
First of all, select something you're interested in doing for your project. For example, if you have an extensive collection of CDs, you might want to design a database to keep track of them, and of which friends have borrowed which of them.
The goal is for everyone to get at least a prototype of your database working, but please remember that the heaviest emphasis is on the DESIGN (which we'll be seeing in detail in chapter 8 and Appendices D and E).
Assuming you get it working, please remember that this is not a data entry project -- a few carefully selected rows in your tables will be plenty -- illustrating your project with entries for 5 or 6 CDs would be just as good as putting in the data for all 500 of them, for example.
Don't just put the following items in for the sake of having them there, they need to actually fit "naturally" into the project -- a good rule of thumb regarding project size is to have a minimum of 5 tables, 5 forms, 5 reports, 5 queries. Note that these should not just be trivial variations of basically the same query/report/form.
Paper and Presentation:
A research paper will be required of all graduate students in the course and will be due the last weekend. You must use three outside references and the paper should go beyond what is in the textbook itself. Topics will be assigned from the list of topics on the schedule for the last weekend of the class. In addition, the paper will be presented (using a power-point presentation) to the rest of the class.
| |
Course Schedule:
Projected Course Schedule:
Note: This course is being conducted on a compressed schedule. However, there will be no reduction in the quality of the course that is presented. Thus, participants must come prepared for each class, having read the reading material ahead of time and meeting course requirement deadlines.
weekend 1 - 5/6 June - lecture, discussion, and in-class work
Sat - Ch. 1 - Database Systems
Ch. 2 - Data Models
Ch. 3 - The Relational Database Model
Ch. 4 - Entity-Relationship (ER) Modeling
Sun - Ch. 5 - Normalization of Database Tables
Ch. 6 - Introduction to Structured Query Language (SQL)
during the two weeks between meeting weekends read and use as model for work on project:
Ch. 8 - The Database Design Life Cycle
Apdx D - The University Lab: Conceptual Design
Apdx E - The University Lab: Conceptual Design Verification, Logical Design
And Implementation
Assignment of paper topics during the weekend of 5/6 June
Note - the paper is to be presented in conjunction with coverage of the related topic the weekend of 26/27 June.
project proposals due on webboard by noon, Saturday 12 June,
approval/disapproval by noon Monday 14 June
weekend 2 - 19/20 June - lecture, discussion, in-class work, project design documentation due, and midterm exam
Sat - quick review of/questions regarding Ch. 8, Appendices D and E
Apdx H - Hierarchical Database Model
Apdx I - Network Database Model
Ch. 7 - Advanced SQL
Sun - Midterm Exam - in the morning, after a question/answer period
Midterm exam covers chapters 1-6, 8, Appendices D and E
evaluation of project work to date takes place during midterm exam
Note that for students registered in the graduate course there will be a take-home portion of the midterm which will be a free-response question. It should be responded to according to the guidelines for responding to comprehensive examination questions.
Ch. 9 - Transaction Management and Concurrency Control
Ch. 10 - Distributed Database Management Systems
Weekend 3 - 26/27 June - lecture, discussion, in-class work, project presentations, final exam, course evaluations
Sat - Apdx F - Multi-Tier Client/Server Systems
Apdx G - Client/Server Network Infrastructure
Ch. 11 - Object Oriented Databases
Ch. 12 - The Data Warehouse
Ch. 13 - Databases in Electronic Commerce
Course Evaluations
Sun - Ch. 14 - Web Database Development
Ch. 15 - Database Administration
Apdx C - Database Performance Tuning
Final Exam - in the afternoon, after a question/answer period
Note that for students registered in the graduate course there will be a take-home portion of the midterm which will be a free-response question. It should be responded to according to the guidelines for responding to comprehensive examination questions.
| |
Academic Policies:
Academic Policies: Please refer to the UMUC - Europe Graduate Catalog, available online at http://www.ed.umuc.edu/general_info/publications/catalogs/index.html or from your local Education Center, for information on the following:
Academic Integrity
Course Load
Exception to Policy
Grade Appeal Process
Make-up Examinations
Nondiscrimination
Students with Disabilities | |
Faculty Bio:
John Meinke, Collegiate Associate Professor with UMUC-Europe and Program Director of the Bowie State University MS in Management Information Systems program, earned the BA in Mathematics and the MEd in Mathematics Education from SUNY/Buffalo, the MAT in Mathematics from the University of Montana, and the MS in Computer Science from Illinois Institute of Technology. After a period with RCA Computer Systems Division, he became involved with post-secondary education, and has been involved in teaching and curriculum development in computing for three decades. He currently serves on the Board of Directors of the Consortium for Computing Sciences in Colleges and on the Steering Committees of both the CCSC Eastern Conference and the CCSC Southeastern Conference. In addition, he serves as a consultant to the CEEB (College Board) AP (Advanced Placement) in Computer Science program. His areas of interest include curriculum development, computer architecture and operating systems.
Email: meinkej@faculty.ed.umuc.edu or meinkej@acm.org ; Address: Heidelberger Weg 2, D-69181, Leimen/St. Ilgen, Germany. Telephone: 49-(0)6221-378208 or 370-6762/7157 (DSN) at UMUC -Europe, 49-(0)6224-924471 (home).
| |