Question $2$

Suppose we have a database for Grade $11$ and $12$ students of the Esplanade Secondary

School. The layout of the records in this database is as follows:

student$($Surname$,$ First$\_$Name, Gender,Grade, $[$List$\_$of$\_$subjects$]).$

The first entry in the list of subjects represents the subject the student takes as first language

and the second entry the subject the student takes as second language. The other entries

represent the other subjects the student takes.

$($a$)$ Write Prolog clauses for the following: Given a Surname and First$\_$Name, return

the list of subjects this student takes, e$.$g$.$

student$\_$subs $($Surname$,$ First$\_$Name, L$)$ should return the list $L$ of the subjects

student First$\_$Name Surname takes. Do this for the gender and the grade of the

student as well.

$($b$)$ Build your own database using some entries reflecting the records of students. Use the

Prolog clauses you defined in $($a$)$ to run queries to ask the following questions:

Who takes Portuguese as second language?

Who takes more than $6$ subjects?

Is there a student with the surname Brown in Grade $12?$