Course Description

Course Name

Business ICT Infrastructure

Session: VDNS3121

Hours & Credits

18 Credit Points

Prerequisites & Language Level

Taught In English

  • There is no language prerequisite for courses at this language level.

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 content subject to change