Relational Databases
Primary Keys and Foreign Keys
Constraints
Database normalization
PostgreSQL setup
Joins
Java and databases
Practice
Assignment
Back end Track
Week 5 Overview
In this week, we will go over the following:
- Theory: Relational databases
- You may remember this term from week 12 in the Core Program. If not, it is advised to go over that chapter again. There will be some repetition of those concepts in this week’s lessons.
- Practice: using SQL and Java Database Connectivity (JDBC)
- Using SQL to set up a relational database
- Using Java (instead of SQL) to work with databases.
Learning goals
- Learn how to design a database, with the right tables, columns, relationships, and constraints
- Implement such a database in postgres
- Work with the postgres database using Java
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.
https://hub.hackyourfuture.nl/The-Relational-Model-2fb50f64ffc98139bd57e93695c08051