microsoft sql

Use server below for Final Project
Server: ORDB\cst4714
Database: S+ EmpID
Authentication: Windows Authentication

*kindly append _ProfG_FP to every objects created for this final project

The second engagement will continue to focus on the following business processes (Human Resource, Customer Relations, Marketing, Sales) plus Purchasing.

1. Describe ten scripts/reports, how the newly implemented system would require to answer 10 typical questions.

2. Data security: (at least three fields) client's sensitive data/information such as email/phone number/ credit cards etc are expected to be secure and mask when displaying

3. Business indicates that system becomes very slow when some canned reports are running. There are numerous ways to resolved this issue, find one and implement.

4. Data retention policy: data is kept indefinitely. There are numerous ways to resolved this issue, find one and implement.

5. Write and test seven (7) triggers for seven (7) separate tables to implement the business rules.
At least two (2) of the trigger must be for delete
At least two (2) of the trigger must be for insert
At least two (2) of the trigger must be for update
At least one (1) of the trigger must be for delete/insert/update

must 7 tables with data.