Operating Systems Vulnerabilities Congratulations. You are the newly appointed lead cybersecurity engineer with your company in the oil and natural gas sector. This is a senior-level position. You were hired two months ago based on your successful cybersecurity experience with a previous employer. Your technical knowledge of cybersecurity is solid. However, you have a lot to learn about this company's culture, processes, and IT funding decisions, which are made by higher management. You have recently come across numerous anomalies and incidents leading to security breaches. The incidents took place separately, and it has not been determined if they were caused by a single source or multiple related sources. First, a month ago, a set of three corporate database servers crashed suddenly. Then, a week ago, anomalies were found in the configuration of certain server and router systems of your company. You immediately recognized that something with your IT resources was not right. You suspect that someone, or some group, has been regularly accessing your user account and conducting unauthorized configuration changes. You meet with your leadership to discuss the vulnerabilities. They would like you to provide a security assessment report, or SAR, on the state of the operating systems within the organization.  You're also tasked with creating a non­technical narrated presentation summarizing your thoughts. The organization uses multiple operating systems that are Microsoft-­based and Linux­-based. You will have to understand these technologies for vulnerability scanning using the tools that work best for the systems in the corporate network. You know that identity management will increase the security of the overall information systems infrastructure for the company. You also know that with a good identity management system, the security and productivity benefits will outweigh costs incurred. This is the argument you must make to the stakeholders.

Consider following relations” Question 1: If the relations are fragmented into R1 and R2 then comment on the completeness and disjointness of the relations R1 = σ RESP = “Manager” OR RESP = “Engineer”(ASG)R1 = σ TITLE < “Programmer”(EMP)R1 = σ Salary < 30000 (PAY) R2= σ RESP < “Engineer” (R) R2= σ TITLE <= “Syst_Anal.”(EMP) R2= σ Salary ≥ 30000 (PAY) Question 2: Assume P1: SAL < 27000 and P2: Sal >= 27000 are two simple predicates. Fragment PAY relation based on P1 and P2. Using these fragments perform fragmentation of EMP and show completeness, disjointness and reconstruction on fragmentation of emP. Question 3: Consider the following query based on above relations: Select ENAME, PNAME From EMP E, ASG A, PROJ P Where E.ENO = A.ENO And A.PNO = P.PNO And (TITLE = “Elec. Eng” OR A.PNO < “P3”) Write relational Algebra expression fot the query Draw the canonical tree Obtain optimized tree Question 4: Simplify the following query: Select ENO from ASG Where RESP = ‘Analyst’ and NOT (PNO =”P2” or DUR = 12) and NOT PNO =”P2” or DUR = 12 Question 5: In above relations if PFOJ is horizontally fragmented using the queries: PROJ1: Select * from PROJ where PNO <= ’P3’ PROJ2: Select * from PROJ where PNO > ’P3’ Transform the following query into a reduced query on fragments: Select BUGET from PROJ, ASG Where PROJ.PNO = ASG.PNO And PNO = “P4”