140 TWO OUTLINE Z SPECIFICATIONS Exercises 11.6 1. Specify an operation to return the set of all people who have any one of the following relationships to a given person x? The name of the required relationship should be an input to the operation. () The parents of person x? (ii) The grandparents of person x? (111) The grandchildren of person x? (iv) The descendants of person x? (1) The siblings of person x? (vi) The aunts of person x? 2. Give a Z expression for the set of all people in the database whq have no relatives in the databasc. 3. Give a Z expression for the set of all people in the database who have no siblings in the database. 4. Specify an operation to output the number of generations through which a given individual p can trace his/her family history in the database. ID 1 and wil verlationships involving the old name must be modified to the el primer people have had come with each other. The transitive down this cate hindi des! (T) UL: PERSON UR PERSONING) is the nation such that The operation schema is follow CN AGD old PERSON plashed child with someone who had children with someone who has had children with you get the Tetinal thletion of the setting for penge of ople who have the changed by this operati edom w dom - por) UN PERSONA). EX: PERSONNE- Westo pocity a few people to the uppone se from that given then by the function and finally this function is und the gal function. The reported is as follows Changing the sex of a person in the database The person must be in the database Althewear to require a umple veiding of the functie. However, the tricky part in specifying the per tion is that the person may be morded as a part in the database that they may be a member of nan porn This means that the recorded for other people may have to change in order to maintain they of the data bath is that the data will not contain children with the mother to the An implementation of the operation uld probably the war whether he wished to pred in the cast say that she would wish to make change the grity of the database 11 is much more than the open change wotect the place. However, we will poy a rather credention which ply makes the changes any people who person halad children that we had child with the people, and with two database coad Now the relatie PERSON GENDER per prent" A- Note that the phone to the when the pool the change for him. Theo che follow Change AGB PERSON ed ME PERSON GENDER A. We require the data islom south Thetfou the opport perch Lupers15ine *