Database System Development

Module summary

Module code: COMP1713
Level: 4
Credits: 15
School: Liberal Arts and Sciences
Department: Computing and Mathematical Sci.
Module Coordinator(s): Simon Scola


Pre and co requisites

Level 4: Scholarly and Academic Practice


The aim of this course is to provide students with an overview of the major components in computer system developmentÍž human, conceptual, and physical in a software system development environment.

Specifically to developÍž understanding of typical business systems and the data that flows between people and sub systems, understanding of information gathering and requirements analysis using development methods, ability in using system building tools and techniques to construct software and information systems, understanding of current paradigms for building software systems, a view of system building in a wider organisational, social, ethical and legal context, recognition of the importance and nature of modelling techniques used by industry. This course has some practical experience of the implementation of simple database

Learning outcomes

Learning Outcomes: on successful completion of this course a student will be able to:
1 Elicit and specify requirements of computer systems.
2 Understand fundamental data driven and object oriented modelling concepts.
3 Model and document computer systems using suitable techniques and tools.
4 Implement a simple database system

Indicative content

An Introduction to Information Systems
Information gathering and requirements specification
An introduction to the main software design cycle phases: understanding the difference between requirements specification, analysis and design
An introduction to systems development using a structured methodology
Basic systems development with Data driven approach
The Unified Modelling Language (UML)
ER modelling concepts, introduction to databases and SQL
Object oriented approach to systems development.
Basic concepts of objects and OOAD
SQL and database software

Teaching and learning activity

This course will be taught by a mixture of formal lectures to gain critical insight into best practice
and classroom based tutorials to explore concepts introduced in lectures. The course will be
supported by a number of directed unsupervised learning activities.
12 two hour lectures 12 one hour tutorials


Method of Summative assessment: Logbook
Outcomes assessed:1,2,3,4
Grading Mode (e.g. pass/ fail; %): %
Weighting % :100%
Passmark: 40%
Outline Details: 5 Online Quiz

Nature of FORMATIVE assessment supporting student learning:
Tutorial classes, discussions and feedback from online quiz.