CASE tool e.g. SELECT, 4GL in multi-user environment e.g. Oracle/Access

There following are recommended as background reading:-

Modern Systems Analysis and Design
Hoffer J A, Valacich J S and George J F 3rd edition
Prentice Hall 2002
0-13-033990-3

Systems Analysis and Design
Tudor D J and Tudor I J
NCC Blackwell 1995
ISBN 1855543516

An Introduction to SSADM,Version 4
Ashworth C and Slater L
McGraw-Hill, 1993
ISBN 0077077253

Oracle9i: A Beginner's Guide
Abbey M, Corey M and Abramson I
McGraw-Hill/Osborne 2002
ISBN 0-07-219279-8

Oracle9i: The Complete Reference
Loney K
McGraw-Hill/Osborne 2002
ISBN 0-07-222521-1

Quick Simple Microsoft Access 2000
Ericksen L
Prentice Hall 1999
ISBN 0-13-081320-6.

This module is designed to provide a practical awareness of the activities of systems analysis and design with databases based on a case study scenario which enables you to analyse the problems and propose solutions using appropriate tools and techniques.
You will learn how to analysis and design a system in the form of a prototype, taking into account an awareness of the human aspects of design and the production of a quality product. You will also find out about the system development life cycle and all its phases.
Identification of current methodologies and their suitability for application domains. For example, SSADM, RAD, Prototyping, Yourdon, Object Oriented techniques and methodologies.
Basic project management and control techniques.
The use of structured methods' techniques: including fundamental investigation techniques, problems requirementanalysis, dataflow diagrams, entity and event modelling, and cost benefit analysis.
An introduction to data analysis: logical and relational to produce stable data models.
An overview of database management systems.
Physical design data.
Dialogue and output design with emphasis on human computer interaction (HCI) aspects.
Quality and control techniques.
Practical prototyping using an appropriate Computer Aided Software Engineering (CASE) tools and 4GL.

Lectures (1 per week) will provide the background material for use in the tutorial sessions (1 per week) plus an optional surgery (1 per week).

Assessment will take the form of an on-going project assignment with four milestone stages based on a major case study. The project will be syndicate based, with three or four students per syndicate which will require both individual and group work. Each student will act as project manager for a particular stage where appropriate. The milestone reports will be documented with the help of a CASE tool. Students will analyse, design and implement a prototype for a small business system using a 4GL prototyping tool. A demonstration and formal presentation will be expected with all students contributing.

1)Select and apply a methodology appropriate to a particular application domain.
2) Investigate, record and analyse the requirements of a computer based system using a structured methodology. 3)Produce adequate documentation in the form of a feasibility report and requirements specification.
4) Give an account of the need for good project management and the importance of quality in MIS environment.
5) Design and produce a working prototype in a 4GL multi-user environment.
6) Describe the rudiments of systems and data analysis.
7) Apply HCI concepts to the user interface and demonstrate a prototype.
8) Present your findings formally.

AND BE ASSESSED IN THE FOLLOWING COMMON SKILL COMPETENCIES

A. 4. Transfer skills gained to new and changing contexts and situations
B. 6. Relate and interact effectively with individuals and groups
C.7. Work effectively as a team member of a team

A ASSIGNMENT weighted at 25%.
A ASSIGNMENT - SECOND ASSIGNMENT weighted at 25%.
A DEMONSTRATION weighted at 30%.
A PRESENTATION - INDIVIDUAL weighted at 20%.
@

Coursework 100% of which approximately 50% is individually assessed, with the remaining 50% being group-based, comprising:

Milestone 1 a feasibility report worth 25% on outcomes 1,2,3,4,A
Milestone 2 an analysis and design report worth 25% on outcomes 2,3,4 and 6

And worth the remaining 50%:
Milestone 3 a prototype demonstration worth 30% on outcomes 5,6 and 7
Milestone 4 a presentation worth 20% on outcomes 8,B,C