Faculty Contact Information:
|
Per e-mail (M.Hayes@gmx.de) or before or after scheduled classroom sessions.
|
|
Consultation:
|
Before or after scheduled classroom sessions.
|
|
Required Texts and Readings:
|
Rob, P., and Coronel, C. (2009). Database Systems: Design, Implementation, and Management (8th ed.). Boston, MA: Cengage Learning. 9781423902010.
|
|
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. (Formerly INSS 550.) Prerequisite: Either INSS 510, INSS 520, INSS 530, INSS 620, INSS 630, 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:
|
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 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:
10% - Participate in classroom discussions
30% - Complete a graduate level database project using Microsoft SQL Server Express Edition or Compact Edition. The database application area may be chosen by the student but must be approved by the instructor.
10% - Orally and visually present the database application.
50% - Complete a comprehensive final examination(s)
|
|
Description of Course Requirements:
|
Participate in classroom discussions: Students 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 and approximately ten hours of preparation per week for a DE class. Students are encouraged to bring to class laptop computers with installed SQL Server, an extension cord (power), and a 10m length of Cat5 cable for a network connection.
Complete graduate level database projects: Students are required to conduct professional-level research and development, including appropriately citing works of others and avoiding plagiarism, where required. 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. This extends to code and instructions required for database development and administration.
Orally/visually present prepared material: Students are required to present their results in a professional manner in an oral presentation accompanied by appropriate visual material.
Complete one or more written examination(s): 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. The examination questions used for this course will either be taken directly from past comprehensive exams or written as though to be included on a comprehensive exam.
|
|
Course Schedule:
All chapter references are to the course text.
Saturday, 5 April 2008
- Introductions
- Review of syllabus
- Clarification of goals, objectives and requirements
- Discussion of Database Projects
- Be familiar with Microsoft SQL Server installation options prior to class
- Read chapter 1 of the text prior to class
- Data Models
- Read chapter 2 of the text prior to class
- The Relational Database Model
- Read chapter 3 of the text prior to class
Sunday, 6 April 2008
- Entity Relationship (ER) Modeling
- Read chapter 4 of the text prior to class.
- Database Normalization
- Read chapter 5 of the text prior to class.
- Advanced Data Modeling
- Read chapter 6 of the text prior to class.
7-13 April (Web Tycho)
- Chapters 7: Structured Query Language (SQL)
- Turn in CLDP ER diagrams, business rules, and table designs.
14-20 April (Web Tycho)
- Chapter 8: Advanced SQL
- turn in fully normalized table designs.
21-27 April (Web Tycho)
- Chapter 9: Database Design
- Turn in list of queries and associated SQL code
28 April - 4 May (Web Tycho)
- Chapter 10: Transaction Management and Concurrency Control
- Turn in design of reports and input forms/menus
5 May - 11 May (Web Tycho)
- Chapter 11: Database Performance Tuning and Query Optimization
12 May - 16 May (Web Tycho)
- Chapter 12: Distributed Database Management Systems
Saturday, 17 May 2008
- Data Warehousing and Database Administration
- Databases and E-Commerce
- Web Databases
- Read chapters 13-15 of the text prior to class
Sunday, 18 May 2008
- Database Project Presentations
- Final Examination
|
|
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 plagiarism
The 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.
Students with disabilities should contact the appropriate support office at UMUC-Europe.
Jan Keller, Director of Student Services
UMUC-Europe, Heidelberg
Phone: +49-6221-378299
Email: edstudent_svc@ed.umuc.edu
Mailing Address: Unit 29216, APO AE 09102 OR Im Bosseldorn 30, D-69126 Heidelberg, Germany
Please refer 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 Code of Civility
Hard copies of the catalog are available at your local Education Center.
|
|
Faculty Bio:
1965-69 BA in Philosophy, Northwestern
1969-71 MA in Philosophy, Penn State
1972-75 1st Lt., 10th Marine Regiment, USMC
1975-76 Master of Intl Management, Thunderbird
1976-93 Bank of America, Frankfurt. Bank operations, office automation, EB, treasury management software support
1993-99 Citibank, Frankfurt, Vice President. Database application development: customer billing application, customer database, customer implementations database, fax processing application
2000-06 Dresdner Bank, Frankfurt. Project management and organization, SAP Reporting
--------------------------------------------------------------------
1983-XX University of Maryland, Adjunct Associate Professor. Almost all CMST seminars, Intro to Business, Windows 2000 Professional and Server, Cisco Routers and Switches, Statistics, and numerous other upper level and graduate computing clases, both DE and face-to-face.
1999 Microsoft Certified Systems Engineer (MCSE): Windows NT
2001 Microsoft Certified Professional: Windows 2000 Professional and Windows 2000 Server
|
|