This unit will teach the learners relational theory concepts such as normalisation, foreign keys, ensuring consistency, three value logic, indexes for efficiency, database optimisation etc. As an advanced course, it will presume that the learners have some familiarity with basic SQL extraction and manipulation techniques, such as those taught in L4 Unit 8. It will teach how to create various database objects and their benefits, e.g. tables, dynamic/materialised views, triggers, stored procedures, user defined functions etc.