Assume that your enterprise has two branches one in Phoenix and one in Denver. Construct a new
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: