MBA609 Database Management Systems

for F2P 2011

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


F2P 2011 DL


Hallman, Steve A.


Masters IT

Office Location

Online and 911 Main S900

Office Hours

M-8:00-11:00 T-H - 8:30-11:00 & 1:00-4:00

Daytime Phone



Semester Dates

10/17/2011 thru 12/11/2011

Class Days


Class Time



None -

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:


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:

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

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

  Instructor Learning Outcomes
  1. Create tables, queries, forms, and reports in a relational database.
  2. Design a relational database with multiple tables.
  3. Use queries and the report wizard to design an effective report.
  4. Automate tasks with macros
Core Assessment:

Class Assessment:

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%



General grading scale:
90-100%  A
80-89%    B
70-79%    C
60-69%    D

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.

Classroom Rules of Conduct:
Treat each other with appropriate respect.

Course Topic/Dates/Assignments:
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

Follow APA writing style for any reports.

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


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

Last Updated:10/13/2011 1:39:28 PM