$1.$ Horizontal FragmentationDefinition: Horizontal fragmentation divides a database table row$-$wise. Each fragment contains a subset of the total rows of the table, based on specific criteria.When to Use: Horizontal fragmentation is particularly useful when different users or applications need access to different rows but similar columns of data. It's best used when queries are limited to specific subsets of rows.Example:Consider a multinational company with employees in the USA, UK$,$ and India. An employee database can be horizontally fragmented based on the country of employment. The USA node will store only the records of employees working in the USA, and similarly for the UK and India. This ensures that queries related to employees of a particular country are faster and more localized$\mathrm{.}2.$ Vertical FragmentationDefinition: Vertical fragmentation divides a table column$-$wise. Each fragment contains a subset of the total columns, typically along with a key column to maintain referential integrity.When to Use: Vertical fragmentation is useful when different users or applications frequently access specific columns of a table. It optimizes access patterns by distributing the columns according to the access requirements.Example:Again, consider the employee database. Suppose most queries in the HR department only access employee IDs, names, and contact information, while the payroll department accesses employee IDs, bank account details, and salary data. The database can be vertically fragmented to separate personal information $($for HR$)$ from financial information $($for payroll$),$ improving performance and security.

Im bit confused with the given expalantion above.. i need a clear understanding with example table and query to demonstrate the both cases in horizontal and vertical fragmentation