It is assumed that if we are going to use a relational database manager as for mysql examples we should have all the related tables? or can it be the case that we have floating tables that would depend on that?
It is assumed that if we are going to use a relational database manager as for mysql examples we should have all the related tables? or can it be the case that we have floating tables that would depend on that?
If I do not understand wrongly, by "related tables" you understand those tables that reference (or are referenced by) other tables, usually by "foreign keys". Of course, this is the usual in a relational database design. But it is perfectly valid (and not uncommon) to have "unrelated" tables (what you call floating tables).
On the other hand: it is a very common concept error (or terminology), to believe that the word " relationship " (when one talks about relational databases strong>) alludes to these "relationships between tables". It is not like this; in the relational model , the "relation" is what we commonly call "table". In English they differ (although they are also confuse )" relation "and" relationship ", unfortunately we use the term" relationship "for both.