Structured Query Language

Please see the discussion below and respond with a minimum of 150 and provide references used.

 Explain SQL and its functions. What do you enjoy the most about learning SQL? What you find the most difficult? 

Computer Science

n identification of the main drivers of change in organisations, and using at least two

established models, an explanation of how people might experience change 

Week 7 BI

 

Complete the following assignment in one MS word document:

Chapter 7 –discussion question #1-4 & exercise 3 & Internet exercise # 7
When submitting work, be sure to include an APA cover page and include at least two APA formatted references (and APA in-text citations) to support the work this week.
All work must be original (not copied from any source).

 

  1. Describe text analytics and understand the need for text mining
  2. Describe sentiment analysis

Benchmark – Impact Analysis Part 2

  

Benchmark – 3.3: Perform requirements analysis to identify and obtain data and evidence in support of cyber law inquiries and incidents.

Next, gauge and evaluate your organizations current state of security and protection protocols and mechanisms. Identify gaps, challenges and opportunities for improvement by conducting a thorough audit making sure to:

1. Identify the industry specific cyber law in relation to inquiries and incidents.

2. Assess the critical information infrastructure. Determine the configuration of doors, windows, logical controls, data storage and encryption, firewalls, servers, routers, switches, hubs, and so forth to be compliant.

3. Identify key vulnerabilities points and strengths. Show compliance using a test case (pass/fail requirement). Demonstrate an actual compliance test of server, workstation, etc. that indicates what passes or what doesn’t.

4. Indicate the legal elements and liability (costs) that the organization may encounter for non-compliance.

Place your findings in a report that will be reviewed by the CIO and System Security Authority (SSA). 

CMIS 102 6383 Introduction to Problem Solving and Algorithm Design

 The final project involves writing a Python program to determine the body-mass index of a collection of six individuals. Your program should include a list of six names. Using a for loop, it should successively prompt the user for the height in inches and weight in pounds of each individual. Each prompt should include the name of the individual whose height and weight is to be input. It should call a function that accepts the height and weight as parameters and returns the body mass index for that individual using the formula weight × 703 / height2. That body mass index should then be appended to an array. Using a second loop it should traverse the array of body mass indices and call another function that accepts the body mass index as a parameter and returns whether the individual is underweight, normal weight or overweight. The number of individuals in each category should be counted and the number in each of those categories should be displayed. You should decide on the names of the six individuals and the thresholds used for categorization.

Your program should include the pseudocode used for your design in the comments. Document the thresholds you chose for under weight and over weight in your comments as well. 

Organizational Resources and Capabilities

 A company’s resources and capabilities are integral to achieving sustainable competitive advantage. Refer to your Thompson (2022) readings and the required videos. For this assignment, consider a company you worked for or one that you know well. Develop your analysis by responding to the following questions:

  • What are the company’s most important resources and why?
  • What are the company’s most important capabilities and why?
  • How do the company’s most important resources and capabilities create lasting competitive advantage?
  • Relate your response to each of the above to our coursework (Thompson text) from this week.

Submission Details: 

  • Your analysis must be driven by facts, research, and data.
  • Your analysis should be between 1000 and 1500 words.
  • Incorporate a minimum of at least our course text and one non-course scholarly/peer reviewed source in your paper. All written assignments must include a coverage page, introductory and concluding paragraphs, reference page, double-spaced and proper in-text citations using APA guidelines.

References:

https://hbr.org/2004/06/capitalizing-on-capabilities

discussion

Write an essay of atleast 500 words on what you would like to learn for future study in this course.

Write in essay format, not outline or bulleted.

Use the five paragraph format. Each paragraph must have at least five sentences. You need to refer to 3 sources and include them in the references.