Module Descriptors
DATABASE SYSTEMS ANALYSIS, DESIGN AND IMPLEMENTATION
COIS30514
Key Facts
Faculty of Computing, Engineering and Sciences
Level 3
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 100%
Module Details
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
Hoffer J.A et al, (2002) Modern Systems Analysis and Design, (3rd edition), Prentice Hall, ISBN 0-13-033990-3
Module Additional Assessment Details
A coursework assignment worth 100% which will assess Learning Outcomes 1 to 3.
The coursework will involve the design and implementation of a computing solution to a given case study.
Module Learning Strategies
A variety of learning strategies will be employed, including lectures (1-n) 1, practical and tutorial sessions (1-20) 2.
Module Indicative Content
Introduction to structured methods
- Requirements capture
- Process Modelling
- Data Modelling
- Event modelling
- Models to include documentation e.g. entity descriptions, process descriptions
- 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