Course Details in 2025/26 Session

Module Title	LI Databases and Web Programming
School	Computer Science
Department	Computer Science
Module Code	06 40100
Module Lead	Alan Sexton
Level	Intermediate Level
Credits	20
Semester	Semester 1
Pre-requisites
Co-requisites
Restrictions	None
Contact Hours	Lecture-22 hours Supervised time in studio/workshop-11 hours Guided independent study-167 hours Total: 200 hours
Exclusions
Description	This module will introduce standard relational database theory and practice, specifically relational databases in the form of SQL querying, Entity Relationship Attribute modelling and Relational Algebra. Functional Dependencies and relational database design will be covered, as will transactions, transaction processing and isolation levels. There will be practical exercises on using databases in programs. A short introduction to NOSQL databases will be given. The second part of the module will teach the development of web and/or mobile applications using databases.
Learning Outcomes	By the end of the module students should be able to: 20.1 Understand and use SQL. 20.2 Design conceptual, logical and physical relational databases using Entity Relationship Attribute (ERA) diagrams and normalisation theory. 20.3 Understand the role of relational algebra in query optimisation and its relationship to SQL. 20.4 Structure database operations as transactions, and demonstrate an understanding of the impact this has on database behaviour and performance. 20.5 Implement operations on databases in programs. 20.6 Discuss NOSQL concepts and uses. 20.7 Implement practical web and/or mobile applications with a database back end.
Assessment
Assessment Methods & Exceptions	Assessment: Assessment: 2 hour written unseen exam (50% Continuous assessment (50%) Reassessment: Examination (100%) in the August Supplementary period
Other
Reading List