Is it possible to get data without a direct relationship between tables?

Question

Database

Logical database model (ignore that there are no intermediate tables for many-to-many):

spoiler

As you can see in the figure, the "Price" table is not related to the "Orders" table. But in the table "Orders" there is a field attribute "Margin".

Question: Is it possible to get the prices of goods from the "Orders" table through the "Products" table to calculate the margin? Or do they need to be linked together?

The same principle applies to the "Supplies" and "Goods" tables. Is it possible to enter information about the purchase price without having a direct link between "Supplies" and "Price"?

Answer 1

Can. Joins do not require FKs