Question 2$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:

Table 1$1$: Project

i.$.$ Projects with budgets less than $200000

ii.$.$ Projects with budget greater than or equal to $200000$\mathrm{<br>}$

iii. Information about project budget only

iv.$.$ Information about project names and locations

v.$.$ Information about project name and budget for each location

Answer rating: 100% (QA)

Answer to Database Fragmentation Question a Horizontal Fragmentation of PropertyforRent Since there ... View the full answer