Web Tutor
BSc
Highers
Nationals
Tools
Resources
Web Sites
BNU: BSc in Computing
CO558: Database Design
Relational Database using SQL
Week 5 Activities - Data Modelling in the Organisation
Task
Lesson Activity
Learning Assessment
Skill Developed
3.1
PPT 60 min
McDonalds Normalisation and Data Modelling
PPT 60 min
Discusion Questions with Kompel
ERD
Normalisation and Data Modelling
Useful Resources
Book
Read: Chapter Two 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