Module Title:   Relational Databases

Module Credit:   20

Module Code:   CY-0117L

Academic Year:   2015/6

Teaching Period:   Semester 1

Module Occurrence:   A

Module Level:   FHEQ Level 4

Module Type:   Linked 10+10

Provider:   Computer Science

Related Department/Subject Area:   School of Electrical Engineering & Computer Science

Principal Co-ordinator:   Dr M. Kamala

Additional Tutor(s):   Mr D Forbes

Prerequisite(s):   None

Corequisite(s):   None

Aims:
To provide an understanding of the concepts and principles of relational databases. To develop the skills of database programming language usinf MS Access, structured database design and information relations.

Learning Teaching & Assessment Strategy:
This module is primarily based around laboratory practical sessions during which the topics encountered during the lectures and seminars are explored. The remainder is made up of preparation of coursework, private study and directed reading.
For the practical coursework students would normally be expected to dedicate 15 hours of work to this item (25%).
The students required to take supplementary assessment are required to repair the deficiency in the original assessment.

Lectures:   18.00          Directed Study:   128.00           
Seminars/Tutorials:   6.00          Other:   0.00           
Laboratory/Practical:   48.00          Formal Exams:   0.00          Total:   200.00

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

Knowledge of the basic underlying concepts and principles of relational databases including being conversant with the major developments in this field.

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

The development of practical ability in the use of the MS Access database programming with the support of using Visual Basic.

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

The development of problem solving skills through database design.

  Coursework   50%
 
  Lab coursework at the end of semester 1
  Coursework   50%
 
  Presentation of a functional database accompanied by a report of about 1000 words at the end of semester 2

Supplementary Assessment:
As Original

Outline Syllabus:
The basics of relational databases. One to One, One to Many relations. The development of simple database. The database structuring. Tables, Queries, forms, reports, macros and Modules. Awareness of different types of databases, DBMS and RDBMS.

Version No:  4