Esri North Africa interview question

Database ERD digram and problem solving question