Faculty Contact Information:
|
Consultation:
| 1 hour before or 1 hour after class by appointment. | |
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. | |
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:
In order to maximize your educational experience in general and this course in particular, you are required to complete:
30% Learning Modules (activities, discussion questions and exercises)
30% Mid term examination
20% Database Project and Presentation
20% Final examination
100% Total | |
Description of Course Requirements:
Learning Modules: The course contains a total of six modules. You are expected to contribute in the classroom in a professional and informed manner including discussions, responding to other student's ideas, and completing learning activities and exercises.
Database Term Project: The INSS 550 course will give the graduate student the opportunity to propose, design, develop, document and present a database project that solves a typical business problem.
Resubmission of course work from previous classes (whether or not taken at UMUC, UMUC-Europe or BSU), partially or in its entirety, is not acceptable in this course and will result in an automatic failure on the assignment.
The database will consist of a relational database using one of the currently available languages or DBMS software packages. The database must be sufficiently complex to demonstrate the creation of tables, simple joins, derived third tables, joining two tables, entering data, updating, deleting and otherwise managing the database. Additionally, a quality User Manual describing the use of the system will be produced. The class, performing as organization executives, will view and evaluate each proposal.
Database project and presentation guidelines will be distributed during the first class meeting.
Mid-term and a final examination: The examination process in this class will assist you in developing writing and critical thinking skills. The exams will be composed of objective, short answer and essay questions as well as design problems. | |
Course Schedule:
Session 1: Saturday, October 23, 2004
Introductions
Clarification of goals, objectives and requirements
Orientation to subject
LEARNING MODULE 1: Database Concepts
Chapter 1 - Database Systems
Chapter 2 - Data Models
Appendix H - Hierarchical Database Model
Appendix I - Network Database Model
Form Database Project Teams
Session 2: Sunday, October 24, 2004
LEARNING MODULE 2: Design Concepts
Chapter 3 - The Relational Database Model
Chapter 4 - Entity-Relationship (ER) Modeling
Submit Database Project Topic
Session 3: Saturday, November 6, 2004
Chapter 5 - Normalization of Database Tables
LEARNING MODULE 3: Advanced Design and Implementation
Chapter 6 - Intro to Structured Query Language (SQL)
Session 4: Sunday, November 7, 2004
Chapter 7 - Advanced SQL
Chapter 8 - The Database Design Life Cycle
Mid term examination
Session 5: Saturday, November 20, 2004
LEARNING MODULE 4: Advanced Database Topics
Chapter 9 - Transaction Management & Concurrency Control
Chapter 10 - Distributed Database Management Systems
Appendix F - Multi-Tier Client/Server Systems
Appendix G: Client/Server Network Infrastructure
Session 6: Sunday, November 21, 2004
Chapter 11 - Object Oriented Databases
Chapter 12 - The Data Warehouse
Session 7: Saturday, December 11, 2004
LEARNING MODULE 5: Databases and the Internet
Chapter 13 - Databases in Electronic Commerce
Chapter 14 - Web Database Development
Project Presentations
Session 8: Sunday, December 12, 2005
LEARNING MODULE 6: Database Administration
Chapter 15 - Database Administration
Project Presentations
Final Examination
Course Evaluations | |
Academic Policies:
The University has a license agreement with Turnitin.com, a service that helps prevent plagiarism from internet resources. I may be using this service in this class by either requiring students to submit their papers electronically to Turnitin.com or by submitting questionable text on behalf of a student. If you or I submit part or all of your paper, it will be stored by Turnitin.com in their database throughout the term of the University's contract with Turnitin.com. If you object to this temporary storage of your paper, you must let me know no later than two weeks after the start of this class. Please Note: If you object to the storage of your paper on Turnitin.com, I may utilize other services to check your work for plagiarismThe official university policy on Plagiarism and Academic Dishonesty can be found at http://www.umuc.edu/policy/aa15025.shtml. Section I.C. states: "Faculty may determine if the resubmission of course work from previous classes (whether or not taken at UMUC), partially or in its entirety, is acceptable when assigning a grade on that piece of course work. Faculty must provide this information in their written syllabi. If the resubmission of course work is deemed to be unacceptable, a charge may not be brought under this Policy and will be handled as indicated in the written syllabi."
Please refer to Description of Course Requirements for specific information on how resubmissions will be treated in this course and to the UMUC-Europe Graduate Catalog for information on the following:
Academic Integrity
Course Load
Exception to Policy
Grade Appeal Process
Make-up Examinations
Nondiscrimination
Students with Disabilities
Hard copies of the catalog are available at your local Education Center. | |
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 Administrator and as a Lecturer for the University of Maryland University College.
He has a Masters of Science in Management Information Systems and currently holds certification as a Microsoft Certified Systems Engineer (MCSE) on Windows NT 4.0 and Windows 2000, a Microsoft Certified Database Administrator, and as a Microsoft Certified Trainer (MCT).
| |