Home / Course Resources Archive

Course Resources Archive

Undergraduate Module Descriptors 2012/13

CT4007: Systems Analysis And Database Design

Module Title Systems Analysis And Database Design
Module Code CT4007
Module Tutor Julie Paterson
School Computing and Technology
CAT Points 30
Level of Study 4
Pre-requisites None
Co-requisites None
Restrictions Cannot be counted with module IT120
Brief Description

This module introduces systems analysis and database design. Students learn how to identify business requirements and turn these rapidly into database systems. Students will be introduced to the requirements of being a Computing Professional.

Indicative Syllabus

The database is central to all information systems. Database success requires good systems analysis. Students are shown how to analyse business requirements and turn these into database systems.

The module introduces the theories behind systems analysis and database design, and gives the student much hands-on experience in these fields. Systems analysis subjects include: requirements analysis; process modelling; devising business options; estimating system costs; and data modelling and normalisation.

Database subjects include: relational database theory; how to build reliable and efficient databases; field types; ensuring data quality; and importing and exporting data.

Students are shown how to use computer-based systems analysis tools and database development tools. Students will study and investigate business scenarios for their coursework throughout the module.

Learning Outcomes

A student passing this module should be able to:

  1. describe the systems development life cycle and the role of the systems analyst .
  2. undertake a range of information gathering techniques and identify and record business requirements by analysing the components of a business system .
  3. refine initial system models to facilitate database design .
  4. rapidly build efficient, and effective, databases using leading development tools .
  5. describe the main features of database management systems, and describe the role of database systems in business, industry and science.
  6. demonstrate an understanding of a range of planning and information search techniques including the use of the Harvard referencing system.
Learning and Teaching Activities Scheduled Contact Hours: 72
Independent Learning Hours: 228
Assessment (For further details see the Module Guide) 001: 30% Coursework: Group work, standard, written: 1250 words or equivalent
002: 20% Coursework: Individual, standard written: 750 words or equivalent
003: 50% Coursework: Individual, standard written: 2000 words or equivalent
Special Assessment Requirements
Indicative Resources

The Library Catalogue contains full details of the current reading list for this module. Further details may also be found in the Module Guide.

An error has occurred. This application may no longer respond until reloaded. Reload 🗙