Module Descriptors
SYSTEMS ANALYSIS AND DATABASE
COIS51001
Key Facts
School of Computing and Digital Technologies
Level 5
30 credits
Contact
Leader: Euan Wilson
Email: E.D.Wilson@staffs.ac.uk
Hours of Study
Scheduled Learning and Teaching Activities: 72
Independent Study Hours: 228
Total Learning Hours: 300
Assessment
- GROUP ASSIGNMENT weighted at 100%
Module Details
Module Indicative Content
Group working and associated issues - formation of and the roles within, profiles, etc.
Organisational context of professional work - Management styles, management structure and teams, organisational structures
Interview techniques, structure and analysis of
Fact finding and feasibility
Business and Technical Systems Options
Context and dataflow diagrams / dataflow modelling
Entity relationship diagrams and modelling
Normalisation
Version control
The module will look at systems analysis and design.
An overview of Agile methodologies including Extreme Programming, DSDM, etc.
Prototyping as a tool for user centred development
An overview of project management and risk assessment strategies that are needed to support design
Human Computer Interaction issues
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
Overview of the Structured Query Language (SQL)
Big Data concepts; Hadoop; Mongo; NOSQL; JSON; XML
Introduction to design of the front-ends to Databases
Conversion of the logical design into a physical system (prototype), using an application development environment suitable for a Small to Medium size Enterprise (SME)
Organisational context of professional work - Management styles, management structure and teams, organisational structures
Interview techniques, structure and analysis of
Fact finding and feasibility
Business and Technical Systems Options
Context and dataflow diagrams / dataflow modelling
Entity relationship diagrams and modelling
Normalisation
Version control
The module will look at systems analysis and design.
An overview of Agile methodologies including Extreme Programming, DSDM, etc.
Prototyping as a tool for user centred development
An overview of project management and risk assessment strategies that are needed to support design
Human Computer Interaction issues
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
Overview of the Structured Query Language (SQL)
Big Data concepts; Hadoop; Mongo; NOSQL; JSON; XML
Introduction to design of the front-ends to Databases
Conversion of the logical design into a physical system (prototype), using an application development environment suitable for a Small to Medium size Enterprise (SME)
Module Additional Assessment Details
which will consist of
Part 1 (34% weighting) - students go through the process of establishing a software development team, and explain and reflect on the processes. (Learning Outcome 1)
Part 2 (66% weighting) - The team established in part 1 analyses, designs implements, and documents a database related solution to support a typical organisation relevant to the student's award. (Learning Outcomes 2 and 3)
Part 1 (34% weighting) - students go through the process of establishing a software development team, and explain and reflect on the processes. (Learning Outcome 1)
Part 2 (66% weighting) - The team established in part 1 analyses, designs implements, and documents a database related solution to support a typical organisation relevant to the student's award. (Learning Outcomes 2 and 3)
Module Learning Strategies
48 hours of lectures and 24 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.
Module Resources
None
Module Texts
System Analysis and Design, 5th Edition
By: Alan Dennis; Barbara Haley Wixom; Roberta M. Roth
Pub. Date: January 18, 2012
Publisher: John Wiley & Sons
ISBN: 978-1-118-05762-9
Database Systems: A Practical Approach to Design, Implementation and Management [Paperback], 5th Edition
Thomas M. Connolly , Carolyn E. Begg
2009
Addison Wesley;
ISBN-10: 0321523067
By: Alan Dennis; Barbara Haley Wixom; Roberta M. Roth
Pub. Date: January 18, 2012
Publisher: John Wiley & Sons
ISBN: 978-1-118-05762-9
Database Systems: A Practical Approach to Design, Implementation and Management [Paperback], 5th Edition
Thomas M. Connolly , Carolyn E. Begg
2009
Addison Wesley;
ISBN-10: 0321523067
Module Special Admissions Requirements
None