Web Tutor
BSc
Highers
Nationals
Tools
Resources
Web Sites
BNU: BSc in Computing
CO558: Database Design
Relational Database using SQL
Week 4 Activities - Normalisation & Data Modelling
Task
Lesson Activity
Learning Assessment
Skill Developed
3.1
PPT 60 min
Data Environment and Data Modelling
Quiz Answers
Normalisation and Data Modelling
Useful Resources
Book
Read: Chapter One of Modern Database Management by Hoffer, Ramesh and Topi.
Wesbite
TutorialsPoint: Learn DBMS
Tutorial
How to Draw use Entity-Relationship Diagrams in Visual Paradigm
showing you the basics.
Website
Free Entity Relationship Diagram Examples
Video 1 min
Converting Visual Paradigm Conceptual ERD to Logical ERD
Week Index
CO558 Index
Intro to RDBMS
Normalise 1NF
Normalise 2NF 3NF
Data Modelling 1
Data Modelling 2
ERD Case Studies
TCA1 & TCA2
Intro to SQL
SQL Queries
SQL Joins
Advanced SQL
DB Transactions