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

Specification

Pre and co requisites

Level 4: Scholarly and Academic Practice

Aims

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