In Microsoft SQL server(MSSQL)

Add four new filegroups to the _Chapter7database.

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