Business ICT Infrastructure

University of Otago

Course Description

  • Course Name

    Business ICT Infrastructure

  • Host University

    University of Otago

  • Location

    Dunedin, New Zealand

  • Area of Study

    Information Sciences

  • Language Level

    Taught In English

  • Prerequisites

    BSNS 106

  • Course Level Recommendations

    Upper

    ISA offers course level recommendations in an effort to facilitate the determination of course levels by credential evaluators.We advice each institution to have their own credentials evaluator make the final decision regrading course levels.

    Hours & Credits

  • Credit Points

    18
  • Recommended U.S. Semester Credits
    3 - 4
  • Recommended U.S. Quarter Units
    4 - 6
  • Overview

    An introduction to the key information and communication technology (ICT) infrastructure that underlies modern business systems. Topics include database systems and networking.
    The key task of any business information system is to transform data into information to support decision making. To do this, we first need some way to store and manage data, for without data there can be no information; and second, we need some way to transport data and information between systems both inside and outside the business, so that they can be presented where they are needed most. The former is provided by database systems, and the latter by computer networks; together these form the underlying infrastructure for modern business information systems, and are vital to almost all areas of computing. Students who take INFO 214 will learn the fundamentals of both technologies.

    Course Structure
    -The first half of INFO 214 focuses on database systems, specifically: the need for database management systems, the Relational Model of data, creating and interacting with databases using Structured Query Language (SQL), data security and transactions and concurrency. Practical work makes use of the Oracle database management system
    -The second half of INFO 214 focuses on computer networking, specifically: communication protocols, layered models for networking (OSI and TCP), the TCP/IP protocol stack, network application development, local area networks and network management and security. Practical work makes use of the Python programming language

    Learning Outcomes
    -Identify key elements of business ICT infrastructure and explain their relevance and importance
    -Describe the various functions of a database management system (DBMS) and evaluate their relevance for a given scenario
    -Explain the differences between data, databases and DBMSs and between the structural, integrity and behavioural aspects of the Relational Model of Data
    -Design, implement and test code to: create databases and associated integrity constraints, execute database queries, assign and manage basic security privileges within databases and apply transactions to manage access to data
    -Explain business data communications (BDC) and its relationship to business processes and apply appropriate networking technologies to support business operations
    -Describe the TCP/IP architecture and the main functionality of its different layers, including routing and addressing, and use the client/server architecture to develop a simple BDC application
    -Understand security threats to and quality issues of BDC and relate these to technical and managerial solutions and policies

Course Disclaimer

Courses and course hours of instruction are subject to change.

Eligibility for courses may be subject to a placement exam and/or pre-requisites.

Some courses may require additional fees.

Credits earned vary according to the policies of the students' home institutions. According to ISA policy and possible visa requirements, students must maintain full-time enrollment status, as determined by their home institutions, for the duration of the program.

Please reference fall and spring course lists as not all courses are taught during both semesters.

Availability of courses is based on enrollment numbers. All students should seek pre-approval for alternate courses in the event of last minute class cancellations

Please note that some courses with locals have recommended prerequisite courses. It is the student's responsibility to consult any recommended prerequisites prior to enrolling in their course.