Computer Science Homework Help

Task 1:

For this activity, you will create a Final Sponsor Presentation. You have been hired by Alcatel‐Lucent and Bell Labs to use big data to improve customer experience and business performance. The case study you will use can be found at: https://onlinelibrary.wiley.com/doi/full/10.1002/b…

Your assignment is to take this case study and create a PowerPoint Presentation of the Final Sponsor Presentation, as described in Chapter 12 of your text. (Make sure to use the format presented in Chapter 12.)

You will submit a PowerPoint Presentation file (ppt or pptx) with at least the following slides: (You can submit more, but I’m mainly looking for these 9-10 slides)

Title (Your name + other info)

Situation and Project Goals

Executive Summary

Approach

Method Description

Recommendations

Note: Make sure you watch the video on how to create effective presentations and use outline format.

In the case study some specific analytics methods that could be used are described – you may want to use others. You will extrapolate from the provided information in the case study and provide your own interpretation of the method (or methods) the Data Science team used. Draw from what we have covered and map what you learned to what that team probably did. Tell the story. Inspire your sponsors.

Task 2:

Using the attached Database Diagram, answer the following questions!

1) Identify the Primary Key in each table in the diagram. List the Primary key in each table and describe why you think this field was selected to be the primary key.

2) The Orderline and BookAuthor tables have multiple primary keys, why is this the case? What do we call this type of table?

3) What would the Select statement look like if I needed all the orders for customerID 99999?

4) What would the Select statement look like if I needed all the customers that live in zip code 34583?

In a Word document, APA formatted, complete the above. Submit your assignment.