Database system

Answer the following questions based on table1 .

Table 1 Lecturer Table

Lecturer ID	Lecturer Name	Department ID	Department Name	No of Subject Taught	No of Mentees
060666	Rohayu Hasyim	COMP	Computing	4	15
070202	Azira Azlan	COMM	Communication	3	12
070225	Salwati Salleh	COMP	Computing	4	20
080900	Azie Azizi	VA	Visual Art	3	17
071002	Faudzi Fauzan	COMP	Computing	5	25

Data fragmentation allows us to break a single object into two or more segments or fragments. Supposed that the top management of university requires information about lecturers in all three departments (Computing, Communication, Visual Art).

Based on the requirements, you were asked to distribute the data according to the given condition. Draw the result of the following fragmentation:

1. Horizontal Fragmentation distribute by department ID.

2. Vertical fragmentation distribute by location.