Create a new Employee table with a minimum of 5 employees. Include the following columns: empID, empName,
Fantastic news! We've Found the answer you've been seeking!
Question:
- Create a new Employee table with a minimum of 5 employees. Include the following columns: empID, empName, empGender, empPhone, empDOB, and empWorkLocation. Take a screenshot.
- Explain and apply horizontal partitioning to this table. Take a screenshot validating that the partitioning has been completed.
- to Write a SQL query to reconstruct the complete table after partitioning. Take a screenshot of the query and its results.
- Explain and apply vertical partitioning to this table. Take a screenshot validating that the partitioning has been completed.
- to Write a SQL query to reconstruct the complete table after partitioning. Take a screenshot of the query and its results.
- Explain how and why data replication should be addressed in this environment. What replication strategies are available and how do they work? How do data replication/partitioning impact reliability, expandability, communications overhead cost, manageability, and data consistency?
- Explain how and why data partitioning and replication impact the creation of IT and technology infrastructures, creation of plans and schedules, measuring performance, and ensuring quality.
Submit the following in a single Microsoft Word document through the digital classroom. Include a one-line description above each screenshot.
- Screenshot of Employee table
- A paragraph explaining horizontal partitioning
- Screenshot of SQL query and result to apply horizontal partitioning
- Screenshot of SQL query and result to reconstruct the complete table
- A paragraph explaining vertical partitioning
- Screenshot of SQL query and result to apply vertical partitioning
- Screenshot of SQL query and result to reconstruct the complete table
- Paragraph explaining data replication, strategies, and impacts
- A paragraph explaining how and why data partitioning and replication impact the creation of IT and technology infrastructures, the creation of plans and schedules, measuring performance, and ensuring quality.
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: