Hitachi eBworx Interview Question

Designing erd and joining query Foreign table Union command