3
I have a slight knowledge of the database and I know how to use it JOINfor certain SELECTs. I am mounting a simple DB where I have certainty absolute that a table has no relations with others. Is it mandatory? There is something related in good practices about this?
4
No, on the contrary. Only engage in relationships where you need to. Do anything only if you can adequately justify it. In fact the most commonly used form of relationships is by JOIN and nothing is needed beforehand for it to work. Just make sure it has all the necessary indexes to get the best performance.
This would be good practice, although the best is to understand the functioning of a database to know what to do in all situations.
Using a database that supports relationships, and not using them, compared to a non-relational database is a disadvantage ?
Depends, If you don’t need it with certainty no. Whether you need it can be or not. I never use and know other programmers much better than me who never use. It’s not a magic formula.
Browser other questions tagged sql database modeling mysql-workbench
You are not signed in. Login or sign up in order to post.
No, it is not mandatory for one table to be related to another, however the relationships in a data model are the most important part of this model.
– anonimo