BNU: BSc in Computing

CO558: Database Design

Relational Database using SQL

Week 7 Activities - ERD & Normalisation TCA

Task	Lesson Activity	Learning Assessment	Skill Developed
3.1	PPT 60 min ERD and Normalisation TCA 60 min TCA 1 Normalisation TCA 60 min TCA 2 ERDs	TCA 1, TCA2	Normalisation, ERD Modelling

Useful Resources

Wesbite What is Normalisation? 1NF, 2NF, 3NF
Tutorial DBMS - Normalisation showing you the basics.
Website Ultimate ER Diagram Tutorial ( Entity Relationship Diagrams )

Week Index