Faculty Contact Information:
e-mail: yhinz@faculty.ed.umuc.edu
home phone: +49 9221 761490
work phone: +49 6202 80 6511
|
|
Consultation:
|
Intructor will be available for consultation 20 minutes prior to and 30 minutes following each session.
|
|
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:
90 100%: A
80 89%: B
70 79%: C
0 - 69%: F(a)
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:
10% Classroom discussion participation
35% Database design project
15% Research paper
10% Material presentation
15% Midterm examination
15% Final examination
|
|
Description of Course Requirements:
Classroom discussion participation: 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 and approximately ten hours of preparation per week for a DE class.
A database design project is required: The primary objective of the project is to understand database design concepts covered in the class by designing and implementing a real-world database. The intent is to give the student exposure to the client/server database environment so every attempt will be made to ensure that you get exposure to a RDBMS server product such as MySQL or MS SQL Server as well as front-end products like MS Access. You are free to choose the topics you are interested in. The project may be conducted alone or in teams of no more than three people. The more contributors to a project, the more ambitious it should be. Students in a team should be responsible for coordinating the work themselves. Each team member will receive identical grade for the project.
Your project will have two major components:
1) Database design including:
- Database overview and scope
- User requirements
- Conceptual schema
- Logical schema
- Data dictionary
- Sample queries
2) Implementation: the implementation of your design. You have the freedom to choose any technologies you are familiar with. The implementation part of a final project should, at least, provide the functions of data entry, update, query, and simple report. The specific software to be used will be determined based on availability and preference.
A database related research paper is required: You are required to conduct professional-level research, including appropriately citing works of others and avoiding plagiarism. Plan on committing approximately 150 hours over the duration of this course to producing professional level deliverables, to include programs, projects, papers, and/or case studies.
Material presentation of the research paper: You are required to present your results in a professional manner. This means an oral presentation accompanied by appropriate visual aids.
Details of the requirements and schedule for the research paper and presentation will be provided during the first session.
Examinations: There will be a mid-term and final exams for this course. The mid-term exam will include all the materials covered from he beginning of the course to the mid-term exam date. The final exam will include all materials covered in the lectures and readings from the mid-term date to the class before the final exam date. 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.
Important note: 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.
|
|
Course Schedule:
The class will meet every other weekend: 30/31 October 04; 13/14 November 04; 4/5 December 04; 18/19 December 04; 0900-1600 hours.
October 30 AM:
Introductions
Review of syllabus
Clarification of goals, objectives and requirements
Orientation to subject
DATABASE CONCEPTS (Part I)
Database Systems
Data Models
Read Chapters 1,2.
October 30 PM:
DESIGN CONCEPTS (Part II)
The Relational Database Model
Assign the Database Projects
Discuss the self directed database project in groups
Read chapter 3
October 31 AM:
The Entity Relationship (ER) Modeling
Read chapter 4.
October 31 PM:
Normalization of Database Tables
Read chapter 5.
November 13 AM:
ADVANCED DESIGN AND IMPLEMENTATION (Part III)
Intro To Structured Query Language (SQL)
Read chapter 6.
November 13 PM:
Advanced SQL
Read chapter 7.
November 14 AM:
Database Design
Review of work to date
Project Reports
Read chapter 8
November 14 PM:
Mid term exam, chapters 1 - 8
December 4 AM:
ADVANCED DATABASE CONCEPTS (Part IV)
Transaction Management And Concurrency Control
Project Reports
Read chapter 9.
December 4 PM:
Distributed Database Management Systems
Read chapter 10.
December 5 AM:
Object Oriented Databases
DUE: Research paper
Read chapter 11.
December 5 PM:
The Data Warehouse
Project Reports
Read chapter 12.
December 18 AM:
DATABASES & THE INTERNET (Part V)
Databases In Electronic Commerce
Read chapter 13.
December 18 PM:
Web Database Development
Read chapter 14.
December 19 AM:
DATABASE ADMINISTRATION
Project Reports
Read Chapter 15.
December 19 PM:
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:
|
Yurek Hinz was born and spent majority of his life in Poland. He has worked as a professional musician for over 25 years in Europe and USA, and received a Master of Music degree in 1989 from the Chopin Conservatory of Music, Warsaw, Poland. In 1990, he was granted a full scholarship to study communication at Regent University, Virginia Beach, VA, and received a Master of Arts degree in 1992. In 2002, he was awarded Information Systems Analyst Certificate and Master of Science degree in Management Information Systems from Bowie State University. Mr. Hinz is the Chief Information Officer for the USAREUR Band and Chorus, Schwetzingen, Germany. Hes also an accomplished clarinet player and music teacher.
|
|