icon

Usetutoringspotscode to get 8% OFF on your first order!

IT, WEB

Paper details: 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

You can leave a response, or trackback from your own site.

Leave a Reply

Powered by WordPress | Designed by: Premium WordPress Themes | Thanks to Themes Gallery, Bromoney and Wordpress Themes