Apply Now
Contact
Parent Programme
Bachelor of Science in Computing (Level 7 NFQ)
MODULE NFQ
Level 6
MODULE CREDIT UNITS
ECTS: 10
MODULE TITLE
Data Storage & Database Management
Reference Code: M2.8
STAGE
Year 2
Semester 1 & 2
26 Weeks X 3 Hours per week

Data Storage and Database Management Module

Introduction to Databases

The Data Storage and Database Management module creates an in-depth understanding of the role of data storage and database systems in information management as well as the fundamentals of relational database architecture, management systems and techniques for database application development.

  • History of Database Systems
  • Rationale behind Database Systems
  • Role of Databases in information systems
  • The requirement for a DBMS (Database Management System)
  • DBMS Architecture.
  • Future trend of Databases.
  • Introduction to Web Database.
  • Basics of Database Application Development.
  • Basic of NoSQL

Data Modeling and Data Normalisation

  • The Relational Model and Relational algebra
  • Terminology for Relational Model
  • How information is represented in the Relational Model
  • Properties of database relations
  • Primary Key, Foreign Key and Candidate Key of a Relational Model
  • Purpose and advantages of views
  • Use Entity-Relationship modelling in the database design
  • Conceptual data model, logical data model and physical database model
  • Entity integrity and referential integrity
  • Purpose of normalisation and how it can be used when designing a relational database
  • The Normalisation process: 1st, 2nd and 3rd normal forms

Structure Query Language

  • Purpose and importance of SQL
  • Utilise SQL to create database, define tables and constraints
  • Utilise SQL to query database
  • Utilise SQL to update, modify and delete to manipulate data in a database
  • Advanced SQL features, Using grouping, joins and aggregation, etc.
  • Manage privileges and control access using SQL commands
  • NoSQL.

Database Administration - Data Storage and Database Management

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

Minimum Intended Learning Outcomes (MIMLOs)

Upon successful completion of this module, the learner should be able to:
LO1
Assess the role of database systems in information management.
LO2
Demonstrate an in-depth knowledge of the concept of data modelling.
LO3
Apply entity-relationship modelling in designing a database solution.
LO4
Construct tables and views ensuring data integrity and relational integrity.
LO5
Utilise SQL to create, update and query a database.
LO6
Create appropriate efficient database designs and implementations for a range of simple applications.
LO7
Explain the role(s) of a database administrator, data management, backup and recovery.

Assessment

MIMLOs
Assessment
Percentage
1, 2, 5 and 7
Assignments (x2)
30%
2, 3, 4, 5, 6
Mid-semester Practical Lab Examination
20%
1-7
Final Written Examination
50%

Aims & Objectives

This module creates an in-depth understanding of the role of data storage and database systems in information management as well as the fundamentals of relational database architecture, management systems and techniques for database application development.

This module will ensure learners meet the following objectives:

  •  Introduce the use and importance of data storage and database technology in information systems.
  •  Provide the learner with data modelling skills.
  •  Build the practical skills required to define and manipulate data in a relational database.
APPLY NOW
Top
X