Faculty Contact Information:
Stephen Sartain
Cell: +44 07748981646
Email: ssartain@faculty.ed.umuc.edu
IM:
Yahoo: stephen_sartain
ICQ: 1314108
MSN: stevesartain@hotmail.com
AIM: Sartain UMUC
|
|
Consultation:
|
1 hour before or 1 hour after class by appointment
|
|
Required Texts and Readings:
|
Rob, P., and Coronel, C. (2002). Database Systems: Design, Implementation, and Management (5th ed.). Boston: 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.
|
|
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 – 89%
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:
Homework Assignments 25%
Database Project 25%
Quiz 5%
Midterm Examination: 20%
Final Examination: 25%
|
|
Description of Course Requirements:
Project Description:
A term project is required, which 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. At the end of the term,
students will submit a printout and/or disk of their project, and will be expected to discuss it,
either with the class or with the instructor. The database project is usually an individual
effort, although group projects of larger database systems are feasible.
Students will need to use database software to complete the project and perhaps the
homework. For this, students may use a University computer lab or another computer of their
choice. During the first week of class, we will discuss various software packages and ways of
obtaining them.
Course Standards
Exams will cover both text and lectures and will consist mainly of definitions, short answers
and essay questions. Both the midterm and final exams will include an essay question of the
type found in the MIS Graduate program comprehensive exams.
Homework assignments will give students experience in the technical aspects of database
management. There will also be one homework assignment involving research; the graduate
students will present their research findings to the class.
Class attendance is expected. Students are responsible for all material covered during lectures
and discussions, as well as assigned textbook readings. Class participation is encouraged,
especially when discussing issues where there are differing sources of information and points
of view. In order to have lively and effective class discussions, students should read the
assigned material and think about it before class.
Students will be graded primarily on their written work. Good presentation skills are also
important, however, and will help contribute to the grade. In both written assignments and
verbal contributions, students are encouraged to follow the maxim, "Content before form".
Standards for Written Work
Black ink on white A4 or 8.5x11 paper, in a standard typewriter face such as Courier, or 11-
or 12-point Times New Roman. Line spacing double-spaced or 1.5.
No color or graphics, except for (1) charts or maps generated by the student to convey
substantive information; or (2) as an artifact of the subject being studied, in support of a point
discovered or being argued by the student.
Where there has been research, be sure to acknowledge your sources, using the APA style for
footnotes and bibliographical references.
See -- http://www.umuc.edu/library/guides/apa.html
|
|
Course Schedule:
This schedule presents 16 units or modules, with each unit corresponding to a regular three-hour weekday meeting, a half-day on weekends, or a full week of DE.
1
Course and class introductions
Introduction to File Systems and Databases
Chapter 1
2
The Relational Data Base Model:
Chapters 2, 3
3
Normalization
Chapter 4
Assign Homework 1
4
SQL Chapter 5
Selection of DB project
topics
5
Review Chapters 1-5
Quiz (after review)
Database Design
Homework 1 due
Assign Homework 2
Chapter 6
6
Database Design (continued)
Transaction Management
Chapter 6, 9
7
Transaction Management (continued)
Distributed Databases
Chapter 9, 10
DB project outlines due
8
Review Homework 2 due
9
Mid-term Exam Assign Homework 3
10
Object-Oriented Databases Chapter 11
11
Data Warehousing Chapter 13
DB project progress
reports due
12
Client-Server Systems
Databases in Electronic Commerce
Web Database Development
Chapters 12, 14, 15
13
Database Administration Chapter 16
14
Recent Developments in Database Management
Presentation of HW3 (graduate research)
15
Presentation of database projects
Course review
Homework 3 due
DB projects due
16
Final Exam
|
|
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:
Steve Sartain spent nine years in the United States Army as an Arabic and French Linguist. He left the Army in September of 2000 to pursue his educational goals and to advance his career.
He currently resides in Alconbury United Kingdom with his wife Melanie and his sons Dagan and Corben. He works as Systems Engineer, Database Arichitect at RAF Molesworth and as a Lecturer for the University of Maryland University College.
He has a MS in MIS, a BS in Liberal Studies and currently holds certification as a Microsoft Certified Systems Engineer (MCSE) on Windows NT 4.0 and Windows 2000, a Microsoft Certified Database Administrator (MCDBA), and as a Microsoft Certified Trainer (MCT).
|
|