Syllabuses - UG

CS209 - User & Data Modelling

TIMETABLETEACHING MATERIAL
Credits20
Level2
SemesterSemester 1, Semester 2
AvailabilityPossible elective
PrerequisitesCS104 - Information & Information Systems
Learning Activities BreakdownLectures: 40 | Labs: 40
Assignments: 60 | Self study: 60
AssessmentThe class will be assessed 100% via coursework, 50% in semester 1 and 50% in semester 2. The coursework will be composed of  individual projects  and reports on problem-based learning activities. All group assessments will contain an element of peer-assessment.
LecturerClemens Kupke, Gennaro Imperatore

Aims and Objectives

To provide the student with a critical appreciation and understanding of how to model user activities and the data to support them, together with how to implement systems and databases to support user activities.

Learning Outcomes

On completion of this class, a student should be able to:

  • Design, using suitable annotations, models for human tasks, system interactions, data and database systems;
  • Design and conduct a range of usability evaluation methods;
  • Appreciate the importance of user-centred design and of key aspects of human psychology and physiology for interactive systems design;
  • Critique systems for their usability using a range of criteria;
  • Design and implement a database system, starting from an informal specification through implementation in a relational database management system to querying in SQL;
  • To show an appreciation of the facilities and services which should be provided by a fully featured database management system;
  • To demonstrate knowledge of commonly occurring data models;
  • To display knowledge of potential future developments in database and interactive system technology

Syllabus

  • Introduction to the Database Environment: functions of a database management system; data dictionary systems; database administration. Entity Relationship modelling. The Relational Data Model and its Implementations: relational query languages; normalisation. Object oriented, object relational and other data models. Distributed databases. Indexing. Web databases.
  • Modelling user requirements; human perceptual, cognitive and motor skills; communication theories; dialogue guidelines; screen design; input/output manipulation; dialogue specification techniques; iterative interface prototyping; accessibility. Formative and summative evaluation methods; experimental design and analysis. Case studies.

Recommended Reading

This list is indicative only – the class lecturer may recommend alternative reading material. Please do not purchase any of the reading material listed below until you have confirmed with the class lecturer that it will be used for this class.

Database Systems: A Practical Approach to Design, Implementation and Management, 4th edition, Thomas M. Connolly and Carolyn E. Begg Pearson, 2005, ISBN 9780321210258

An Introduction to Database Systems, 8th edition, C.J. Date , Addison Wesley, 2004, ISBN 9780321197849

The Design of Everyday Things Donald A. Norman, Basic Book, 2002, ISBN 0465067107

Human-computer Interaction, 3rd edition Alan J. Dix, Janet E. Finlay, Gregory D. Abowd, Russell Beale, Prentice Hall, 2004, ISBN 9780130461094.

Last updated: 2024-01-26 00:14:24