School of Computer Science

Module 06-19321 (2013)

Software System Components

Level 2/I

Robert Hendley Shan He Semester 1 20 credits
Co-ordinator: Robert Hendley
Reviewer: Rami Bahsoon

The Module Description is a strict subset of this Syllabus Page.

Outline

This module presents more advanced software development techniques, enabling the design and development of programs of medium-scale size and complexity. Through a series of lab exercises, students apply concepts taught in the lectures and at the same time practice the design and development of medium-scale programs. Together with its companion module, Software System Components B, it is designed to equip students with programming abilities which may be needed in an individual final year project. The module covers the three topics of databases, web programming and concurrency, and distributed computing.


Aims

The aims of this module are to:

  • improve students' programming skills generally, and develop students' programming design and development skills to cope with large programs
  • provide programming experience with more advanced but commonly used Java class libraries and other packages as appropriate
  • teach specific skills in databases, web programming and concurrency, and distributed computing

Learning Outcomes

On successful completion of this module, the student should be able to:

1 use Entity-Relationship diagrams to construct and explain conceptual models of databases, and then design tables for a relational database 2 write and explain SQL queries for a relational database 3 query and update a relational database from Java
4 explain the servlet model and structure, including the servlet lifecycle and application/session/request/page scope
5 configure, install and use servlet based web applications, implementing correct servlet request and response code, including html form processing, session handling, database connectivity and security
6 explain and evaluate web application architecture and technologies 7 explain the concepts and issues of threads and synchronisation, including thread pools
8 implement, debug and test multithreaded programs with appropriate synchronisation, in a variety of contexts such as Swing, collection classes and network I/O mechanisms 9 explain and implement socket based communication


Restrictions


Pre-requisites

  • 06-18190 - Software Workshop One
  • 06-22754 - Foundations of Computer Science
  • 06-11224 - Introduction to Software Engineering

Teaching methods

3 hrs/week lectures/tutorials, 2-3 hrs/week labs

Contact Hours: Approx. 63


Assessment

Sessional: 2 hour examination (80%), continuous assessment (20%)

Supplementary (where allowed): By examination only

The continuous assessment will consist of programming exercises.


Detailed Syllabus

  1. An Introduction to the design and use of Database systems (4 weeks)

* Background, alternatives and justification of DBMSs * Relational Databases: i. Relational model ii. Introduction to SQL iii. creating & manipulating DBs iv. Introduction to Transactions and concurrency * Database Design – ER diagrams and mapping to DB implementation * Java & SQL – using a DB through JDBC 2. Distributed Computing and Sockets (2 weeks) * Background: the network communication models * Sockets: purpose, justification and methods of application * Clients, servers and protocols * Implementation issues in distributed systems 3. Threads and Concurrency (3 weeks) * Background to concurrent processing * Threads: purpose, justification and methods of application * Concurrent processing and shared resources * Multi-threaded programming caveats * Patterns for concurrent systems 4. Internet Computing (2 weeks)


Programmes containing this module