RPrisma
A relation is a connection between two models in the Prisma schema. This page explains how you can define one-to-one, one-to-many and many-to-many relations in Prisma.
RAny relational db will have foreign keys.
Cany sql database will get the job done
Cif your goal is specifically to learn about sql i might suggest somethign thats a bit less abstracted than prisma
Cfor example kysely
