This module explicitly focuses on significant elements required for the achievement of the STAFFORDSHIRE GRADUATE ATTRIBUTES.

This module will focus on traditional methodologies such as SSADM 4+ but will examine how Agile techniques can be used to improve traditional methodologies.

This module will cover aspects of skills associated with investigation, gathering and analysis of information.

The assessment will be a case study which will result in a build of a small application.

The module will include:

Methodologies: traditional and Agile
Case studies
Report writing
Fact finding and feasibility
Time management
Business and Technical Systems Options
Context and dataflow diagrams / dataflow modelling
Entity relationship diagrams and modelling
Normalisation

Prototyping and HCI (Interface design/globalisation issues)

Conversion of the logical design into a physical system (prototype), using an application development environment suitable for a COMPUTER SCIENCE SOLUTION

Introduction to Databases:
- Introduction to the concept and use of a Database Management System
- Implementation of a prototype database management system to include queries, forms and reports to meet user requirement specification
Backup and recovery
Security
Selection of DBMS, operating system, hardware
SQL; DML; DCL; DDL

Integration of databases into standard application
Concepts and issues of distributed databases, queries with associated software issues

48 hours of lectures and 48 hours of practical sessions. In the practical session you will work through exercises to get hands-on experience of the principles taught in the lecture.

System Analysis and Design, Fifth Edition
By: Alan Dennis; Barbara Haley Wixom; Roberta M. Roth
Pub. Date: January 18, 2012, Publisher: John Wiley & Sons, Print ISBN: 978-1-118-05762-9

Database Systems: A Practical Approach to Design, Implementation and Management
Thomas M. Connolly Carolyn E. Begg
5th edition (24 Feb 2009), Publisher: Addison Wesley; ISBN-10: 0321523067

None.

Coursework weighted at 100% made up of:

1) analyse and design (derived from a case study) a solution for a typical SME, 3000 words, weighted at 50% assessing learning outcomes 1 AND 2.
2) an implementation, evaluation and presentation based on the work completed in 1), 3000 words, weighted at 50% assessing learning outcomes 3 and 4.

None.