Syllabus Entrance
Printer Friendly
Email Syllabus

MBA 609 Database Management Systems
McVicker, Michael J.


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.

Course

MBA609 Database Management Systems

Semester

F1P 2012 MB

Faculty

McVicker, Michael J.

Title

Adjunct Professor

Degrees/Certificates

Masters of Business Administration
Bachelor of Science

Office Location

Classroom - By Appointment Only

Office Hours

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

Daytime Phone

913-669-6457

E-Mail

michael.mcvicker@park.edu

Semester Dates

August 20 - October 14, 2012

Class Days

--T----

Class Time

5:30 P.M. - 9:30 P.M.

Prerequisites

MBA605 Course

Credit Hours

3


Textbook:

There are two textbooks required for this course:

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

ISBN: 978-1-111-82591-1                                         

Authors: Philip J. Pratt and Joseph J. Adamski

 

Oracle 11g SQL

ISBN #: 978-1-4390-4128-4                                      
Copyright 2010

Author: Joan Casteel

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 helpdesk@park.edu or call 800-927-3024
Resources for Current Students - A great place to look for all kinds of information http://www.park.edu/Current/.


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:

    Grading weights are as follows:

    Participation

    8%

    Discussion Questions      

    20%

    Oracle Lab Projects

    24%

    Weekly Assignments

    24%

    Final Term Project

    24%

    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

     

           Activity

    Weekly Points

    Total Points

    Percentage

    Participation (8)

        10

    80

    8%

    Discussion Questions (8)

    25

    200

    20%

    Oracle Lab Projects (8)

    30

    240

    24%

    Weekly Assignments (8)

    30

    240

    24%

    Final Term Project


    240

    24%

    Total Points


    1000

    100%


    The Final Term Project assessment in the MBA609 course will be comprehensive. It will constitute 24% 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:

    Each week's work must be completed, posted, and uploaded by Monday night at 11:59 P.M. CST the day before the next scheduled week's class. Assignments received after this time will receive a 50% reduction in points. Assignments received more than a week late will not receive any credit.

    I must have all assignments, to include your final 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. http://www.albion.com/netiquette/ 

    Course Topic/Dates/Assignments:

    Week  

    Concepts of Database Management

    Oracle 11g

    1

    Chapter 1: Introduction to Database Management

    Chapter 1:Overview of Database Concepts. Install Oracle Express 11g for Windows CD which is included with the textbook.

    Chapter 7: User Creation and Management.

    2


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

    Chapter 2: Basic SQL SELECT Statements

    Chapter 3:Table Creation and Management.

    3

    Chapter 3: The Relational Model 2: SQL

    Chapter 4: Constraints

    4

    Chapter 4: The Relational Model 3: Advanced Topics

    Chapter 5:Data Manipulation and Transaction Control.

    5

    Chapter 5: Database Design 1: Normalization

    Chapter 8: Restricting Rows and Sorting Data.

    6

    Chapter 6: Database Design 2: Design Method

    Chapter 9:Joining Data from Multiple Tables.

    7

    Chapter 7: DBMS Functions

    Final Term Project Due

    Chapter 10: Joining Data from Multiple Tables.

    8

    Chapter 9: Database Management Approaches

    Chapter 11: Group Functions.

    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 2012-2013 Graduate Catalog Page 21-22

    Plagiarism:

    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 2012-2013 Graduate Catalog Page 26

    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: http://www.park.edu/disability .

    Copyright:

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

    Last Updated:7/23/2012 2:56:03 PM