Casepoint interview question

Oops, DBMS & logical Question