DCU Home | Our Courses | Loop | Registry | Library | Search DCU

Module Specifications..

Current Academic Year 2023 - 2024

Please note that this information is subject to change.

Module Title Database Theory and Practice
Module Code CA
School School of Electronic Engineering
Module Co-ordinatorSemester 1: Richard Bolger
Semester 2: Richard Bolger
Autumn: Richard Bolger
Module TeachersRichard Bolger
Edel Hester
NFQ level 8 Credit Rating 20
Pre-requisite C2, CT1, HS1, MS001
Co-requisite None
Compatibles None
Incompatibles None

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

Workload Full-time hours per semester
Type Hours Description
Tutorial21Face-to-face tutorials are held in DCU on Saturdays and Virtual Classroom tutorials on weekday evenings according to the timetable
Online activity16Interaction with tutor and fellow students
Independent Study463Reading, 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

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 Assessment50% Examination Weight50%
Course Work Breakdown
TypeDescription% of totalAssessment Date
AssignmentWritten assignment10%n/a
AssignmentWritten assignment20%n/a
AssignmentWritten assignment20%n/a
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 1
Indicative Reading List

    Other Resources

    Programme or List of Programmes
    CSSECert in Software Sys & Entrepreneurship
    HDSDHigher Diploma in Software Development
    ISBSc in Management of Info Tech/Info Syst
    ITBSc in Information Technology
    ITSDiploma/BSc in Information Technology
    Date of Last Revision08-DEC-10

    My DCU | Loop | Disclaimer | Privacy Statement