BNU: BSc in Computing

Week 6 Activities - ERD Case Studies

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