MBA609 Database Management Systems

for S2P 2012

Printer Friendly

Mission Statement: Park University provides access to a quality higher education experience that prepares a diverse community of learners to think critically, communicate effectively, demonstrate a global perspective and engage in lifelong learning and service to others.

Vision Statement: Park University, a pioneering institution of higher learning since 1875, will provide leadership in quality, innovative education for a diversity of learners who will excel in their professional and personal service to the global community.


MBA 609 Database Management Systems


S2P 2012 DL


Dr. Steve Hallman


MIS Assist Professor - MBA / MPA, MIS Graduate Academic Coordinator


Masters, IT

Office Location

911 Main Suite 900, KC

Office Hours

Tue- Fri 9:00 am to 4:00 pm

Daytime Phone



Best to use e-mail

Web Page

Semester Dates

March 19 May 3

Class Days


Class Time



MBA 605

Credit Hours



There are two textbooks required for this course:

Concepts of Database Management, 7th Edition
Course Technology/Cengage Learning, 2012

ISBN:  9781111825911

Authors: Philip J. Pratt and Joseph J. Adamski

New Perspectives on Microsoft Office Access 2007: Comprehensive
Course Technology/Cengage Learning, 2008

ISBN: 1-4239-0589-X

Authors: Joseph J. Adamski and Kathleen T. Finnegan

Also available as an eTextbook from iChapter at:

 Front Cover of Adamski/FinneganTextbook

Textbooks can be purchased through the MBS bookstore

Textbooks can be purchased through the Parkville Bookstore

Additional Resources:
Use of APA writing style for Posts and term paper.

McAfee Memorial Library - Online information, links, electronic databases and the Online catalog. Contact the library for further assistance via email or at 800-270-4347.
Career Counseling - The Career Development Center (CDC) provides services for all stages of career development.  The mission of the CDC is to provide the career planning tools to ensure a lifetime of career success.
Park Helpdesk - If you have forgotten your OPEN ID or Password, or need assistance with your PirateMail account, please email or call 800-927-3024
Resources for Current Students - A great place to look for all kinds of information
Advising - Park University would like to assist you in achieving your educational goals. Please contact your Campus Center for advising or enrollment adjustment information.
Online Classroom Technical Support - For technical assistance with the Online classroom, email or call the helpdesk at 866-301-PARK (7275). To see the technical requirements for Online courses, please visit the website, and click on the "Technical Requirements" link, and click on "BROWSER Test" to see if your system is ready.
FAQ's for Online Students - You might find the answer to your questions here.

Course Description:
MBA 609 Database Management Systems: This course explores the overall techniques used to design data bases and data base management systems. Principles for determining database management systems. Principles for determining database requirements, components and architectures are addressed. Topics include data dictionaries; use of case tools in developing databases; data integrity, security and privacy issues; user interface; and innovative programming languages. A final project involving the design of an actual corporate database is required.

Educational Philosophy:

Whether you are enrolled in a face-to-face or online section of this course, you will cover the same material, perform the same assignments, and be examined on the same concepts.

In either setting, our focus is on the Core Outcomes and Learning Objectives established for the course, and all course activities are designed to help you attain those objectives. The biggest difference is the way we go about these things. In an online section, "Lectures" are in the form of written notes and/or PowerPoint presentations; even so, they’re supplemented by outside reading assignments (textbooks, articles, Web pages, etc.), just as they would be in a face-to-face classroom.

One of the most important aspects of instructor-led learning is the ability to interact with the instructor and other students in the class. Since online students are not together in the same room, we accomplish this interaction using tools available in the online classroom:

  • "In-Class" discussion takes place using Threaded Discussions;
  • Questions can be addressed to me through Threaded Discussions or e-mail (for more personal matters);
  • Group project work is facilitated by the Group tools (Group Document Sharing, Group Discussion Area, Group Chat sessions, and Group E-mail distribution lists).

Learning Outcomes:
  Core Learning Outcomes

  1. Describe the relationships between information security policies and information security plan
  2. Summarize the five steps to creating an information security plan
  3. Provide an example of each of the three primary information security areas: a. Authentication and authorization b. Prevention and resistance c. Detection and response
  4. Explain the three exponents of an organization architecture
  5. Describe how an enterprise can implement a solid information architecture
  6. Define the relationships between a database and a database management system
  7. Describe the advantages an enterprise can gain by using a database
  8. Describe the benefits of a data-driven analysis

Core Assessment:

Class Assessment:

Students will be able to track their grade throughout the course.  Standards for each assignment will be given in advance.

Each student is responsible for:

  • Completing weekly Reading Assignments;
  • Submitting answers to Weekly Discussion Questions and performing Peer Reviews of other students' submitted responses;
  • Submitting completed weekly Access Lab Projects;
  • Submitting individual and group assignments for the weekly Group Project assignments;
  • Completing Weekly Review Quizzes;
  • Completing a Midterm Examination; and
  • Completing a final Term Paper.


Grading weights are as follows:

Discussion Questions and Peer Review 16%
Access Lab Projects 24%
Group Projects 24%
Weekly Quizzes 8%
Midterm Examination 14%
Final Term Paper 14%

Late Submission of Course Materials:

