Module Descriptors
DATABASE SYSTEMS ANALYSIS, DESIGN AND IMPLEMENTATION
COIS30721
Key Facts
Faculty of Computing, Engineering and Sciences
Level 3
15 credits
Contact
Leader: Clare Stanier
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 Learning Strategies
A variety of learning strategies will be employed that will include 12 hours of lectures to deliver both the theoretical aspects as well as introducing a number of useful techniques, 24 hours of practical sessions will support the underlying knowledge and skills required to complete the module, and will be faciltated with booklets, course texts, and the internet. Guided study will also be given that can be carried out during non-contact time.
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
Module Resources
A proprietary CASE tool such as QSEE Superlite
A proprietary database tool such as MS Access or SQL Server
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 Texts
Hoffer, George & Valacich (2011) Modern Systems Analysis and Design, Prentice Hall, ISBN-13: 9780136088219
Valacich, George and Hoffer (2012) Essentials of Systems Analysis and Design, Prentice Hall, ISBN-13: 9780137067114
Module Special Admissions Requirements
None.