Barclays Interview Question

mysql query, Er diagram etc