Family Relations - I Consider the family Entity-Relationship (E-R) diagram[s] discussed in the class. A. Given the relation PERSONS that has tuples holding the attributes of persons (p), and the relation FAMILY that has tuples of the form (pld, fld, mid), where pld is the Id person in PERSONS, fId is the Id of the father of p, and mId is the Id of the mother of p, with f and m are also persons in PERSONS. 1. Provide the E-R diagram and corresponding relational database schema used for this assignment. Indicate for each relation: the key or keys, primary key, foreign keys, essential constraints, and any appropriate checks. 2. Provide appropriate data manipulation expressions to create the relations in a RDBS of your choice. 3. Give appropriate relational algebra trees-expressions that return: a. b. c. Children of a given couple; Grandparents of a given person; and Nephews -- sons of one's brother or sister -- of a given person. 4. Provide appropriate SQL expressions for the queries in A3. B. Implement A above using your RDBS of choice. Test your implementation of the queries using an appropriate set of data. The data utilized must be representative and sufficient to demonstrate the validity of your queries. Family Relations - I Consider the family Entity-Relationship (E-R) diagram[s] discussed in the class. A. Given the relation PERSONS that has tuples holding the attributes of persons (p), and the relation FAMILY that has tuples of the form (pld, fld, mid), where pld is the Id person in PERSONS, fId is the Id of the father of p, and mId is the Id of the mother of p, with f and m are also persons in PERSONS. 1. Provide the E-R diagram and corresponding relational database schema used for this assignment. Indicate for each relation: the key or keys, primary key, foreign keys, essential constraints, and any appropriate checks. 2. Provide appropriate data manipulation expressions to create the relations in a RDBS of your choice. 3. Give appropriate relational algebra trees-expressions that return: a. b. c. Children of a given couple; Grandparents of a given person; and Nephews -- sons of one's brother or sister -- of a given person. 4. Provide appropriate SQL expressions for the queries in A3. B. Implement A above using your RDBS of choice. Test your implementation of the queries using an appropriate set of data. The data utilized must be representative and sufficient to demonstrate the validity of your queries