Module:

Module Specifications..

Current Academic Year 2024 - 2025

Please note that this information is subject to change.

Module Title
Module Code
School
Module Co-ordinator	Semester 1: Jane Kernan Semester 2: Jane Kernan Autumn: Jane Kernan
Module Teachers	Jane Kernan
NFQ level	8	Credit Rating
Pre-requisite	None
Co-requisite	None
Compatibles	None
Incompatibles	None

Repeat the module

Description

This module aims to familiarise the student with all aspects of database deployment in the modern business environment. It aims to ensure that the student has a sound grasp of key database technologies and software architectures and their environments and how these support on business processes and systems. The module gives the student a practical understanding of database deployment. It provides the student with the practical skills which will allow them to understand all aspects of database management from the point of view of provision of timely information to key business processes.

Learning Outcomes

1. Demonstrate a comprehensive understanding of the software architecture of a major database management system which is deployed widely in industry.
2. Apply the development lifecycle of software applications which use database technology. The student will be familiar with the design and implementation and rollout stages of such applications.
3. Design and build basic database applications using a variety of interfaces to the database (e.g. SQL, PHP)
4. Interact with a large database management system and ancillary application systems

*Type*	*Hours*	*Description*
Workload	Full-time hours per semester
Lecture	24	No Description
Laboratory	12	No Description
Fieldwork	24	No Description
Independent Study	65	No Description
Total Workload: 125

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

Database development process
Database development process; developing a database application

Enhanced E-R Model and Business Rules
Representing super-types and sub-types; entity clustering

Logical database design and the relational model
Relational data model, integrity constraints, transforming EER diagrams into relations, normalisation

Physical database design and performance
Physical database design process, designing fields, using and selecting indexes

Client/server database environment
Client/Server architectures

Data Warehousing
Basic concepts of data warehousing, data warehouse architectures, some characteristics of data warehouse data

Data Quality and Integration
Managing data quality, data integration, data transformation

Data and Database Administration
Roles of data and database administrators, managing data security, database backup and recovery

Assessment Breakdown
Continuous Assessment	%	Examination Weight	%

Type	Description	% of total	Assessment Date
Course Work Breakdown
Project	Plan, design and develop a database system	40%	As required

Reassessment Requirement Type
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

Indicative Reading List

Fred R. McFadden, Jeffrey A. Hoffer, Mary B, Prescott: 0, Modern database management, Addison Wesley, 1999, 0201383721

Other Resources

None

Programme or List of Programmes

Archives:

A database error occurred:- Resource id #1

Module Specifications..

Current Academic Year 2024 - 2025