This session will focus on understanding how to create a data model using E-R Diagrams, Class Diagrams and Normalisation.

Resources »

Learning Outcomes

  1. 2. Understand database design techniques

Assessments

  1. 9th Mar 2017 Assessment A17.1: Database Systems Final

Week 2 Activities - Entity - Relational Modelling

Week Lesson Activity Learning Assessment Skill Developed

analyse a database developmental methodology

discuss entity-relationship modelling and normalisation

1.1
  • 30 min Create a conceptual E-R Diagram for you chosen unique e-commerce example
  • 30 min Note down any assumed business rules, and any alternative arrangements
  • 15 min Produce a logical E-R Diagram from the conceptual E-R Diagram. Identify the data types and document the attributes
  • 30 min Presentation on Normalisation
  • 30 min Check that the diagram is in third normal form (3NF) and make notes of any changes.
  • 30 min Produce a Physical E-R Diagram from the Logical E-R Diagram. Identify the primary keys and relationships
  • 15 min Produce a Class Diagram from the Physical E-R Diagram
  • 15 min Create the database from the Physical ERD
  • Questions and Answers
  • ERDs
  • Class Diagram
  • Database
  • Notes
  • Entity-Relational Modelling
  • Normalisation
1.2
  • Questions and Answers
  • Example NoSQL DB
  • NoSQL DB

Entity Relationship Modelling & Normalisation

Lesson Index