Week 5 - Database design

Relational Databases

Primary Keys and Foreign Keys

Constraints

Database normalization

PostgreSQL setup

Joins

Java and databases

Practice

Assignment

• Teachers

Back end Track

Content

Let’s get practical

🔑 Primary Keys and Foreign Keys — exercises

Exercise: Identify the Primary Key

Exercise: Relationships and Foreign Keys

🛃 Constraints — exercises

Exercise: Choose the right constraint

Exercise: Spot the constraint violations (data audit)

Exercise: Design constraints for a mini schema

💾 Database normalization — exercises

Exercise: Spot repeating groups + anomalies

Exercise: Normalize to 1NF (atomic values)

Exercise: Normalize to 2NF + 3NF (decompose)

Exercise: Functional dependencies (quick check)

🫂 Joins — exercises

Exercise: Album, track, and artist names

Exercise: Labels and albums

Exercise: Looking for friends

🧑‍💻 Java and Databases — exercises

Exercise: Set up JDBC and test the connection

Exercise: CRUD with PreparedStatement

Exercise: Mapping rows to objects (1:N)

Exercise: SQL injection awareness

Submission / self-check

• [ ] I can explain my schema design choices
• [ ] I can create a database and all its tables in PostgreSQL
• [ ] I can collect results from multiple tables in a single query via joins
• [ ] I can connect Java to Postgres and run parameterized queries

The HackYourFuture curriculum is licensed under CC BY-NC-SA 4.0 *https://hackyourfuture.net/*

Built with ❤️ by the HackYourFuture community · Thank you, contributors

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