IS361 Data Management Concepts

for FA 2006

Printer Friendly

Mission Statement: The mission of Park University, an entrepreneurial institution of learning, is to provide access to academic excellence, which will prepare learners to think critically, communicate effectively and engage in lifelong learning while serving a global community.

Vision Statement: Park University will be a renowned international leader in providing innovative educational opportunities for learners within the global society.


IS 361 Data Management Concepts


FA 2006 HO


Hallman, Steve


Assistant Professor of Information Systems



Office Location

016B Science Hall (Lower Level)

Office Hours

Posted on Door (Every Day M-F)

Daytime Phone

816-741-2000 ext:6435


Semester Dates

Aug 21- Dec, 2006

Class Days


Class Time

1:00 - 2:15 PM


CS 219

Credit Hours








Concepts of Database Management, Fifth Edition, Philip J. Pratt and  Joseph J. Adamski, Course Technology 2004




Additional handouts may be required. Instructor  will provide information on obtaining this material.


Additional Resources:

All books are available at the Park University bookstore.  Every student is expected to have the necessary books by the second class period.  Students are encouraged to purchase a USB Jump Drive with cable. 


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:
This course provides an overview of data management concepts. This course will explore the enterprise perspective of managing data needs of an organization. This includes data integrity, database models, and integration of databases, security, and database administration issues. The student will be introduced to query processing within a database environment. PREREQUISITE: CS 219.  3:0:3

Educational Philosophy:

Over the years, my role as a teacher has evolved from being a giver of knowledge to being a facilitator. My main objective is to recognize students as individuals and help each one become a motivated self-sufficient learner who is able to evaluate information critically.  Students in my classes are expected to learn course concepts and skills, internalize it, then transfer and apply it, in new and different situations.  Providing some structure allows students to be in charge of their inquiry and prepares them to be the “life-long learners” described in the objectives of every educational institution today.  Finally, I believe that technology is a tool.  Educated people should recognize the need to control technology and use it for the betterment of society.

Learning Outcomes:
  Core Learning Outcomes

  1. Analyze the differences between Data and Database management
  2. Explain the duties of the data and database administrator.
  3. Describe the creation and use of metadata and data dictionaries.
  4. Identify the organizational perspective of managing data such as efficiency, privacy, security, ethical responsibility, and strategic advantage
  5. Compare a Relational Database and Object Orientated Database.
  6. Analyze components of a Database Management System and the techniques used to store and access data within DBMS.
  7. Describe a Data Warehouse including possible designs, use and terminology.
  8. Explain and apply the fundamentals of Structured Query Language (SQL).

Core Assessment:
Short Essay questionsProblem Solving, e.g. hands on SQL assignments
True/False plus justification for the answer
Homework Assignments
Short Essay questions
Problem Solving
True/False plus justification for the answer
Write a short review/essay paper about a subject in database technology

Class Assessment:

Graded material will be returned to you in class. You are responsible for keeping all work that has been graded during the semester. The correction of any clerical errors in recording of grades must be initiated within 5 days of posting of the grades or return of the assignment. If there is a discrepancy, you must present the actual assignment or test in order for the recorded score to be adjusted. Grades are A,B, C, D, F, each having a 10 point range.



Grading Policy:


Midterm  (Chapters 1-4)




Final  Exam (Chapters 5-9)




Database  Design project




Homework  assignments and class Participation





Late Submission of Course Materials:

Assignments are due at the beginning of the class period on the due date. Late submission of assignments will be assessed a penalty of 10% per day. No exceptions are made. Assignments more than one week late will not be accepted and will receive a grade of 0. If you must miss class on the day an assignment is due, be sure to turn it in before class or it will be considered late. Always back up your work.

Classroom Rules of Conduct:
All students are expected to follow the rules for acceptable conduct and good manners.  Any student, who does not adhere to these guidelines will be excused from class and reported to the proper authorities

Course Topic/Dates/Assignments:

Course Outline

Fall 2006



Week #                 Class Topic                                      Assignments


1 (8/21-8/25)               Intro to CS-361                                   Read Chapter 1 (p.1-12)

                                                                                                Answer (type) the Review

Questions: 1-4, (p.27) – Due next class session.


