n/a

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.

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.