Problem
A. Create new Employee table with a total of 5 employees. Include columns such as empID, empName, empGender, empPhone, empDOB, location.
B. Explain how you would apply horizontal partitioning to this table and write a SQL query to reconstruct the complete table after partitioning.
C. Explain how you would apply vertical partitioning to this table and write a SQL query to reconstruct the complete table after partitioning.
D. Explain how and why data replication should be addressed in this environment. What replication strategies are available and how do they work?
E. List and explain a minimum of three distributed database transparency features that should be applied to this environment.