Week 1

This session is about understanding the entity relationship model, being able to use that knowledge and implement it building a database schema. With the database schema created, you should be able to create a database and test it using SQL statements.

Contents

• Preparation

• Session Plan (for mentors)

• Assignment

Learning Goals

By the end of this session, you will be able to:

• Create an entity relationship diagram from a description of data requirements

• Translate a simple entity relationship diagram into a database schema

• Use SQL CRUD operations for more complex scenarios (INSERT with Foreign keys, DELETE with filters)

• Use foreign keys to establish relationships between tables

• Write SQL queries to retrieve related data using JOIN operations

Main Topics

• Entity-Relationship Diagrams (ERDs):

  • Introduction to ERDs

  • Components: Entities, Attributes, Relationships (1:1, 1:M, M:M)

• Translating ERDs to Database Schema:

  • Mapping rules for tables, columns, primary keys (PKs), and foreign keys (FKs)

• Working with Related Data:

  • Foreign Keys and Constraints (ON DELETE, ON UPDATE actions)

  • SQL JOIN Operations (INNER JOIN, LEFT JOIN)