Module Descriptors
ANALYSIS AND DESIGN FOR DATABASE SYSTEMS
XCOM41068
Key Facts
Faculty of Computing, Engineering and Sciences
Level 4
15 credits
Contact
Leader:
Email:
Hours of Study
Scheduled Learning and Teaching Activities: 36
Independent Study Hours: 114
Total Learning Hours: 150
Assessment
  • COURSEWORK weighted at 50%
  • EXAMINATION - UNSEEN IN EXAMINATION CONDITIONS weighted at 50%
Module Details
Module Additional Assessment Details
A coursework assignment worth 50% which will assess Learning Outcomes 2 and 3. The coursework will be to design and implement a computing solution to a given case study.
An examination of 2 hours duration worth 50% which will assess Learning Outcomes 1, 2, 3 and 4.
Module Indicative Content
Systems Analysis and Design in Context:
- What constitutes a system?
- The traditional systems development life cycle

Introduction to structured methods
- Requirements capture
- Process Modelling
- Data Modelling
- Event modelling
- Models to include documentation e.g. entity descriptions, process descriptions
- Correlation of different models process-data, data-event, process-event
- Use of CASE tools

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 (typically using Microsoft Access)
- Implementation of HCI principles to screen design

- Comparison of current methodologies and the consequent corresponding methods for application domains Prototyping ( e.g. RAD ), Soft Systems, SDLC (e.g. SSADM), OO (e.g. RUP), Multimedia/Web-based (e.g. WISDM)
Module Learning Strategies
There will be 12 hours of lectures(full group) and 24x 1 hour long practical sessions (groups of 20)
Self directed study
Case studies
(1:n)1 (1:20)2
Module Resources
MS. Access Database Management System
A CASE tool for the construction of Data Flow Diagrams and Entity Relationship Diagrams
Module Special Admissions Requirements
None.
Module Texts
Essential Reading:
Software System Development - A Gentle Introduction 3rd Edition, Britton & Doake, 2003, McGraw Hill, ISBN 0077099745

Recommended Reading:
How to do everything with Access 2002, Anderson, 2002, McGraw Hill, ISBN: 0072132752