Week 5

PostgreSQL

Relationships and Constraints

Normalization

Joins

JDBC

SQL Injection2

IoC & DI

Practice

Assignment

Back end Track

Under construction

<aside> 🚧

This page is currently under construction. Please check back later.

</aside>

Implementation plan:

  1. Foreign keys — recap and deeper dive into behavior (ON DELETE?, ON UPDATE?)
  2. One-to-one relationships — when and how to model
  3. One-to-many relationships — the most common pattern
  4. Many-to-many relationships — join/bridge tables
  5. Constraints beyond primary/foreign keys: NOT NULL, UNIQUE, DEFAULT, CHECK
  6. Combining constraints to enforce data integrity
  7. Exercise: design a schema for a given domain (3-4 tables with proper constraints)

The HackYourFuture curriculum is licensed under CC BY-NC-SA 4.0

CC BY-NC-SA 4.0 Icons

*https://hackyourfuture.net/*

Found a mistake or have a suggestion? Let us know in the feedback form.