12. John is working with Client Network Ltd as the Database Administrator. He wants to create a database to store the details of all the employees working in the organization. He needs to ensure that while saving, the data is placed in multiple file groups so that he is able to effectively manage the backup and restore operations. What should John do to perform this task?

Create table Empdetail
on Primary
(name ='EmpDetail_Primary',
fileName='D:\Data\EmpDetail_Prm.mdf',
Size=5MB,
Maxsize= 10MB,
fileGrowth =1MB),
Filegroup Empdetail_Fg

(Name ='EmpDetail_Dat1',
file= 'D:\Data\EmpDetail_1.ndf',
size =5MB, Maxsize=10MB,
FileGrowth=1MB),
(Name = 'EmpDetail_Dat2',
fileName = 'D:\Data\EmpDetail_2.ndf',
Size =5MB,
Maxsize=10MB,
FileGrowth =1MB)
Log on
(Name ='EmpDetail_Log',
FileName='D:\Data\EmpDetaiL_ldf',
Size=5MB, Maxsize=10MB,
FileGrowth=1MB)
Go