c$)$ You are tasked with creating a table, storing the details of all students. You decide with the following relation schema.

Students $($

StudentID

Forename

Surname

Email

AnticipatedGraduation

Tutor

INT $($PK$),$

VARCHAR,

VARCHAR,

VARCHAR

DATETIME,

INT $($FK$,$ Referencing Staff.StaffID$)$

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 key? $[2$ marks$]$

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