Assume that your enterprise has two branches one in Phoenix and one in Denver. 

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