The following course learning outcomes are assessed by completing this assessment:•K4. design a relational database for a provided scenario utilising tools and techniques including ER diagrams, relation models and normalisation•K5. describe relational algebra and its relationship to Structured Query Language (SQL);•A1. design and implement a relational database using a database management system;