Amdocs interview question

Database Constraints,joinings