Databases

Overview

• Databases
o Introduction to the fundamental concepts in database systems
o Exploring and solving real world problems using data models and schemas.
o Creating and designing Relational databases including Tables, Fields, Keys and Joins
o Managing a relational database using Structured Query Language (SQL)
o Formal Approaches to Relational Database Design (normalization theory, dependency theory).
o Advanced Topics on Modern Data Management (data extraction, mining, integration).
o Database access from a programming language (e.g. Java) including being able to display, modify, delete and update data on it.

Learning Objectives

Be able to:
• Databases
o Demonstrate knowledge, understanding and the application of the fundamental concepts of basic database systems.
o Demonstrate knowledge, understanding and the application of the fundamental concepts in data modelling and database schemas
o Demonstrate knowledge, understanding and the application of the fundamental concepts of SQL queries to manage a relational database including Create, Insert, Select, Delete and Update.
o Demonstrate knowledge, understanding and the application of using a programming language to connect, manage and execute SQL queries.

Skills

Application of Number, ICT, Improving Own Learning and Performance, Problem Solving.

Assessment

Written Examination. Satisfactory completion of all practical elements.