Module Special Admissions Requirements
None
Module Resources
Java SDK and Netbeans
Standard PC with access to sql server or similar database development environment
Module Texts
Introduction to Java Programming 9th ed., Liang, Y.D. (2012) Pearson Education,
ISBN: 978-0273771388
Absolute Java 5th ed., Savitch, W. (2012) Pearson Education, ISBN: 978-0273764793
Essentials of Systems Analysis and Design, Valacich, George and Hoffer, (2012) Prentice Hall, ISBN-13: 9780137067114
Guided notes and textbooks as required
Module Additional Assessment Details
A test weighted at 50%, consisting of a portfolio-based coursework assessed by a series of in-class tests. (Learning outcomes 1 and 2) (total 2 hours)
An assignment weighted at 50%. Final Assessment. Consisting of:
A 3000 word report detailing the analysis, design of a database, associated storage strategy, simple prototype and a reflection on a case study for a typical SME (learning outcome 3 and 4).
Module Indicative Content
This module explicitly focuses on significant elements required for the achievement of STAFFORDSHIRE GRADUATE ATTRIBUTES.
This module will cover aspects of skills associated with investigation, gathering and analysis of information.
Introduction to programming using a suitable development environment
Variables & data types
Input & Output
Sequence, selection & iteration
Problem solving
Testing and Debugging
Methods
Arrays
Introduction to classes and objects
Exceptions
File handling
Database access
Object-oriented principles ¿ encapsulation, inheritance and association
The second half of the module will focus on traditional methodologies and will primarily focus on SSADM 4+, as this is traditionally seen as data centric
Context and dataflow diagrams / dataflow modelling
Entity relationship diagrams and modelling
Normalisation
EAM, ECD and any other modelling technique that could be used to validate the design and enhance the design / data process
The module will also discuss large data sets, unstructured data, XML
Big Data concepts;
The module will explain how hardware and software can be used to utilised and improve on data storage (indexing, blade servers, compression etc.)
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.