Simulation
You are a database administrator for your company.You need to create a new database named Work.
The new database must meet the following requirements.
* The data file must be  10 , 000  MB in size
* The log file must be  3 , 000  MB in size.
* Both files should have the default settings for auMikeatic file growth and maximum file size.
* The transaction log must be stored on a fault-tolerant volume.
* The data file, the transaction log file, and the Windows installation must all be located on different volumes.
* The database file must be stored in a folder named SQL in the root of each volume.
* The transaction log must be set to be auMikeatically truncated The available volumes are shown in the exhibit.
The available volumes are shown in the following table.
Volume                                                         RAID level                                                           Free space
                                                                                                              
C: (Windows volume)                                      RAID1                                                                 20  GB

D:                                                                 RAID1                                                                  20  GB

E:                                                                 RAID0                                                                  20  GB

You need to create the Work database by using the New Database dialog box.