You want to retrieve employee name and department name where the employee works. The query is submitted at site 3 and the result is sent to this site. Assume that the database statistics indicate the following information.

Employee at site 1. 1000 rows. Row size = 10 bytes. Table size = 10000 bytes. Employee (fname, lname, ssn, bdate, address, gender, salary, superssn, dno)

Department at Site 2. 100 rows. Row size = 5 bytes. Table size = 500 bytes. Department (dno, dname, mgrssn, mgrstartdate)

Oct - Jan 2023 Final Examination BIT3342/BIT3343 Database Design and Management

LIMKOKWING UNIVERSITY OF CREATIVE TECHNOLOGY FACULTY OF INFORMATION & COMMUNICATION TECHNOLOGY Page 5 of 6 The result of this query will have 1000 tuples, assuming that every employee is related to a department. Suppose each result tuple is 20 bytes long.

Based on the above information, compute the cost of data transfer (in bytes) for the following strategies:

i. Transfer Employee and Department to Site 3. (5 marks) ii. Transfer Employee to Site 2, execute join at Site 2 and send the result to Site 3. (4 marks) iii. Transfer Department relations to Site 1, execute the join at Site 1, and send the result to Site 3. (4 marks) iv. Based on the amount of data transfer in (i iii), identify the preferred strategy and explain your answer.