Faculty Contact Information:
Class meeting times: Alternate Weekends from 0900 until 1600. The first weekend is April 3,4. The last weekend is May 22,23, 2004.
INSTRUCTOR: Edmund I. Deaton
e-mail: edeaton@faculty.ed.umuc.edu
phone: 06221 893 5583(h), 01799 917 773(c).
|
|
Consultation:
|
Dr. Deaton will be available 30 minutes before each class meeting. He will be available after every class meeting. He is also available by appointment, e-mail and telephone. We will use the WebBoard for consultation.
|
|
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.
For this course, a copy of the APA Crib Sheet will suffice. It is available from
URL: www.wooster.edu/psychology/apa-crib.html
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.
|
|
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% - 100%
B 80% - 89%
C 70% - 79%
F(a) less than 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.
In order to maximize your graduate educational experience in general and this course in particular, you are required to complete the following projects and tests with the appropriate percentage:
Grades for this course will be based on:
Homework Exercises 15%
Database Project 40%
Midterm Examination 20%
Final Examination 25%
|
|
Description of Course Requirements:
Participate in classroom discussions: You are expected to come to class prepared to engage in all discussions in a professional and informed manner. Usually this requires two to three hours for every hour of a face-to-face class.
Minor Assignments and exercises:
Minor assignments will be drawn from, or similar to, textbook end-of-chapter problems, in order to reinforce technical database concepts.
Project:
A database project is required. This will involve modeling, designing and implementing a database, using one of the currently available languages or DBMS software packages. In addition, students will explain the operational and managerial use of their database, and where its technical aspects fit in the current state of the industry. There are five milestones in the project; the due dates are in the schedule. You are required to conduct professional-level research, including appropriately citing works of others and avoiding plagiarism.
Orally/visually present prepared material: You are required to present your results in a professional manner. This typically means an oral presentation accompanied by appropriate visual material.
Complete two written examinations: The examination process in this class will assist you in developing the writing and critical thinking skills necessary for successfully passing the comprehensive exam required of all graduate students. Some examination questions used for this course will either be taken directly from past comprehensive exams or written as though they were to be included on a comprehensive exam.
|
|
Course Schedule:
This schedule presents 16 units or modules, with each unit corresponding to a half-day on the weekends.
Tentative Course Schedule
April 3 AM:
DATABASE CONCEPTS
File Systems and Databases
Introduction to the course. Introduction to various database models.
Read Chapters 1,2.
April 3, PM:
DESIGN CONCEPTS
The Relational Database Model
The most important database model.
Assign the Database Projects.
Discuss the self directed database project in groups.
Read chapter 3
April 4, AM:
Entity Relationship Modeling.
Read chapter 4.
April 4 PM:
Normalization of Database Tables.
Read chapter 5.
April 24 AM:
ADVANCED DESIGN AND IMPLEMENTATION
Structured Query Language
DUE: Project Reports, Milestone I.
Read chapter 6.
April 24 PM:
Structured Query Language (continued).
Read chapter 7.
April 25 AM:
Database Design
Review of work to date
DUE: Project Reports, Milestone II.
Read chapter 8
April 25 PM:
Mid term exam, chapters 1 - 8
May 8 AM:
ADVANCED DATABASE TOPICS
Transaction Management and Concurrency Control
DUE: Project Reports, Milestone III.
Read chapter 9.
May 8 PM:
Distributed Database Management Systems.
Read chapter 10.
May 9 AM:
Object Oriented Databases.
Read chapter 11.
May 9 PM:
The Data Warehouse
DUE: Project Reports, Milestone IV
Read chapter 12
May 22 AM:
DATABASES AND THE INTERNET
Databases in Electronic Commerce.
Read chapter 13.
May 22 PM:
Web Database Development.
Read chapter 14.
May 23 AM:
DATABASE ADMINISTRATION
Database Administration
DUE: Project Reports, Milestone V, course evaluations.
Read Chapter 15.
May 23 PM:
FINAL EXAM, Comprehensive
|
|
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:
INSTRUCTOR: Edmund I. Deaton, Ph.D.
Dr. Deaton received his Ph.D. in Mathematics from The University of Texas. He has been teaching and doing research in Computer Science since 1980. After many years at San Diego State University he retired in 1992. He was a visiting professor at Hope College, Holland, Michigan during 1993-1995. He spent two years at Oklahoma State University from 1980 to 1982 as a visiting professor and visited there again in 1992. He worked as a management consultant with a Southern California consulting firm for several years in the 1980's. He specialized in database design for governmental entities. He has been with the University of Maryland, European Division since 1995. He teaches in the graduate MIS program and also teaches undergraduate computer science courses. His academic specialty is data base design. His primary hobbies are hiking and Alpine climbing. Although based in Heidelberg, he calls Rota, Spain home and hopes to be assigned there for some time each year. He is currently living in Heidelberg, Germany and will be there until June, 2004. Phone (Heidelberg) 06221 893 5583(h), 01799 917 773(c).
|
|