Consider the following global and fragmentation schemata. Global Schema: DOCTOR (DNUM, NAME, DEPT) PATIENT (RNUM, NAME, DEPT, TREAT, DNUM) CARE (PNUM, DRUG, QUAN) Fragmentation schema: 1. Determine the set of simple predicates Pr to obtain the relation PATIENT from its fragments. If 10 APP1,APP2,APP3 and APP4 applications are issued, do you think the set Pr will maintain completeness and minimality property? If not, do necessary changes to make the set complete and minimal. Justify your answer. 2. Suppose the patient having PNUM =103 in PATIENT relation, wants to change the doctor number. 5 So, the hospital changed his DNUM from 24 to 22 . Write an application at level -2 of distribution transparency to perform the necessary changes. 3. Assume that a patient is always assigned to the same department as his or her doctor. Attribute DNUM and PNUM indicates Doctor Number and Patient Number respectively. Draw the join graphs of the following joins and classify them: i. DOCTOR JNDNUM= DNUM PATIENT ii. DOCTOR JNNAME= NAME PATIENT iii. DOCTOR JNDEPT=DEPT PATIENT iv. PATIENT NJN CARE