Cover Homework Questions & Chapter 1 (p.1-12)     

                                                                                                Read Chapter 1 (p.12-26)

Answer Review Questions:

5-11, 13-20, and

Premiere Products Exercises:

2-3 and 6, (p.27) – Due next class session.



2 (8/28-9/1)                 Cover Homework Questions & Ch-1 (p.12-26).

                                                                                                Read Chapter 2 (p.29-46)

Answer Review Questions:

2-4, 6-8, and 10-13– Due next class session



3 (9/4-9/8)       Cover Homework Questions & Ch-2 (p.29-46)

Read Chapter 2 (p.46-63) Answer Review Questions:

16-18, 20-23 and

Premiere Products Exercises:

#1 (either method).

Due next class session



4 (9/11-9/15)   Cover Homework Questions & Ch-2 (46-63)

                                                                                                Read Chapter 3 (p.67-84)

Answer Review Questions

2-3, 5-6 and

Premiere Products Exercises:

1-5. - Due next class session.





5 (9/18-9/22)   Cover Homework Questions & Ch-3 (67-84)


6 (9/25-9/29)   Cover Homework Questions & Ch-3 (84-104)


7 (10/2-10/6)   Cover Homework Questions & Ch-4 (109-123 and 127)

Topic and proposal approval on DB project (Groups 3-4)


8 (10/9-10/13) Midterm (Chapters 1-4) & Cover Homework Questions & Ch-5 (139-147)


Fall Recess



9 (10/23-10/27) Cover Homework Questions & Ch-5 (146-168)


10 (10/30-11/3) Cover Homework Questions & Ch-6 (173-195)


11 (11/6-11/9) Cover Homework Questions & Ch-6 (195-220)

Veteran's Day 11/10


12 (11/13-11/17) Cover Homework Questions & Ch-7 (225-240)


13 (11/20-11/22) Cover Homework Questions & Ch-7 (240-257)


Thanksgiving Recess



14 (11/27-12/1) Cover Homework Questions & Ch-8 (261-281)


15 (12/4-12/8) Cover Homework Questions & Ch-9 (p.285-299 & 300-301)

Final Database is due    


16 (12/11-12/15)




Mid-Year 12/16          


Academic Honesty:
Academic integrity is the foundation of the academic community. Because each student has the primary responsibility for being academically honest, students are advised to read and understand all sections of this policy relating to standards of conduct and academic life.   Park University 2006-2007 Undergraduate Catalog Page 87-89

Plagiarism involves the use of quotations without quotation marks, the use of quotations without indication of the source, the use of another's idea without acknowledging the source, the submission of a paper, laboratory report, project, or class assignment (any portion of such) prepared by another person, or incorrect paraphrasing. Park University 2006-2007 Undergraduate Catalog Page 87

Attendance Policy:
Instructors are required to maintain attendance records and to report absences via the online attendance reporting system.

  1. The instructor may excuse absences for valid reasons, but missed work must be made up within the semester/term of enrollment.
  2. Work missed through unexcused absences must also be made up within the semester/term of enrollment, but unexcused absences may carry further penalties.
  3. In the event of two consecutive weeks of unexcused absences in a semester/term of enrollment, the student will be administratively withdrawn, resulting in a grade of "W".
  4. A "Contract for Incomplete" will not be issued to a student who has unexcused or excessive absences recorded for a course.
  5. Students receiving Military Tuition Assistance or Veterans Administration educational benefits must not exceed three unexcused absences in the semester/term of enrollment. Excessive absences will be reported to the appropriate agency and may result in a monetary penalty to the student.
  6. Report of a "F" grade (attendance or academic) resulting from excessive absence for those students who are receiving financial assistance from agencies not mentioned in item 5 above will be reported to the appropriate agency.

Park University 2006-2007 Undergraduate Catalog Page 89-90
Attendance in class is strongly recommended and will be taken. Students are responsible for all material and assignments given in class whether they are present or not. It is the responsibility of the student to obtain notes, assignments, etc. for any missed class from a fellow student. Students missing exams due to a pre-arranged, excused absence will be allowed to take the exam early. Only official excuses will be accepted. Any uncoordinated, unexcused missed exam will result in a score of 0 for that exam.

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:


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

Last Updated:8/23/2006 3:43:23 PM