• Log In
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • HomePage
  • About
  • Structure
  • Schedule
    • First Half of the Semester
      • Week 1: MIS5205-Introduction
      • Week 2: Framework-Function-Process
      • Week 3: GCC-DBMS
      • Week 4: Operating Systems
      • Week 5: OS Auditing and IT Risk Assessment
      • Week 6: Network and Network Auditing
      • Week 7: Service Level Agreement
    • Second Half of the Semester
      • Week 8: Datacenter Operations Review
      • Week 9: BCP and DR
      • Week 10: Application Control
      • Week 11: Information Security
      • Week 12: Change Management and Licensing
      • Week 13: Fall Break/No Class
      • Week 14: Auditing Capacity/Performance/EndUser Computing
      • Week 15: Emerging technology risks and controls (presentation)
  • Assignments
    • Team Assignment #1
    • Team Assignment #2
    • Team Assignment #3
    • Emerging technology
    • Cybersecurity/Data Breach
  • Webex
  • HBR Coursepack
  • Gradebook

ITACS 5205

Temple University

Week 3: GCC-DBMS

Week 3 Slides Deck:

IT Service Delivery and Support_Database

  • IT Infrastructure and General Computer Controls Auditing
  • Database Management System and Database Administration Practices
  • Audit database management system

Discuss Normalization

DB2 Audit program Sample:

db2auditplan

Discussions

  • IT Audit Planning
  • What are General Computer Controls? (Chapter 3)
  • Database types and benefits of Database Management System (Chapter 9)
  • Auditing Database Management System (DBMS)

Activity

Review Quiz#1

Group Assignment #One (due on EOD 9/23/17)

Develop an audit planning memo for General Computer Control audit.

 

Weekly Reading Assignments:

CISA Review Manual 2015:

  • 4.4.1 – Operating Systems
  • 4.4.2 – Access Control Software
  • 4.6.2 – Operating System Reviews/Auditing
  • Exhibit 4.22 – Operating Systems Reviews

IT Auditing: 

  • Chapter 6 Auditing Windows Operating Systems;
  • Chapter 7 Auditing Unix and Linux;

 

Primary Sidebar

Weekly Discussions

  • Welcome (1)

Copyright © 2025 · Magazine Pro Theme on Genesis Framework · WordPress · Log in