Module title: Database Systems

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

Module code: INF08104
Module leader: Brian Davison
School School of Computing
Subject area group: Creative and Social Informatics
Prerequisites

N/A


Description of module content:

The module covers these aspects of 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 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 be able 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 all 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.

Non-relational database systems: While the focus of the module is on relational databases you will learn about some alternatives technologies such as NoSQL.

Security: You will learn about some of the threats to database security and availability. Access to a fast, secure enterprise-wide database is essential for many organisation. You will learn techniques to protect database resources from accidental or deliberate damage or disclosure; these include password hashing and SQL injection protection.

Learning Outcomes for module:

Upon completion of this module you will be able to
LO1: Describe database architecture with reference to current standards.
LO2: Design and implement a relational database schema using standard techniques.
LO3: Use standard languages to access and manipulate data.
LO4: Perform basic administrative operations on an example database platform.
LO5: Secure database systems against unauthorised access.

Indicative References and Reading List - URL:

Recommended - THOMAS M CONNOLLY AND CAROLYN E. BEGG (2015) DATABASE SYSTEMS : A PRACTICAL APPROACH TO DESIGN, IMPLEMENTATION AND MANAGEMENT: PEARSON, 6th ed. - ISBN: 1292061189
Click here to view the LibrarySearch.