Syllabus Entrance
Printer Friendly
Email Syllabus

IS 361 Data Management Concepts
Gonzalez, Arturo


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

IS 361 Data Management Concepts

Semester

U1B 2013 BL

Faculty

Gonzalez, Arturo

Title

Adjunct Faculty

Degrees/Certificates

M.A. Computer Resource Management
M.A. Management
B.A. Management

Office Hours

By appointment or before or after class

Daytime Phone

915-831-2239

Other Phone

915-637-4711

E-Mail

arturo.gonzalez@park.edu

Semester Dates

June 3, 2013 through July 28, 2013

Class Days

F

Class Time

5:00 - 10:00 PM

Credit Hours

3


Textbook:
Modern Database Management; Hoffer, Jeffrey A.; 11th Edition; Prentice Hall, Inc.; ISBN-13: 978-0-13-266225-3; ISBN-10: 0-13-266225-6; YR (2013)

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:
IS361 Data Management Concepts: 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 CS219 3:0:3

Educational Philosophy:
The instructor's educational philosophy is one of actively fostering student understanding through participation in classroom lectures, readings, quizzes, dialogs, examinations, Internet, video, websites, class exercises, and writings.  All students are encouraged to share their own personal views and experiences with respect to the topics being discussed 

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


  Instructor Learning Outcomes
  1. Demonstrate the understanding of the data base environment and data base development process
  2. Explain the difference between the logical database design and the physical database design
  3. Demonstrate an understanding of beginning and advanced Structured Query Language
  4. Identify the organizational perspective of managing data such as efficiency, privacy, and security
Core Assessment:
Exams
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
Paper
Write a short review/essay paper about a subject in database technology







Class Assessment:

There will be three exams and three projects assigned throughout the course.  The projects may consists of homework, papers/essays, or other assignments as found at the end of each chapter (may include fill-in-the-blank questions and analysis of selected cases).  There will also be class examples to support the topics covered in each chapter.  These class examples will not be graded.
 
 

Grading:

Projects 1, 2, and 3 are each worth 100 points for a total of 300 points. 
 
Exams 1 and 2 are worth 200 points each for a total of 400 points.
 
Exam 3 (core assessment)  is worth 300 points.
 
Total points:  1,000
 
90% - 100% = A (900 - 1,000 points)
80% - 89%   = B (800 - 899 points)
70% - 79%   = C (700 - 799 points)
60% - 69%   = D (600 - 699 points)
00% - 59%   = F (000 - 599 points)
 

Late Submission of Course Materials:
Late projects will be assessed a 10 point penalty for each day it is late.  After 5 days, the project will not be accepted.

Classroom Rules of Conduct:

Course Topic/Dates/Assignments:

Week 1 (June 7, 2013)
     Introduction
     How to use eCompanion
     Chapter 01
     Chapter 02
 
Week 2 (June 14, 2013)
     Chapter 02 - continued
     Chapter 03
     Chapter 04
     Exam 01
     Project 01 assigned
     Class exercise - select a data base to create
 
Week 3 (June 21, 2013)
     Chapter 04 - continued
     Chapter 05
     Chapter 06
     Project 01 due
     Class exercise - design a database
 
Week 4 (June 28, 2013)
     Class exercise - design a database - continued
     Chapter 06 - continued
     Chapter 07
     Chapter 08
     Project 2 assigned
     Exam 02
 
Week 5 (July 5, 2013)
     Chapter 08 - continued
     Chapter 09
     Chapter 10
     Project 2 due
     Class exercise - query a database
 
Week 6 (July 12, 2013)
     Chapter 10 - continued
     Chapter 11
     Project 3 assigned
 
Week 7 (July 19, 2013)
      Chapter 12
      Chapter 13
      Project 3 due
 
Week 8 (July 26, 2013)
      Chapter 13 - continued
      Exam 03
 

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 students and faculty members are encouraged to take advantage of the University resources available for learning about academic honesty (www.park.edu/current or http://www.park.edu/faculty/).from Park University 2012-2013 Undergraduate Catalog Page 97

Plagiarism:
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. from Park University 2012-2013 Undergraduate Catalog Page 95

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 "F".
  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 2012-2013 Undergraduate Catalog Page 98

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 .

Additional Information:

Bibliography:

Copyright:

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

Last Updated:4/26/2013 11:48:44 PM