MBA609 Database Management Systems

for F2P 2010

Printer Friendly

Mission Statement: The mission of the School of Graduate and Professional Studies at Park University is to provide leadership and directions to Park University's graduate and professional programs to assure that they are specialized, scholarly, innovative, and designed to educate students to be creative, independent, and lifelong learners within the context of a global community.

Vision Statement: Park University's School of Graduate and Professional Studies will be an international leader in providing innovative graduate and professional educational opportunities to learners within a global society.


MBA 609 Database Management Systems


F2P 2010 DL


"Dr. Steve" Hallman


School of Business Faculty Memeber


DBA Informations Systems
Master IT

Office Location

911 Main Suite 900, KC, MO 64105

Office Hours

M-TH 9:30- am 4:00 pm

Daytime Phone



Web Page

Semester Dates

Oct 18  to Dec 12, 2010

Class Days


Class Time




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:

 Front Cover of Adamski/FinneganTextbook

Textbooks can be purchased through the MBS bookstore

Textbooks can be purchased through the Parkville Bookstore

Textbooks can be purchased through the MBS 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.

Educational Philosophy:

This educator's educational philosophy is one of interactiveness based on lectures, readings, quizzes, dialogues, examinations, internet, videos, web sites and writings. The facilitator will engage each learner, encouraging the lively exploration of ideas, issues and contradictions.

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.

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.

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 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 2010-2011 Graduate Catalog Page 20


Plagiarism involves 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 2010-2011 Graduate Catalog Page 20

Attendance Policy:

Instructors are required to maintain attendance records and report absences. Excused absences can be granted by the instructor, for medical reasons, school sponsored activities, and employment-related demands, including temporary duty. Students are responsible for any missed work. Absences for two successive weeks, without approved excuse, will be reported to the Director of the individual graduate program, or to the Executive Director for the Graduate School, for appropriate action. Students with such a record of absences, without an approved excuse, may be administratively withdrawn from the class and notified that an "F" will be recorded, unless the student initiates official withdrawal from the class(es).Park University 2010-2011 Graduate Catalog Page 24

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/8/2010 1:47:14 PM