Registry

Module Specifications

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

Module Title	Computing A
Module Code	CA
School	Oscail
Online Module Resources
Module Co-ordinator	Semester 1: Eamon Costello Semester 2: Eamon Costello Autumn: Eamon Costello
NFQ level	8	Credit Rating	20
Pre-requisite	C2, CT1, HS1, MS001
Co-requisite	None
Compatibles	None
Incompatibles	None

Description

A module which provides students with an understanding of the theory and practice of the construction and use of databases.

Learning Outcomes

1. Describe systems and databases that exist within a variety of organisations.
2. Demonstrate the stages of the database life cycle.
3. Translate data requirements into a database design using a data modelling technique
4. Strengthen the structure of a database through normalisation and testing
5. Construct a physical database using a database package.
6. Use the data from a physical database to produce reports relevant to varying contexts using the structured query language (SQL)
7. Describe the methods for managing a database, including concurrency control and recovery.

Workload	Full-time hours per semester
*Type*	*Hours*	*Description*
Tutorial	15	Face to Face tutorials
On-line learning	16	Tutor supported on-line learning
Independent learning time	469	No Description
Total Workload: 500

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

DATABASES (CA).
Database concepts and DBMS architecture / Storing information and the database function / Entity-relationship modelling / Database components and relational mapping / SQL - the Structured Query Language / Normalisation / The database design process / Logical & physical / Managing a RDMBS / Distributed DBMS / Data Warehousing / Object DBMS.

Assessment Breakdown
Continuous Assessment	50%	Examination Weight	50%

Course Work Breakdown
Type	Description	% of total	Assessment Date
Assignment	Three assignments which build on the previous	50%	n/a

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 3

Indicative Reading List

Other Resources

None

Array

Programme or List of Programmes

BSc in Management of Info Syst/Info Tech

Diploma/BSc in Information Technology

ITS

Diploma/BSc in Information Technology

Timetable this semester: Timetable for CA

Date of Last Revision

08-DEC-10