OpenText Interview Question

Simple Sql query, db design