I recently had a question with my teacher in databases that could not solve, I would like to ask what is the best way or what is the appropriate way to solve this problem.
As you can see in the photo I have the tables Clientes and Habitacion related but what I do not understand is that by relating them vice versa, I create more relationships in the following tables. This is how sql detects relationships or the program creates them as part of your system.
What is the best way to relate? Clientes to Habitaciones or vice versa?
Sorry to not be so specific, leave me comments to clarify. Thanks
