Apply Now
Parent Programme
Bachelor in Computing (Level 7 NFQ)
NFQ Level & Reference
Level 6 / Ref: M2.12
12 Weeks X 3 Hours per week
Data Storage & Database Management 2
Module Credit units

Data Storage and Database Management Module 2

Introduction to Database Management

This Data Storage and Database Management 2 module follows on from the semester 1 module and delves deeper into data modelling and data normalization, reinforcing knowledge with practical application in relational database design, and introducing database administration including security, backup, and recovery processes.

Indicative Syllabus Content

Data Storage and Database Management 2

Entity-Relationship (ER) modelling:

  • Differentiate between conceptual data model, logical data model and physical database model
  • Define key concepts in ER modelling, including entities, attributes, relationships, and cardinality
  • Differentiate between entity types and relationship types in an ER diagram
  • Determine the cardinality and participation constraints of relationships based on business rules
  • Identify entities and their attributes from real-world scenarios or business requirements
  • Define appropriate data types and constraints for entity attributes in an ER model

Database Normalization:

  • Purpose of normalization and how it can be used when designing a relational database
  • Define the concept of normalization and its importance in relational database design
  • Identify common data anomalies (such as insertion, update, and deletion anomalies) that normalization aims to mitigate
  • Understand the concept of functional dependencies between attributes within a relational schema
  • Identify functional dependencies and determine candidate keys in a given set of attributes
  • The Normalization process: 1st, 2nd, and 3rd normal forms
  • Validate the normalization process by analysing the resulting schema
  • Verify that the normalized schema preserves data integrity and minimizes redundancy

Basic Database Application Development:

  • Explain the client-server architecture of database applications
  • Establish database connections in a programming language
  • Implement connection pooling and resource management for efficient database access

Database Security and Administration:

  • Introduction to Database Administration
  • Database administration tasks
  • Database security features: Access control, user privileges and roles in Databases
  • Data protection and Data retention issues
  • Database backup and recovery strategies.

Minimum Intended Learning Outcomes (MIMLOs)

Upon successful completion of this module, the learner should be able to:
Demonstrate an in-depth knowledge of the concept of data modelling.
Apply entity-relationship modelling in designing a database solution.
Apply normalization techniques to eliminate various type of data redundancy and dependency issues.
Perform database administration tasks such as user management, backup and recovery.
Implement security measures to protect database against unauthorised access.


1, 2, 3, 4, 5
CA 1 Assignments
Total 100%
Final Written Examination
All Assessments

Reassessment Opportunity

Where the combined marks of the assessment and examination do not reach the pass mark the learner will be required to repeat the element of assessment that they failed. Reassessment materials will be published on Moodle after the Examination Board Meeting and will be aligned to the MIMLOs and learners will be capped at 40% unless there are personal mitigating circumstances

Aims & Objectives

This module will ensure learners meet the following objectives:

  • Deepen understanding of the relational model, relational algebra, and data normalization.
  • Teach data modelling techniques and the process of normalization up to the 3rd normal form.
  • Provide insights into database administration tasks, emphasizing security and data protection and backups.