Registry

Module Specifications

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

Module Title	Database Design
Module Code	CA662
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 a 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 Functional Dependencies and Implement Normalisation of 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	36	No Description
Lab	24	No Description
Independent learning time	127	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

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)

CAPD

PhD

ECSA

Study Abroad (Engineering & Computing)