Edifecs interview question

basic sql queries about primary key, foreign key, etc..