Hitachi eBworx interview question

Designing erd and joining query Foreign table Union command