This module covers the stages involved in the design of an Information System and teaches the skills required to implement a working system. It is approximately 50% theoretical and 50% practical.
This module covers the stages involved in the design of an Information System and teaches the skills required to implement a working system. It is approximately 50% theoretical and 50% practical
Information Systems in Business
The organisation from an information perspective. Information requirements of different organisational functions and activities.
Systems analysis and design
Systems development life cycle.Analysis and design techniques and tools:Entity relationship diagrams,NormalisationData dictionaries
Implementation
Software selection/development.Testing.Documentation
Database Management Systems
Definition of a database management system (DBMS);Functions of a DBMS;Database software objectives: independence, integrity, minimal redundancy.
An in-depth study of a mainstream database product
Creating tables;Creating forms and subforms;Entering and editing data;Setting up relationships;Enforcing integrity constraints and validation rules;Cascade updates and deletes;Querying the database;Create user views;Generating reports.
A number of case studies will be worked through from initial investigation of requirements to final implementation of a solution.
| Module Content & Assessment | |
|---|---|
| Assessment Breakdown | % |
| Formal Examination | 70 |
| Other Assessment(s) | 30 |