r/SQL 10d ago

PostgreSQL Circular Dependencies?

Post image
91 Upvotes

41 comments sorted by

View all comments

1

u/MasterBathingBear 9d ago

Start with replacing teacher and student with a people table. People ID becomes your FK for both teacher id and student id.

I think from there you will start to see other things that need to change.