Module details for Application Design


This module develops students’ understanding and experience in the design and implementation of object-oriented software and relational databases. In both of these contexts, students will review existing designs, develop their own designs to meet stated requirements, critically evaluate these designs and create example implementations from these designs.


The aim of this module is to provide the student with the ability to review, develop, critically evaluate and implement designs in the contexts of object-oriented software and relational databases.

Learning Outcomes

By the end of this module the student should be able to:

1.  Create entity relationship models reflecting the requirements of application domains;

2.  Develop and implement OO designs incorporating relevant inheritance, composition and interface relationships that reflect application requirements;

3.  Develop database designs with associated SQL to meet application data requirements;

4.  Compare and contrast different software development methodologies, designing and implementing an application within one specific such methodology.

Indicative Content

1 Entity relationship (ER) modelling:

Identifying entities; 1-1, 1-many and many-many relationships; design notation; ER in OO software and database design.

2 Relational database design:

Using primary and foreign keys to realise 1-1 and 1-many relationships; link tables for many-many relationships; designing to meet application data requirements; normalisation.

3 SQL:

SQL as a programming language; basic relational algebra; expressing unions and joins; selecting, extracting, editing and inserting data; writing SQL to meet functional requirements.

4 OO software and SQL:

Including SQL into OO software; integrating OO software and database designs; realising designs in code.

5 Development methodologies:

The role of a methodology; review different methodologies such as waterfall, RAD, agile, TDD; appraise the role of design within different methodologies.

Teaching and Learning Work Loads

Teaching and Learning Method Hours
Lecture 12
Tutorial/Seminar 0
Practical Activity 28
Assessment 80
Independent 80
Total 200

Guidance notes

SCQF Level - The Scottish Credit and Qualifications Framework provides an indication of the complexity of award qualifications and associated learning and operates on an ascending numeric scale from Levels 1-12 with SCQF Level 10 equating to a Scottish undergraduate Honours degree.

Credit Value – The total value of SCQF credits for the module. 20 credits are the equivalent of 10 ECTS credits. A full-time student should normally register for 60 SCQF credits per semester.


We make every effort to ensure that the information on our website is accurate but it is possible that some changes may occur prior to the academic year of entry. The modules listed in this catalogue are offered subject to availability during academic year 2021/22 , and may be subject to change for future years.