Module: Database Theory & Practice

Module Specifications.

Current Academic Year 2024 - 2025

All Module information is indicative, and this portal is an interim interface pending the full upgrade of Coursebuilder and subsequent integration to the new DCU Student Information System (DCU Key).

As such, this is a point in time view of data which will be refreshed periodically. Some fields/data may not yet be available pending the completion of the full Coursebuilder upgrade and integration project. We will post status updates as they become available. Thank you for your patience and understanding.

Date posted: September 2024

Module Title	Database Theory & Practice
Module Code	CA (ITS) / ICT1001 (Banner)
Faculty	Engineering & Computing	School	Electronic Engineering
Module Co-ordinator	Richard Bolger
Module Teachers	-
NFQ level	8	Credit Rating	20
Pre-requisite	Not Available
Co-requisite	Not Available
Compatibles	Not Available
Incompatibles	Not Available

None
Array

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. (Assignment 1)
4. Strengthen the structure of a database through normalisation and testing. (Assignment 3)
5. Construct a physical database using a database package. (Assignment 2)
6. Use the data from a physical database to produce reports relevant to varying contexts using the structured query language (SQL). (Assignment 2 & 3)
7. Summarise the various storage structures available to a database along with their associated characteristics.
8. Describe the methods for managing a database, including concurrency control and recovery. (Assignment 3)
9. Analyse the challenges that Big Data poses to the tradition RDBMS.
10. Construct a NoSQL document database and perform CRUD (Create, Retrieve, Update and Delete) operations on it

*Type*	*Hours*	*Description*
Workload	Full-time hours per semester
Tutorial	21	Face-to-face tutorials are held in DCU on Saturdays and Virtual Classroom tutorials on weekday evenings according to the timetable
Online activity	16	Interaction with tutor and fellow students
Independent Study	463	Reading, study, research and problem solving
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 / Big Data/NoSQL / MongoDB

Assessment Breakdown
Continuous Assessment	50%	Examination Weight	50%

Type	Description	% of total	Assessment Date
Course Work Breakdown
Assignment	Written assignment	10%	n/a
Assignment	Written assignment	20%	n/a
Assignment	Written assignment	20%	n/a

Reassessment Requirement Type
Resit arrangements are explained by the following categories: Resit category 1: A resit is available for both* components of the module. Resit category 2: No resit is available for a 100% continuous assessment module. Resit category 3: No resit is available for the continuous assessment component where there is a continuous assessment and examination element.
* ‘Both’ is used in the context of the module having a Continuous Assessment/Examination split; where the module is 100% continuous assessment, there will also be a resit of the assessment
This module is category 1

Indicative Reading List

Other Resources

None