Database Design and Development_L5DC_DIA

Database Design and Development_L5DC_DIA

This module builds on a basic understanding of database concepts to develop students’ skills in the design and development of databases and database management systems, as well as investigating enterprise applications of databases.

Lecturer Guide: This guide contains notes for lecturers on the organisation of each topic, and suggested use of the resources. It also contains all of the suggested exercises and model answers.

PowerPoint Slides: These are presented for each topic for use in the lectures. They contain many examples which can be used to explain the key concepts. Handout versions of the slides are also available; it is recommended that these are distributed to students for revision purposes as it is important that students learn to take their own notes during lectures.

Student Guide: This contains the topic overviews and all of the suggested exercises. Each student will need access to this and will need to bring it to every taught hour
for the module.

This module also makes use of SQL. You may choose which version of SQL is to be used but students will need to have access to this during laboratory and private study time. You may wish to consider MySQL. This is open source software which is available from

Pedagogic Approach

Suggested Learning Hours

Lectures: Tutorial: Seminar: Laboratory: Private Study: Total:
24 24 - 12 90 150
The teacher-led time for this module is comprised of lectures, laboratory sessions and tutorials. The breakdown of the hours is also given at the start of each topic.

Lectures are designed to start each topic and PowerPoint slides are presented for use during these sessions. Students should also be encouraged to be active during this time and to discuss and/or practice the concepts covered. Lecturers should encourage active participation wherever possible.

These are designed to deal with the questions arising from the lectures and private study sessions.For some topics these will be structured sessions with students engaging in tasks related to the lecture. Other sessions will involve problem solving and trouble-shooting discussions related to the practical work.

Laboratory Sessions
During these sessions, students are required to work through practical tutorials and various exercises. The bulk of the tutorial sessions will be related to gaining a sufficient level of mastery of the chosen database tool and the SQL language sufficient to implement the assessment task.Students will be introduced to relevant topics in SQL in the laboratory sessions and this learning will be augmented by lecture and tutorial sessions. The details of these are provided in this guide and also in the Student Guide.

Private Study
In addition to the taught portion of the module, students will also be expected to undertake private study. Exercises are provided in the Student Guide for students to complete during this time.Teachers will need to set deadlines for the completion of this work. These should ideally be before the tutorial session for each topic, when Private Study Exercises are usually reviewed.

This module will be assessed by means of an assignment worth 50% of the total mark and an examination worth 50% of the total mark. These assessments will be based on the assessment criteria given above and students will be expected to demonstrate that they have met the module’s learning outcomes. Samples assessments are available through the NCC Education Campus ( for your reference.

Assignments for this module will include topics covered up to and including Topic 7. Questions for the examination will be drawn from the complete syllabus. Please refer to the Academic Handbook for the programme for further details.

Further Reading List
A selection of sources of further reading around the content of this module must be available in your Accredited Partner Centre’s library. The following list provides suggestions of some suitable

Benyon-Davies, P. (2003). Database Systems, 3rd Edition. Palgrave Macmillan. ISBN-10: 1403916012 ISBN-13: 978-1403916013
Connolly, T. and Begg, C. (2003). Database Solutions: A step-by-step guide to building database,