Level 75
Depends on how relations need to be setup. School has students. Student belongs to a school.
Re-study some of the relation examples from documentation.
1 like
Jan 7, 2023
3
Level 8
School database relationships
Hello, I have a schools table, a classes table, and a students. The schools table and the classes table are related through a foreign key on the classes table. The same goes for the classes table and students table.
My question is, If I want to list all the students from a school, should I loop through all the classes and then get the students? Is it bad practice or redundant to add an extra foreign key to the student's table that refers to the school id?
Level 3
hopefully this will help u: https://www.youtube.com/watch?v=5s-_SnVl-1g
1 like
Level 8
@Rumnaz khan thanks! This is what I was looking for.
Please or to participate in this conversation.