CT4007: Systems Analysis And Database Design


Please note this module descriptor is indicative of the structure of this course and may be subject to change.

CT4007: Systems Analysis And Database Design

Module Title Systems Analysis And Database Design
Module Code CT4007
Module Tutor Maureen Clutterbuck
School Business School
CAT Points 30
Level of Study 4
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)
Special Assessment Requirements
Indicative Resources The current reading list can be found in the Module Guide, which your lecturer should make available via Moodle.

What are Course Maps and Module Descriptors?

Course Maps

A course map contains a list of the individual study units, called modules, that you study to complete your course. Some modules are compulsory, but you can sometimes choose modules outside your core area of study which interest you.

Module Descriptors

A module is a self-contained, individual unit of study. The module descriptor provides various details about the module including who the module tutor is, what you will be studying, how you will be assessed and what you will have learned once you have completed the module.

Course Resources Archive

Course maps and module descriptors from previous years can be found in the Course Resources Archive.