Module Descriptors
STRUCTURED SYSTEMS ANALYSIS AND DESIGN
COIS40891
Key Facts
Digital, Technology, Innovation and Business
Level 4
30 credits
Contact
Leader: Euan Wilson
Email: E.D.Wilson@staffs.ac.uk
Hours of Study
Scheduled Learning and Teaching Activities: 96
Independent Study Hours: 204
Total Learning Hours: 300
Assessment
- Coursework - Assignment 3,000 words weighted at 50%
- Coursework - Assignment 3,000 words weighted at 50%
Module Details
Module Indicative Content
This module explicitly focuses on significant elements required for the achievement of the STAFFORDSHIRE GRADUATE ATTRIBUTES.
This module will initially review traditional approaches to systems development ie: SSADM 4+ before focusing on Agile approaches to systems development i.e xp; scrum; dsdm
The assessment will be a case study which will result in the building of a database application.
The module will include:
Fact finding and feasibility
Business and Technical Systems Options
Context and dataflow diagrams / dataflow modelling
Entity relationship diagrams and modelling
Normalisation
Entity life histories
EAM, ECD and any other modelling technique that could be used to validate the design and enhance the design process
The module will look at techniques including Jackson Structure Design / Development and UML that could aid systems development
A review of updated versions / variations of RAD such as DSDM, Prestwood Development Methodology etc.
An overview of Agile methodologies
An overview of Extreme Programming
Prototyping as a tool for user centred development
An overview of project management and risk assessment strategies that are needed to support design
HCI issues with respect to the use of prototyping as a development aid
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
Big Data concepts; Hadoop; Mongo; NOSQL; JSON; XML
Conversion of the logical design into a physical system (prototype), using an application development environment suitable for a SME.
This module will initially review traditional approaches to systems development ie: SSADM 4+ before focusing on Agile approaches to systems development i.e xp; scrum; dsdm
The assessment will be a case study which will result in the building of a database application.
The module will include:
Fact finding and feasibility
Business and Technical Systems Options
Context and dataflow diagrams / dataflow modelling
Entity relationship diagrams and modelling
Normalisation
Entity life histories
EAM, ECD and any other modelling technique that could be used to validate the design and enhance the design process
The module will look at techniques including Jackson Structure Design / Development and UML that could aid systems development
A review of updated versions / variations of RAD such as DSDM, Prestwood Development Methodology etc.
An overview of Agile methodologies
An overview of Extreme Programming
Prototyping as a tool for user centred development
An overview of project management and risk assessment strategies that are needed to support design
HCI issues with respect to the use of prototyping as a development aid
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
Big Data concepts; Hadoop; Mongo; NOSQL; JSON; XML
Conversion of the logical design into a physical system (prototype), using an application development environment suitable for a SME.
Module Additional Assessment Details
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 outcome 1 and 2.
2) An implementation and presentation based on the work completed in 1), 3000 words, weighted at 50% assessing learning outcome 3 and 4.
1) Analyse and design (derived from a case study) a solution for a typical SME, 3000 words, weighted at 50% assessing learning outcome 1 and 2.
2) An implementation and presentation based on the work completed in 1), 3000 words, weighted at 50% assessing learning outcome 3 and 4.
Module Texts
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 [Paperback]
Thomas M. Connolly (Author), Carolyn E. Begg, 5th edition (24 Feb 2009), Publisher: Addison Wesley; ISBN-10: 0321523067
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 [Paperback]
Thomas M. Connolly (Author), Carolyn E. Begg, 5th edition (24 Feb 2009), Publisher: Addison Wesley; ISBN-10: 0321523067
Module Resources
Appropriate software modelling tool
Module Special Admissions Requirements
None.
Module Learning Strategies
52 hours of lectures and 52 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.