Registry

Module Specifications

Current Academic Year 2012 - 2013
Please note that this information is subject to change.

Module Title	Database Design
Module Code	CA662A
School	School of Computing
Online Module Resources
Module Co-ordinator	Semester 1: Jane Kernan Semester 2: Jane Kernan Autumn: Jane Kernan
Module Teacher	Jane Kernan
NFQ level	8	Credit Rating	7.5
Pre-requisite	None
Co-requisite	None
Compatibles	None
Incompatibles	None

Description

This module aims to provide students with the skills necessary to understand, design and implement a database using Microsoft SQL Server or Access.

Learning Outcomes

1. Design and construct a database for a real world situation
2. Comprehend how to translate an informal problem specifications into well-formed relational schema.
3. Demonstrate the ability to write SQL to modify and query the data within a relational database.
4. Identify the concept of Funcational Dependencies and implement Normalisation of the relational Database
5. Recognise and deal with constraint violations within the relational database model
6. Explain the concept of Transaction processes and concurrency control

Workload	Full-time hours per semester
*Type*	*Hours*	*Description*
Lecture	18	No Description
Lab	18	No Description
Independent learning time	151	No Description
Total Workload: 187

All module information is indicative and subject to change. For further information,students are advised to refer to the University's Marks and Standards and Programme Specific Regulations at: http://www.dcu.ie/registry/examinations/index.shtml

Indicative Content and Learning Activities

None

Assessment Breakdown
Continuous Assessment	50%	Examination Weight	50%

Course Work Breakdown
Type	Description	% of total	Assessment Date
Project	Use Access to Create a Database	20%	Week 3
Project	Database Design using ER Diagram	10%	Week 6
Practical/skills evaluation	SQL Lab Exam	20%	Week 10

Reassessment Requirement
Resit arrangements are explained by the following categories; 1 = A resit is available for all components of the module 2 = No resit is available for 100% continuous assessment module 3 = No resit is available for the continuous assessment component
This module is category 1

Indicative Reading List

Ramez Elmasri, Shamkant B. Navathe: 2004, Fundamentals of database systems, 4th, Pearson/Addison Wesley, Boston, 0-321-20448-4
by C. J. Date: 2000, An introduction to database systems, 7th, Addison-Wesley, Reading, MA, 0-201-38590-2

Other Resources

None

Array

Programme or List of Programmes

BSSA

Study Abroad (DCU Business School)

BSSAO

Study Abroad (DCU Business School)

ECSA

Study Abroad (Engineering & Computing)

ECSAO

Study Abroad (Engineering & Computing)