Menu
close
Apply Now
Contact
Parent Programme
Bachelor in Computing (Level 7 NFQ)
NFQ Level & Reference
Level 6 / Ref: M2.6
Duration
12 Weeks X 3 Hours per week
MODULE TITLE
Data Storage & Database Management 2
STAGE
2
Module Credit units
ECTS: 5

Data Storage and Database Management Module

Introduction to Databases

The Data Storage and Database Management Module introduces the learners to the core principles and concepts of relational databases, the rationale, and role of Database Management Systems (DBMS) in information systems, while introducing the basics of NoSQL and database application development.

Indicative Syllabus Content

Introduction to Databases                                                                                    

  • The need of data storage in information systems
  • Introduction to Databases
  • Role of Databases in information systems
  • History of Database Systems
  • Various types of databases, including relational and NoSQL
  • The requirement for a DBMS (Database Management System)
  • DBMS Architecture
  • Future trend of Databases

Relational model:

  • Introduction to Relational Model
  • Rational model terminology
  • How information is represented in the Relational Model.
  • Properties of database relations
  • Relation keys - Candidate Key, Primary key, Alternate Keys, Foreign Key
  • Relational Algebra Operations

Relational Database Basics:

  • Rationale behind Relational Database Systems
  • Key relational database concepts such as tables, rows, columns, and relationships
  • Purpose and advantages of views

Relational database management system (RDBMS) Practical

  • RDBMS choices
  • Create MySQL databases and manage them using MySQL Workbench or command-line interface (CLI)
  • Develop proficiency in writing SQL queries tailored for MySQL syntax and functionality
  • Apply MySQL-specific data types and constraints to maintain data integrity and optimize storage efficiency

Structure Query Language (SQL) basics:

  • Purpose and importance of SQL
  • Utilize SQL to create databases and tables, incorporating appropriate data types and constraints
  • Utilize SQL to retrieve data from single and multiple tables
  • Utilize SQL to insert, update, and delete data while maintaining data integrity

Complex SQL Queries:

  • Utilize SQL features, including grouping, joins and aggregation, etc.
  • Employ transactions to ensure atomicity, consistency, isolation, and durability (ACID properties)
  • Manage privileges and control access using SQL commands

Minimum Intended Learning Outcomes (MIMLOs)

Upon successful completion of this module, the learner should be able to:
MIMLO1
Assess the role of database systems in model information management.
MIMLO2
Differentiate between various type of database systems, including relational and NoSQL.
MIMLO3
Define key relational database concepts.
MIMLO4
Utilize SQL to create databases and tables, incorporating appropriate data types and constraints, ensuring data integrity and relational integrity.
MIMLO5
Construct complex SQL queries including subqueries, grouping, joins and aggregation.

Assessment

MIMLOs
Assessment
Percentage
1, 2, 3, 4, 5
CA 1 & CA2 - Practical Lab Examinations
Total 100%
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:

  • Introduce students to the core principles and concepts of relational databases.
  • Explore the role of relational databases in modern information systems.
  • DBMS architecture and the transition from traditional databases to NoSQL.
  • Develop basic proficiency in SQL for database creation, manipulation, and query.
[TheChamp-Sharing]
APPLY NOW
Top