Zur Hauptnavigation

    IT for Managers (Elective)

    Track:All tracks
    Follow-up / Interfaces:All subjects
    Pre-requisites:Pre-reading
    Didactics:

    Lecture, individual computer-based tasks, group tasks, plenum discussions
    Exam:Term Paper
    ECTS points:3
    Lecturer:Prof. Dr. Dominic Becking

    Aims and objectives:

    The lecture aims at imparting knowledge about modern approached to business driven system development processes and management of IT an IT processes. It uses data integration and business process modeling as examples to presenting the theories and conceptions at a technical as well as on a business level.

    It should lead to an overall understanding of the underlying concepts and their implementation in state-of-the-art database management systems (DBMS). Thus students will be able to apply their newly gained knowledge to everyday situations and develop a deeper understanding of technical demands in IT-Strategies.

    General learning objectives:

    The participants of the MBA programme gain particular knowledge about information technology.
    Graduates are capable of first analyzing a business problem, than to apply to theoretical concepts and bench-marked ideas to develop a problem solution, and finally implementing the solution in a change oriented manner.

    Detailed learning outcomes:

    • Understand the meaning of corporate data
    • Understand the importance of: corporate data integratio,business process management, IT as a business driver, system development and customization of IT for a given business
    • Be familiar with the basic concepts of database systems
    • Be able to take a substantial part in a process of data modeling
    • Be able to take a substantial part in a process of BPM

     

    Course textbooks:

    • Kenneth Laudon, Jane P. Laudon: Management Information Systems, Pearson, 13. Aufl., 2013
    • R. Kelly Rainer, Brad Price, Casey G. Cegielsk: Introduction to Information Systems: International Student Version, John Wiley & Sons; 5. Aufl., 2014
       

    Content of IT for Managers:

    1. Management Information Systems:

    • Data and Information
    • Functions and Taxonomy of MIS
    • IT Value Chain
    • Interdependence between Business and IT
    • Challenges of IT

    2. System Design and Model Driven Architecture 

    • IT and Structural Organizational Change
    • System Design Process
    • Management-IT Gap
    • Business Process Management
    • Model Driven Architecture

    3. Databases and Database Systems

    • History: File Systems and Flat File Data Gathering
    • Codd and the Relational Model
    • Modern DBMS

    4. Data Modeling

    • Entity-Relationship Modelling
    • Data Modelling I: Get to Know Your Corporation
    • Data Modelling II: Model the World into a Diagram 

    5. Communicating with and Programming of Databases

    • Basic SQL: Select, Update, Insert, Create, Drop and Delete
    • Joins and Subselects, Functions and Grouping
    • Data Manipulation and Transaction Management

    6. Database-Backed Applications

    • Management Support
    • Production Databases
    • CRM / Knowledge Management
    • Data Mining/Data Warehousing

    7. Traps, Mistakes and Dead Ends

    • Flexibility Costs You
    • A Warning: Transforming Old Mistakes Into New Ones


    Recommended supplemental readings:

    Abramson, I.; Abbey, M.; Corey, M. (eds.) (2004): Oracle Database 10g: A Beginner's Guide. McGraw-Hill Osborne Media, Emeryville.

    American National Standards Institute Inc. (1999). American National Standard for Information Technology – Database Languages – SQL – Parts 1-5. American National Standards Institute, New York.

    American National Standards Institute Inc. (2003). American National Standard for Information Technology – Database Languages – SQL – Parts 1-14. American National Standards Institute, New York.

    Codd, E. F. (1991). The Relational Model for Database Management – Version 2. Addison Wesley, Boston.

    Codd, E. F.; Codd, S. B.; Salley,C. T. (1993). Providing OLAP to User-Analysts: An IT Mandate, Codd & Associates, Ann Arbor/Michigan.

    Gulutzan, P.; Pelzer, T. (1999). SQL-99 Complete, Really. R&D Books Miller Freeman, Emeryville.

    Melton, J.; Simon, A.R. (2002). SQL:1999 Understanding Relational Language Components. Morgan Kaufman, San Francisco.

    Melton, J. (2003). Advanced SQL:1999 Understanding Object-Relational and Other Advanced Features. Morgan Kaufman Publishers, San Francisco.

    Welling, L; Thomson, L. (2003). MySQL Tutorial. Sams.

    Schattenwurf