Case- IT Auditing

Windows servers are used for all server types (application, web and database delivery). Windows patch updates comply with the change management policy. Windows patches are downloaded to a central patch server. All patches are reviewed and tested prior to deployment to production servers. All approved patches are first deployed to the development servers, then to the test servers and finally to production servers. Although patches occur on Wednesday evening, if a system reboot is required these are not perform until the weekend downtime window. Approval is not required for patch updates for these are considered a normal standard process for ABC. Additionally, prior to deployment all patches are reviewed to ensure they will function with current systems.

Question: What are the Controls and what are the GAPS

Assume that the following relationships were created in a database.

CUSTOMER (CustomerNumber, CustomerLastName, CustomerFirstName, Phone)

COURSE (CourseNumber, CourseTitle, TeachingMode, CourseCreationDate, Fee)

ENROLLMENT (EnrollmentID, CustomerNumber, CourseNumber, EnrollmentDate, AmountPaid)

Legend:
Primary Key

Foreign Key

Possible values

TeachingMode: PRE - Presencial, ONL - Online


Write the SQL (ORACLE) statements required to complete what is required below. Provide ONE instruction per request / question. Write your answers in the space provided. Identify each answer with the corresponding request / question number.

1. Create the CUSTOMER table include the constraints 
2. Create the COURSE table include the constraints 
3. Create the ENROLLMENT table include the constraints 
4. Create the sequence seqEnroll 
5. Insert a row in the CUSTOMER table. 
6. Insert a row in the COURSE table. 
7. Insert a row in the ENROLLMENT table. The primary key field is a substitute (Surrogate / Artificial) so it will use the sequence you created in statement 4. The transaction must belong to the CUSTOMER you created in # 5 and the COURSE you created in # 6. 
8. List customers in ascending alphabetical order by last name. Include the following information in this order: last name, first name and telephone number 
9. List all the courses that have the word Pastels in the title. Include all the data in the COURSE table. 
10. List all the courses the clients are enrolled in. Include the following data in this order: CustomerNumber, CourseNumber, and AmountPaid. 
11. List all courses that started on or before October 1, 2018. Include the following data in this order: CourseDate, CourseNumber, CourseTitle, Fee. 
12. Show for each client the total paid for classroom courses and total paid for online courses TeachingMode the total paid by each client. 
Show courses that are cheaper than the average price Use subquery and functions. 
13. List all course information if you have had at least ten clients enrolled in the past twelve months. It must work at any time, the twelve-month period will depend on the date the consultation is run. DO NOT USE SPECIFIC DATES. Use subquery and functions.

An effect research question involving gender and GRE scores; corresponding null and alternative hypotheses; the type of statistical analysis to be employed to determine significance; explanations of fictitious outcomes identifying both a non-significant and a significant effect as related to both null and alternative hypotheses; and recommendations based on non-significant and significant findings.

devise a plan of how you will identify which compounds are non- polar covalent using only one test.

What test will you carry out to determine whether a sample is a mom- polar covalent compound?

What result will you get in this test id the sample is a non-polar covalent compound?

During this week you have to write about the differences and similarities between a for-profit, non-profit  healthcare organizations; which one best describes Mercy hospital ( our case study). Add any information about the Affordable Care Act that may affect the governing structure of a non-profit hospital.

A) Provide a short general report to managers and stakeholders demonstrating how the financial and non-financial performance of your company and business idea will be measured. Consider your core values (social, environmental and financial).

B) list one performance measure - Financial

and 3 performance measure non-financial that is linked to SDGs.

ASSIGNMENT:

Answer both questions below:

1. Using the internet or any other resource, perform a search for “systems development life cycle.” Write a summary that outlines the similarities and differences between the systems development life cycle (SDLC) and each of the project management life cycles. Can they work together?
2. There are many aspects that make IT projects unique. Describe four aspects and provide examples. Given examples from your concentration (Cybersecurity, IT Security, IT Project Management, Information Security Management, Business Analytics, Business Administration, Software Development, Database), as to why projects from these concentrations would be unique.

Use the Financial database from “Excel Databases.xls” on Blackboard. Use Total Revenues, Total Assets, Return on Equity, Earnings Per Share, Average Yield, and Dividends Per Share to predict the average P/E ratio for a company. Use Excel to perform a forward selection regression analysis. Assume a 5% level of significance. Based on your final model, what is the p-value from the test of the overall model? Write your answer as a number and round to 3 decimal places.

Excel Data: https://drive.google.com/file/d/1TQG5r2wzLGk--75whZXyb0SDTHZTWS0S/view?usp=sharing

Using the data shown, you will create two charts. The first chart is a bar chart that will display % growth in different job titles between 2010 and 2020Est. The second chart will be a pie chart showing the 2020Est. Jobs in different categories as a % of overall 2020Est. jobs.

Discuss whether or not each of the following activities is a data mining task. Provide your reasons as well in detail. Fill in your answers in the space provided below.

(a) Dividing the customers of a company according to their gender.

(b) Dividing the customers of a company according to their profitability.

(

c) Computing the total sales of a company.

(d) Sorting a student database based on student identification numbers.

(e) Predicting the outcomes of tossing a (fair) pair of dice.

(f) Predicting the future stock price of a company using historical records.

(g) Monitoring the heart rate of a patient for abnormalities.

(h) Monitoring seismic waves for earthquake activities.