Each week's work must be completed by the due dates specified for that week. Assignments received after their stated due dates will incur a 10% reduction in your score for each three days (or fraction thereof) that your assignment is late. After one week late, no credit is earned.

Classroom Rules of Conduct:
Online Etiquette: All your Online communications need to be composed with fairness, honesty and tact. Spelling and grammar are very important in an Online course. What you put into an Online course reflects on your level of professionalism. Netiquette is a set of guidelines for how individuals communicate over the Internet. The important concept here is that students respect one another. 

Course Topic/Dates/Assignments:

Week Database Concepts Access Lab
1 Chapter 1: Introduction to Database Management Tutorial 1: Creating a Database
2 Chapter 2: The Relational Model 1: Introduction, QBE, and Relational Algebra Tutorial 2: Building a Database and Defining Table Relationships
3 Chapter 3: The Relational Model 2: SQL Tutorial 3: Maintaining and Querying a Database
4 Chapter 4: The Relational Model 3: Advanced Topics
Midterm Examination
Tutorial 4: Creating Forms and Reports
5 Chapter 5: Database Design 1: Normalization Tutorial 5: Creating Advanced Queries and Enhancing Table Design
6 Chapter 6: Database Design 2: Design Method Tutorial 6: Using Form Tools and Creating Custom Forms
Tutorial 7: Creating Custom Reports
7 Chapter 7: DBMS Functions Tutorial 9: Using Action Queries and Advanced Table Relationships
8 Chapter 8: Database Administration
Chapter 9: Database Management Approaches
Final Term Paper
Tutorial 10: Automating Tasks with Macros

Academic Honesty:
As a learning community, the University upholds the highest standards of academic integrity in all its academic activities, by faculty, staff, administrators and students. Academic integrity involves much more than respecting intellectual property rights. It lies at the heart of learning, creativity, and the core values of the University. Those who learn, teach, write, publish, present, or exhibit creative works are advised to familiarize themselves with the requirements of academic integrity and make every effort to avoid possible offenses against it, knowingly or unknowingly. Park University 2011-2012 Graduate Catalog Page 21


Plagiarism is the appropriation of another person's ideas, interpretation, words (even a few), data, statements, illustration or creative work and their presentation as one's own. An offense against plagiarism constitutes a serious academic misconduct.  Although offenses against academic integrity can manifest themselves in various ways, the most common forms of offenses are plagiarism and cheating. Plagiarism goes beyond the copying of an entire article. It may include, but is not limited to: copying a section of an article or a chapter from a book, reproduction of an art work, illustration, cartoon, photograph and the like and passing them off as one's own. Copying from the Internet is no less serious an offense than copying from a book or printed article, even when the material is not copyrighted.

Plagiarism also includes borrowing ideas and phrases from, or paraphrasing, someone else's work, published or unpublished, without acknowledging and documenting the source. Acknowledging and documenting the source of an idea or phrase, at the point where it is utilized, is necessary even when the idea or phrase is taken from a speech or conversation with another person.

Park University 2011-2012 Graduate Catalog Page 21

Carefully review the Academic Honesty; section of the Graduate Catalog (pages 21-22 in the 2011-2012 Catalog).

In this course, a first violation will incur a minimum sanction of a zero (0) on the affected assignment(s). A second violation by the same student will result in a minimum sanction of a final grade of 'F' for the course.

In the event of serious or egregious violations, more severe sanctions may be recommended to the Dean of the School of Business.

Attendance Policy:

Students must participate in an academically related activity on a weekly basis in order to be marked present in an online class. Examples of academically-related activities include but are not limited to: contributing to an online discussion, completing a quiz or exam, completing an assignment, initiating contact with a faculty member to ask a course related question, or using any of the learning management system tools. Park University 2011-2012 Graduate Catalog Page 25
Students must participate in an academically related activity on a weekly basis in order to be marked present in an online class. Examples of academically-related activities include but are not limited to: contributing to an online discussion, completing a quiz or exam, completing an assignment, initiating contact with a faculty member to ask a course related question, or using any of the learning management system tools.Park University 2011-2012 Graduate Catalog Page 25
Any student missing 2 weeks of course time by failure of contributing will be dismissed from the course.

Disability Guidelines:
Park University is committed to meeting the needs of all students that meet the criteria for special assistance. These guidelines are designed to supply directions to students concerning the information necessary to accomplish this goal. It is Park University's policy to comply fully with federal and state law, including Section 504 of the Rehabilitation Act of 1973 and the Americans with Disabilities Act of 1990, regarding students with disabilities. In the case of any inconsistency between these guidelines and federal and/or state law, the provisions of the law will apply. Additional information concerning Park University's policies and procedures related to disability can be found on the Park University web page: .

Additional Information:
Use of APA writing style for Posts and term paper.



I have over 20 years of teaching, academic administration, and curriculum development experience at the college and university levels. My teaching specialties include Management Information Systems and Computer Information Systems courses, which I have taught at both undergraduate and graduate levels. 

I have developed training partnerships, implemented software workshops, and designed several technology projects for Fortune 1000 businesses within southeastern Michigan and northern Indiana including: Auto Alliance, Chrysler Corporation, Henry Ford Health Care System, Ford Motor Company, Mazda, Wayne State University and many more..


This material is protected by copyright and can not be reused without author permission.

Last Updated:3/14/2012 1:56:31 PM