BMC Software interview question

SQL Database design