advance data base

sql relational db

QI. An international company has several branches and projects all over the world. Consider the following global relational database schema for the company: EMPLOYEE FNAMELNAME EMP_ID BDATE ADDRESS SALARY MGR_ID DNO I DEPARTMENT DNAME DNOMGRID MGR_STARTDATE DEPT_LOCATIONS DNO DLOCATION PROJECT PNAME PNO PLOCATION DNUM WORKS ON EMP_ID PNO HOURS PAY RATE To reduce the communication cost of remote applications with high access frequency, it is required to perform a horizontal fragmentation given the following application information: d) Define fragments using relational algebra