Question 11 (10 points) Assume there is an organisation called MyComp. There is one major department in this organisation that accesses SH (Sales History) database tables. Details of this database can be found at SH Sample Schema Table Descriptions (oracle.com) (OPEN THE LINK ON NEW WINDOW]. The departments and associated duties for the database are described in the following table: Marketing This department is responsible for creating promotions including setting promotion cost for each product. Based on this department's duties within the organisation as outlined in above, develop a plan to create a role for employees in this department and assign privileges. The plan should include the following: details of each role (i.e. name of the role), what privileges are to be given on which tables. Please also give appropriate reasons. A/ Question 11 (10 points) Assume there is an organisation called MyComp. There is one major department in this organisation that accesses SH (Sales History) database tables. Details of this database can be found at SH Sample Schema Table Descriptions (oracle.com) (OPEN THE LINK ON NEW WINDOW]. The departments and associated duties for the database are described in the following table: Marketing This department is responsible for creating promotions including setting promotion cost for each product. Based on this department's duties within the organisation as outlined in above, develop a plan to create a role for employees in this department and assign privileges. The plan should include the following: details of each role (i.e. name of the role), what privileges are to be given on which tables. Please also give appropriate reasons. A/