BNU: BSc in Computing

CO558: Database Design

Relational Database using SQL

Learning Outcomes

  1. LO1: Construct a relational data model (entity relationship diagram)
  2. LO2: Apply the techniques of normalisation to 3NF
  3. LO3: Use SQL DML to query a relational database
  4. LO4: Explain the role of concurrency control and database recovery in large a scale database environment

Module Plans

BNU CO558 Module Plan 2018-2019

Assessments

Module Weekly Plan

Week Date Subject Content Practical
1 Oct 04 Intro to Relational Databases Exercise 1
2 Oct 11 Flat Files & Normalisation 1NF: Normalisation Examples
3 Oct 18 Normalisation 2NF and 3NF 2NF and 3NF Examples
4 Oct 25 Data Environment and Data Modelling Normalisation Examples
5 Nov 01 Normalisation and Modelling Modelling McDonalds
6 Nov 08 ERD Case Studies ERD Diagrams
7 Nov 15 Normalisation & ERD TCA 1
8 Nov 22 Introduction to SQL SQL Queries
9 Nov 29 SQL Queries CRUD SQL Queries
10 Dec 06 SQL Join Queries SQL Queries
11 Dec 13 Advanced SQL TCA 2 ERD
12 Dec 20 Transaction Management TCA 3 SQL
VACATION
13-15 Jan 10 - Jan 29 Database Administration
TCA 4
Re-sit TCAs
SUBMIT CW2

Useful Resources