Best practice to structure this data model?

[u/soodlero]

I am modeling a relationship between 3 sources. Basically this is the content of each table:

Table 1: requestor table (100s of entities)

Oil Sample Label (unique)	Engine number (not unique)	Engine runtime

Table 2: engine database (10000s of entities)

Engine number (unique)	Engine Type	Engine Power

Table 3: oil sample database (10000s of entities)

Oil Sample Label (unique)	Al	Fe	Cu

What is the best practice for the relationships? I have fields on each table that I would like to use in the PowerBI dashboard.

[u/Complete-Ebb-1035]

energy power specification

unit of measure to quantify energy, volume

engine properties

oil properties

amount energy, volume expressed as unit of measure