Core Module Information
Module title: Database Technology

SCQF level: 09:
SCQF credit value: 20.00
ECTS credit value: 10

Module code: SET09702
Module leader: Brian Davison
School School of Computing, Engineering and the Built Environment
Subject area group: Computer Science
Prerequisites

SET08701
C++ Programming
A software development course covering object-oriented techniques

Description of module content:

The module covers four main aspects of relational databases:
Database theory: The relational model is a mathematical construct, and some of the basic concepts can be very useful in understanding the way the technology behaves. This is particularly true for the more technical students who go on to study data warehouses and data mining. Basic set theory, relational algebra and the ANSI-SPARC three level architectural model are covered in this part.
Database design: A key skill for software engineers and for business analysts is to create an efficient relational model of an application context. The design methods specific to relational databases including entity-relationship diagrams and normalisation are covered here.
Database use: The most fundamental database skill is to be able to retrieve required data using well-designed queries. The main vehicle for this is SQL, and this theme is developed over the teaching weeks. As well as learning SQL in isolation using online teaching materials, you will also have access to a stand-alone database application where you can construct your own schema and design and perform your own SQL queries. As part of this theme, other uses of SQL will be introduced which demonstrate its relationship with programming and Web application design.
Database administration: The database administrator (DBA) is a vital role in any information technology department. Some of the main DBA responsibilities will be examined as part of this theme, and you will carry out basic administrative tasks such as backing up and restoring databases. The use of scripts to automate database management processes will also be covered. You will also consider how to secure the database, and how data integrity is ensured.
Object-Relational Databases – data modelling techniques, querying, database implementation: practical utilisation of an advanced database management system to implement a non-relational data model.
Data Warehouses – Why are data warehouses needed? Difference between data warehouses and traditional databases, data modelling techniques, implementation issues
Emerging database techniques, including NoSQL

Learning Outcomes for module:

Upon completion of this module you will be able to
LO1: Design and implement a relational database schema using standard techniques and with reference to current standards.
LO2: Use SQL to access and manipulate relational data.
LO3: Understand and evaluate non-relational alternatives to data modelling.
LO4: Perform basic security and administrative operations on an example database platform.
LO5: Review a selection of emerging database technologies

Full Details of Teaching and Assessment
2023/4, Trimester 2, FACE-TO-FACE,
VIEW FULL DETAILS
Occurrence: 001
Primary mode of delivery: FACE-TO-FACE
Location of delivery: UK PARTNER
Partner:
Member of staff responsible for delivering module: Brian Davison
Module Organiser:


Student Activity (Notional Equivalent Study Hours (NESH))
Mode of activityLearning & Teaching ActivityNESH (Study Hours)
Face To Face Tutorial 140
Independent Learning Guided independent study 58
Face To Face Centrally Time Tabled Examination 2
Total Study Hours200
Expected Total Study Hours for Module200


Assessment
Type of Assessment Weighting % LOs covered Week due Length in Hours/Words
Practical Skills Assessment 60 1,2,5 14/15 HOURS= 40, WORDS= 0
Centrally Time Tabled Examination 40 1,3,4,5 14/15 HOURS= 2, WORDS= 0
Component 1 subtotal: 100
Component 2 subtotal: 0
Module subtotal: 100

Indicative References and Reading List - URL:
Contact your module leader