Module Title:   Databases and Interfaces (Namal College)

Module Credit:   20

Module Code:   CM-0224D

Academic Year:   2015/6

Teaching Period:   Semester 1

Module Occurrence:   N

Module Level:   FHEQ Level 5

Module Type:   Standard module

Provider:   Computer Science

Related Department/Subject Area:   SCIM (Dept of Computer Science)

Principal Co-ordinator:   Dr P.Trundle

Additional Tutor(s):   Mr M.J.Ridley, Prof D. Neagu

Prerequisite(s):   CM-0117D

Corequisite(s):   None

Aims:
To provide a co-ordinated and consistent coverage of theory, design and development of user interfaces and database systems and their role in building software systems.

Learning Teaching & Assessment Strategy:
The contact time consists of lectures, tutorials and laboratory study. The remainder is given over to private study comprising directed reading, unsupervised laboratory exercises, and coursework assignments.
Students requiring supplementary assessment will repair deficiencies in the original assessments and/or undertake supplementary examination.

Lectures:   12.00          Directed Study:   138.00           
Seminars/Tutorials:   12.00          Other:   0.00           
Laboratory/Practical:   36.00          Formal Exams:   2.00          Total:   200.00

On successful completion of this module you will be able to...

Analyse the database approach and design and application considerations of using a RDMS and the software, hardware and user requirements for user interfaces in the development of software systems

On successful completion of this module you will be able to...

Design a relational database and apply SQL to query and modify data in a RDBMS.
Design, develop and evaluate graphical user interfaces using an appropriate high level language.

On successful completion of this module you will be able to...

Design relational database systems, and implement database systems using SQL.
Evaluate user interface designs and implementations by applying human computer interaction principles.

  Coursework   15%
 
  Two exercises involving the design of a relational database system and use of SQL
  Coursework   50%
 
  An exercise involving the design and development of a user interface from a specification
  Examination - closed book 2.00 35%
 
  Closed Book Examination two hours

Outline Syllabus:
The database approach: advantages and costs; how it contrasts with the conventional file oriented approach. The relational model: what a data model is; the structural part of the relational model (structure of tables, attributes, tuple and keys); the relational algebra; entity and referential integrity rules; architecture of a relational database management system (RDBMS) and its relationship to the relational model; SQL: data query from single and multiple tables. Database design: entity relationship modelling; relational data design; functional dependence; normalisation; physical data design. Database housekeeping: security; concurrency; integrity; database administration. Use of a proprietary relational database management system. Limitations of the relational model: the gap between theory and practice; a brief survey of advanced database systems.
Methods for user interface specifications, user requirements and semantics of HCI. Visual and functional design. Design and development of graphical user interfaces using a modern high level language. Design algorithms and development techniques. Evaluation techniques for user interfaces. System design.

Version No:  1