Question $2$

$100$

Points

Consider an ER schema with an entity type Person and a relationship type Parent. Person has one attribute id$.$ Parent has three edges to Person, with roles father, mother, and child. Parent also has an attribute date. The edge from Parent to child is functional.

Converting this schema to a relational schema with keys and inclusion dependencies, indicate which keys and which inclusion dependencies would be generated. Below, 'inc.$\text{'}$ stands for the inclusion symbol.

key $\{$father$,$ mother, child$\}$

key $\{$date$\}$

key $\{$child$\}$

key $\{$father$,$ mother$\}$

Person$[$id$]$ inc. Parent$[$child$]$

Parent$[$child$]$ inc. Person$[$id$]$

Person$[$id$]$ inc. Parent$[$mother$]$

Parent$[$father$]$ inc. Person$[$id$]$