Question $2$ : Database Fragmentation

a$)$ Consider the following relation:

Property$\_$for$\_$Rent$($property$\_$id$,$ type, address, rent, owner$\_$id$)$

If we assume that there are only two possible property types, Flat and House,

determine the horizontal fragmentation of the relation.

b$)$ Design the database fragments. The data as given below: