Faculty Contact Information:
Stephen Marenka, Jr.
Collegiate Associate Professor
Master of Business Administration
Master of Science in Management Information Systems
Information Systems Analyst Certificate
Microsoft Certified Systems Engineer
Phone: 06363 1608
Alternate e-mail: marenkas@t-online.de
Web Site: http://faculty.ed.umuc.edu/~smarenka/
| |
Consultation:
Class meets on weekends: 31 March/1 April, 21/22 April, 5/6 & 19/20 May 0900 to 1600
Office hours are thirty minutes before class and thirty minutes after class, telephone, or e-mail. | |
Required Texts and Readings:
| Rob, P., and Coronel, C. (2007). Database Systems: Design, Implementation, and Management (7th ed.). Boston, MA: Thompson 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. (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:
Grade weights are as follows:
Homework: 20%
Database project: 30%
Midterm exam: 25%
Final exam: 25%
Grading Scale:
Letter grades will be assigned as follows:
90 - 100.......A
80 – 89........B
70 – 79........C
Less than 70...F
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.
GROUP PROJECT: PowerPoint Presentation with database documentation.
The database project will consist of a relational database and will be executed using an SQL database system as its implementation vehicle. The database must be sufficiently complex to demonstrate the creation of tables, joins, the creation of some derived third tables, joining two tables, entering data, updating, deleting and otherwise managing the database using pure SQL statements. Each presentation will be brought before a panel of organization executives (the class) to hear and review each proposal.
Due 15 April, Project Proposal. Identify the project and discuss the possible direction of it, including the possible size and scope of the proposed system. For instance, you might decide to do a CD or DVD collection. A basic paragraph about the collection and some possible tables and data to be stored and extracted would be required.
Due 30 April, Entity-Relationship models and Conceptual Database Design. (Normalized Tables with Keys indicated). Size and scope will be identified here, including kinds of joins, number of derived third tables and other information to give sufficient understanding of the project to assess its level of complexity and ability to solve a given problem. Something on the order of five tables and five joins (one or more three-table joins).
Due before class starts on 19 May. Final PowerPoint Presentation. Design Documents with SQL statements to produce specified reports with a working implementation of database system. Each project will be presented to the class using PowerPoint for the presentation. The project briefing will consist of the following suggested outline (outline may be altered and expanded as necessary using commonly accepted systems analysis methods and approaches):
Overview – Encapsulating discussion of the proposed system.
Problem – Identify the opportunity to produce a solution to a problem requiring a database implementation. Or an upgrade to a current database system that might be enhanced by the implementation of an SQL-based database server.
Assessment - What are all the salient considerations, limits, strengths, weaknesses, opportunities and threats concerning the proposed system?
Design – Elements to include philosophy of design--ER diagrams, tables, joins,
Implementation – How will the project be implemented? A detailed explanation and discussion of the implementation phase is expected here.
Maintenance – How will the project be maintained once established?
Summary – Wrap up the project presentation, summarizing the important elements of the system.
The database itself must be suitably documented.
Homework will be assigned, including SQL exercises. | |
Description of Course Requirements:
| 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 Schedule:
Session Topics (read chapters BEFORE class!)
Assignments due beginning of class. Homework to be assigned.
Weekend 1. 31 March, 1 April
Chapter 1: Database Systems
Chapter 2: Data Models
Chapter 3: Relational Data Model
Chapter 4: Entity Relationship Modeling
Due 15 April – Project Proposal. See Project Description for details.
Weekend 2. 21, 22 April
Chapter 5: Normalization of Database Tables
Chapter 6: Advanced Data Modeling
Chapter 7: Introduction to Structured Query Language
Midterm Examination Sunday Afternoon
Due 30 April: ERD Model and Conceptual Database Design.
See Project Description for details
Weekend 3. 5, 6 May
Chapter 8: Advanced SQL
Chapter 9: Database Design
Chapter 10: Transaction Management and Concurrency Control
Chapter 11: Database Performance Tuning and Query Optimization
Weekend 4. 19, 20 May
Due before class starts on 19 May. Final PowerPoint Presentation.
Chapter 12: Distributed Database Management Systems
Chapter 13: The Data Warehouse
Chapter 14: Database Connectivity and Web Development
Chapter 15: Database Administration
PowerPoint presentations Saturday Afternoon
Final Examination Sunday AFternoon | |
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:
| A retired field grade U. S. Air Force jet fighter pilot, Steve Marenka has an extensive practical background in administration and management at many operational levels, including both command and staff positions and computer intensive operating environments. His academic education includes: a Bachelor of Science degree in Business Administration and Economics from the University of Maryland; a Master of Business Administration degree in Financial Management from Saint Mary's University, San Antonio, Texas; an Information Systems Analyst Certificate and a Master of Science in Management Information Systems from Bowie State University, Europe; resident graduate of Air Command and Staff College at Maxwell AFB, AL.; studies at the University of the Saarland at Saarbrücken, including a German language proficiency certificate; and, a diploma in electronics from Devry Institute. Commercial technical qualifications include Microsoft Certified Systems Engineer and Microsoft Certified Professional + Internet. He has also provided consulting services for firms in the United States and Europe, addressing problems ranging from marketing analysis of demographic and location data, finance and computer applications and training, providing services in both German and English. He was once comptroller of the Marenka Stainless Steel Corporation, a closely held family corporation, and served as business manager for several private organizations. He has had considerable teaching experience in the classroom, both in the military and at the university level, teaching general management, human relations and technical courses. | |