In Microsoft SQL server(MSSQL)

-CREATEDATABASE _Chapter7.

-Use the database _Chapter7

-Add four new filegroups to the _Chapter7database. Use the naming convention fg_QN_Partition where N is the partition number (1-4)

-Add 1 file for each filegroup named file_Q1_Partition.ndf. There will be 4files created in total.

-Create a partition function named fnPartition_to divide the data into partitions using the values 3, 6, and 9 for the range values

-Create a partition scheme named psPartition_based on the partition function and all of the filegroups created above

-Use the naming convention fg_QN_Partitionwhere Nis the partition number (1-4).4.

-Add 1 file for each filegroup named file_Q1_Partition.ndf. There will be 4files created in total.

-Create a partition function named fnPartition_to divide the data into partitions using the values 3, 6, and 9 for the range values

Create a partition scheme named psPartition_based on the partition function and all of the filegroups created above