c$)$ You are tasked with creating a table, storing the details of all students. You decide with the following relation schema.i$.$ What is the primary key? $[2$ marks$]$ii$.$ Name an alternate key for this table. $[2$ marks$]$iii$.$ What column acts as a foreign key. $[2$ marks$]$iv$.$ Why couldn't a combination of forename and surname be used as a primary ke

Email

Tutor

d$)$ Suppose the Staff table has the fields StaffID $($INT$,$ PK$)$ as well as Forename, SU and Email $($all VARCHARs$).$ Draw the ER diagram for the two entities below. You may that Name is a composite attribute consisting of forename and surname. $[5$ marks$]$