Project management software such as MS Project
ArgoUML/Netbeans
QSEE superlite
Visual Studio 2010 or higher
SQL Server Enterprise edition 2008 or higher
SQL Server Express
Oracle 11g or higher

Database Systems 5th Edition Connolly T, Begg C (2009) International Computer Science Series ISBN 0321173503

An assignment weighted at 100%. This will take the form of a group project with 2 assessment points.
Assessment point 1 weighted at 50%: produce a system specification with supporting documentation and evaluation of the approach taken (learning outcomes 1, & 2)
Assessment point 2 weighted at 50%: delivery of a working system supported by appropriate documentation and a demonstration and an evaluation of the system. (Learning outcome 3) Final Assessment.

This module explicitly focuses on significant elements required for the achievement of the STAFFORDSHIRE GRADUATE ATTRIBUTES.
Teaching Block 1
Project initiation processes including CBA
Project Management
Requirements specification
Analysis and design covering:
Structured approaches and tools which may include DFDs, E/A matrices, ELHs. ERDs. Work flows.
Agile approaches and tools which may include Use Case diagrams, Structure diagrams, Behaviour diagrams, Interaction diagrams
Implementation decisions - data structures, data storage and access, data centres, Cloud Computing

Teaching Block 2
Implementation issues for an object - relational DB covering:
Foundation SQL
Object element SQL including triggers, procedures & cursors
Relational Algebra
Implementation issues - optimisation, database tuning, deployment
Data security including sanitisation of data, protection of data at rest, protection against SQL injection, user management, legal and operational requirements
System evaluation

None.

26 lectures and 52 practical sessions. Students will be required to work in a group to develop a software solution for a virtual company, covering all elements from requirement specification to delivery and evaluation of the artefact. This is a practical, hands on module which requires students to complete additional exercises and prescribed reading during independent study hours. The module will use a problem based learning approach and real world case studies linked to the virtual company. To support students with the group work, the module will make use of milestones, review sessions and formative assessments. Peer assessment will be used.