MBA609 Database Management Systems

for U1P 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.


MBA609X Database Management Systems


U1P 2012 MBX


McVicker, Michael J.


Adjunct Professor


Masters of Business Administration
Bachelor of Science

Office Location

Classroom - Park Library as needed (By Appointment Only)

Office Hours

5:00 - 5:30 at Campus Classroom (Park Library this term as needed)

Daytime Phone



Semester Dates

June 4 - July 29 2012

Class Days


Class Time

Independent Study

Credit Hours



There are two textbooks required for this course:

Concepts of Database Management, Sixth Edition
Course Technology/Cengage Learning, 2008

ISBN: 1-4239-0147-9

Authors: Philip J. Pratt and Joseph J. Adamski

Also available as an eTextbook from iChapter at:

Oracle Database 11g: A Beginner's Guide

ISBN #: 978-0-07-160459-8
Copyright 2009

Authors: Ian Abramson, Michael Abbey, Michael J. Corey, and Michelle Malcher


Textbooks can be purchased through the MBS bookstore

Textbooks can be purchased through the Parkville Bookstore

Additional Resources:

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

Course Description:

MBA609 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:

It’s my duty as your instructor to ensure students enrolled in an online course receive the same “educational value” as those enrolled in a face-to-face presentation of the same course. 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.

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


    Grading weights are as follows:



    Discussion Questions      


    Oracle Lab Projects


    Weekly Assignments


    Final Term Project


    Grading is based upon the following framework involving a potential of 1000 points for each student premised upon the following components:
    Grading points A= 1000-900 points, B=899-800, C=799-700, D=699-650, F=649-0



    Weekly Points

    Total Points


    Participation (8)




    Discussion Questions (8)




    Oracle Lab Projects (7)




    Weekly Assignments (7)




    Final Term Project



    Total Points



    The Final Term Project assessment in the MBA609 course will be comprehensive. It will constitute 23% of the total course grade. Projects will be completed by week seven in the course.

    Late Submission of Course Materials:

    Beginning with Week 1 the following policy will be in effect for late assignments:

    • One day late: 10% of the total possible points will be deducted. For example, if the assignment is worth 40 points and it is one day late, 4 points will be deducted from the final point total.
    • Two days late: 30% of the total possible points will be deducted. For example, if the assignment is worth 40 points, and it is two days late, 12 points will be deducted from the final point total.
    • Three days late: 50% of the total possible points will be deducted. For example, if the assignment is worth 40 points, and it is three days late, 20 points will be deducted from the final point total.
    • More than three days late: No points for that assignment. An assignment will be considered late by midnight, Eastern Standard Time, on the due date. I must have all assignments, to include your final team project, by the last day of the term.
    • Any assignment received after the last day of the term will not be graded and will earn zero (0) points. There will be no exceptions to this policy. There are no extra-credit or makeup assignments.


    Classroom Rules of Conduct:

    A class week is defined as the period of time between Monday and Sunday. The first week begins the first day of the semester and ends midnight (Central Standard Time) the following Sunday. Assignments scheduled for completion during a class week should be completed as specified in the syllabus. Writing assignments and formal papers should be completed and successfully submitted, postmarked, or faxed so that they are in my hands on the due date. 

    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:


    Database Concepts

    Oracle Lab - detailed instructions provided in eCollege


    Chapter 1: Introduction to Database Management

    Chapter 1: Database Fundamentals. Download Oracle Express 11g Release 2 for Windows x32 - Oracle Express 11g Download

    You will need to create an account using your email address and a password to download the free software.


    Chapter 2: The Relational Model 1: Introduction, QBE, and Relational Algebra

    Chapters 2 and 3: Installing and Creating a Database Using Oracle Express 11g for Windows x32. Connecting to Oracle.


    Chapter 3: The Relational Model 2: SQL

    Chapter 4: Querying a Database using SQL (Structured Query Language)


    Chapter 4: The Relational Model 3: Advanced Topics

    Chapter 4 Continued: Querying a Database using SQL (Structured Query Language)


    Chapter 5: Database Design 1: Normalization

    Chapter 5: Introduction to PL/SQL (Procedural Language for Structured Query Language)


    Chapter 6: Database Design 2: Design Method

    Chapter 5 Continued: Introduction to PL/SQL (Procedural Language for Structured Query Language)


    Chapter 7: DBMS Functions

    Final Term Project Due

    Chapter 7: Backup and Recovery of Oracle


    Chapter 8: Database Administration
    Chapter 9: Database Management Approaches

    Chapter 6: The Database Administrator

    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

    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

    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: .


    I am a former Chief Information Officer (CIO) for a telecommunications company in the Kansas City area. I have over 25 years of IT experience in a diverse background of business. I have been in the education, aviation, pharmaceutical, telecommunications, and consulting fields. I have several years of teaching and curriculum development experience at the university level.


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

    Last Updated:6/2/2012 4:47:27 PM