An employee performs a request (grant, revoke) in order to obtain a specific permission request into a system within the company. An employee is part of a department and the company has several departments. The request goes for approval to the line manager and corporate security manager. The request is made in a date, has a starting date, ending date, the system where access is needed and the type of the request. Also the request has a priority (p1, p2, p3). After the request is approved from the line manager and the corporate security manager it is implemented from the administrator.
Exercise – define the database (respective tables) necessary to memorize the information needed for the above process. Create the ER diagram.
Write the Respective T-SQL code for Microsoft SQL Server 2012 for the processes.