You are just hired as a database security analyst. CIO asks you to implement the following database policy. The table names created in the CardinalDB database must be prefixed with tb_%. This is NOT about stored procedures. You must create two conditions.

Use the following database and tables for the testing of Task 3 below after you created the policy.

CREATE DATABASE CardinalDB GO USE CardinalDB GO CREATE TABLE [dbo].[Department1](

[DepartmentID] [int] NOT NULL, [DepartmentName] [nvarchar](50) NOT NULL, [DepartmentDescrp] [nvarchar](50) NOT NULL,

)

CREATE TABLE [dbo].[Department2](

[DepartmentID] [int] NOT NULL, [DepartmentName] [nvarchar](50) NOT NULL, [DepartmentDescrp] [nvarchar](50) NOT NULL, ) CREATE TABLE [dbo].[tb_Department3]( [DepartmentID] [int] NOT NULL, [DepartmentName] [nvarchar](50) NOT NULL, [DepartmentDescrp] [nvarchar](50) NOT NULL,

)

CREATE TABLE [dbo].[tb_Department4](

[DepartmentID] [int] NOT NULL, [DepartmentName] [nvarchar](50) NOT NULL, [DepartmentDescrp] [nvarchar](50) NOT NULL,

)

2 Use the following steps in defining policies.

Step 1: Select a target facet that contains the properties to be configured.

Step 2: Create a condition that specifies the state of a management facet.

Step 3: Define a policy that contains the condition, additional conditions that filter the target sets, and the evaluation mode.

Step 4: Check whether an instance of SQL Server is in compliance with the policy.

Hints (very important):

- When creating a new policy: Create New Policy > Check condition > click on the drop-down menu and scroll down to view the full list of available conditions.

- When creating a new policy: Evaluation Mode > On demand and On schedule are available. Select On demand.

- After creating conditions and policies, create the four sample tables. And you must evaluate the policy on the created tables. Figure out how to evaluate the policy. You do not need to enable the policy.

Screenshots should show the full contents of the conditions and policy you have created, not just the names.

Task 1 (5 points). Show in a screenshot the condition(s) you have created.

Task 2 (5 points). Show in a screenshot the policy you have created.

Task 3 (5 points). Show in a screenshot the test results using the four tables that are provided above.