nsider the schema below for a university database:

Ident $($Stud#$,$ StudName, Age, Sex, GPA$)$

urse $($Course#$,$ CourseName, Credits$)$

culty $($Faculty#$,$ FacultyName, Salary$)$

aches $($Course#$,$ Faulty#$,$ Time$)$

oms $($Room#$,$ Location, Capacity$)$

eets $($Course#$,$ Room#$,$ Location, Time$)$

rolled $($Stud#$,$ Course#$,$ Grade$)$

e primary keys for the relations in this schema are underlined.

What is required for an attribute to be a foreign key?

Specify all the Foreign keys for the above relations, stating any assumptions you make.

int: The answer for specifying each of the foreign keys should be written as follow: The "attribute$-$name" $($or set of

mes"$)$ of relation R$1$ is$/$are the foreign key for the relation R$2.$