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. What is normalization — reducing redundancy and preventing anomalies
  2. 1NF: atomic values, no repeating groups
  3. 2NF: no partial dependencies
  4. 3NF: no transitive dependencies
  5. Practical example: take a denormalized table and normalize it step by step
  6. When denormalization is acceptable (performance trade-offs, awareness)

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.