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
Thomas M. Connolly, Carolyn E. Begg 5th edition , 2009, Addison Wesley; ISBN-10: 0321523067
Module Special Admissions Requirements
None.
Module Learning Strategies
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.
Module Additional Assessment Details
Group ASSIGNMENT length 6000 WORDS weighted at 100%.
which will consist of
Part 1 (50% weighting) - students go through the process of establishing a software development team and demonstrate the ethical and professional issues involved in the games industry. (Learning Outcomes 1 and 2)
Part 2 (50% weighting) - The team established in part 1 analyses and designs, constructs and documents a database supported application to support a typical organisation relevant to the games industry. (Learning Outcomes 3 and 4)
Module Indicative Content
This module explicitly focuses on significant elements required for the achievement of the STAFFORDSHIRE GRADUATE ATTRIBUTES.
The module will examine the life of a project from the creation of the project team to deployment of the basic web presence.
Recruitment issues - creation of job specification and advertising, CVs, evaluation of, creation of a portfolio (living CV), recruitment process etc.
Group working and associated issues - formation of and the roles within, profiles, etc.
Professional Bodies, Ethics and Codes of Conduct- Legal Issues relevant to computer professionals, Globalisation Issues and the Computer Professional, DP Act, ethic issues of storage of data, risk assessment
Organisational context of professional work - Management styles, management structure and teams, organisational structures
Interview techniques, structure and analysis of
Methodology support - including
Fact finding and feasibility
Context and dataflow diagrams / dataflow modelling
Entity relationship diagrams and modelling, normalisation etc
Examples of other techniques (EAM, ECD etc.) that could be used to validate the design and enhance the design process
Introduction to project management
Introduction to marketing
Tactical and strategic decision making, quantitative and qualitative research techniques
Report writing
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
SQL; DML; DCL; DDL
Introduction to GUI based Databases
Issues with GUI embedded databases
Conversion of the logical design into a physical system (prototype), using an application development environment suitable for a application that would support the games industry