Question: 1 Database Querying Consider the database consisting of 3 relations: Parent Child(Parent SSN, Child SSN) Person (SSN, Name, Age, Gender) School(Child SSN, School Name) The
1 Database Querying Consider the database consisting of 3 relations: Parent Child(Parent SSN, Child SSN) Person (SSN, Name, Age, Gender) School(Child SSN, School Name) The table Person contains all the people in the database, the table Parent Child links each child with his/her parents and vice versa, the table School list the children that are still in school along with the school name. Express the following queries (I) in Algebra (1 to 4), (II) in SQL (all). 1. List the children of John 2. List the grand parents of Peter 3. List the parents that have at least one child in the Riverdale Nl 10] | 4. List the parents that have all their children in the Riverdale i) s. List the parents that have no children in the Riverdale school. 6. List couples (female, male) that have at least one child in the Riverdale school. 7. List couples (female, male) that have all their children in the Riverdale school [5 extra points for this]
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
