Answer below

 

  • Use the star schema developed in Portfolio Milestone 1 – Option 1 in Module 3; incorporate your instructor’s feedback.
  • Use the tables created in Portfolio Milestone 2 – Option 1 in Module 5; incorporate your instructor’s feedback.

Develop and execute the SQL commands to populate the fact and dimension tables by extracting data from the Northwind OLTP database and loading the data into the tables within the Northwind Data Warehouse. Your ETL workflow should consist of selecting the required variables from the source database and tables and inserting the required variables into the destination database and tables. After you have populated the tables, construct an SQL command to count the number of rows in each table. Capture a screenshot of the row count for each table. Finally, construct an SQL command to list the first ten rows of each table. Capture a screenshot of each listing.

Your deliverable for this Portfolio Project is a report containing the following information:

  • Changes to your business process, business questions, and fact table grain from Module 5
  • Updated version of the star schema incorporating your instructor’s feedback from Module 5
  • Screenshots of the row counts and table listings
  • Listing of SQL commands used in this assignment
  • A brief description of lessons learned in completing the Portfolio Project and the two Milestones. Based on your lessons learned, what advice would be offer to an organization embarking on building a data warehouse system?

Assignment

 Discussion #1: There have been many books and opinion pieces written about the impact of AI on jobs and ideas for societal responses to address the issues. Two ideas were mentioned in the chapter – UBI and SIS. What are the pros and cons of these ideas? How would these be implemented? 

 Discussion #2: Based upon the current state of the art of robotics applications, which industries are most likely to embrace robotics? Why? 

Discussion #3:  Conduct research to identify the most recent developments in self-driving cars. 

Course Reflective Paper

 

Assignment 1 – Reflective Paper

Provide a reflection of at least 500 words (2 pages double spaced excluding Title and Reference pages) that summarizes what you feel are the most important or interesting concepts you have learned so far in this Cloud Computing course.  Would be good to include an insight as to whether the learning was new to you or reinforced knowledge that you already had.

Requirements:  Provide a 500-word (2 or more pages double spaced not counting the title and reference pages) paper.  The paper should include a title page, body pages, and reference page.  An abstract and introduction is not required for this assignment.  Correct use of APA guidelines for sources and citations is required. If supporting evidence from outside resources is used those must be properly cited.

Please refer to the attached text books for the cloud computing course.

Corporate IT Security Audit Compliance

 Discuss this statement: Effective communication of the results is vital to prevent any misunderstanding”. How should the report be presented to prevent misunderstandings or misinterpretations?  

threat modeling

 

Threat Modeling

A new medium-sized health care facility just opened and you are hired as the CIO. The CEO is somewhat technical and has tasked you with creating a threat model. The CEO needs to decide from 3 selected models but needs your recommendation. Review this week’s readings, conduct your own research, then choose a model to recommend with proper justifications. Items to include (at a minimum) are:

  • User authentication and credentials with third-party applications
  • 3 common security risks with ratings: low, medium or high
  • Justification of your threat model (why it was chosen over the other two: compare and contrast)

You will research several threat models as it applies to the health care industry, summarize three models and choose one as a recommendation to the CEO in a summary with a model using UML Diagrams (Do not copy and paste images from the Internet). In your research paper, be sure to discuss the security risks and assign a label of low, medium or high risks and the CEO will make the determination to accept the risks or mitigate them.

Your paper should meet the following requirements:

  • Be approximately four to six pages in length, not including the required cover page and reference page. (Remember, APA is double spaced)
  • Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
  • Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.
  • Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writin

Python DFS BFS

  1. Your program should be written in Python
  2. Write all your own code. Do not use “off the shelf” code from any source.
  3. Your program (by default) will read the input from a textfile specified by the user.
  4. Your program should compile and run on Linux
  5. Assignment shown in attached screenshot below as well as what the .txt file would contain

Network

 

Based on the knowledge you have achieved thus far in this class, compose a brief synopsis compiling what you have learned about today’s networks. Describe how you would create a better network at your home or office utilizing the knowledge you’ve gained with this class. An example of this knowledge would be the cabling selected, as well as the IP address scheme utilized.

Parameters/Expectations:

  • At least 4 paragraphs in length not counting the title page, include a title page, double space, font size 10 or 12
  • Includes a highly developed viewpoint, purpose and exceptional content
  • Demonstrates superior organization, is well ordered, logical and unified
  • Free of grammar and spelling errors 5. No evidence of plagiarism

Milestone assignment

 

In the initial milestone writing assignment, you will evaluate the history of cryptography from its origins.  Analyze how cryptography was used and describe how it grew within history.  Look at reasons  why cryptography was used and how it developed over the years.  Was it used or implemented differently in varying cultures?  

The writing assignment requires a minimum of two written pages to evaluate the history.  You must use a minimum of three scholarly articles to complete the assignment.  Be sure to view your SafeAssign score. You may submit your paper twice. The assignment must be properly APA formatted with a separate title and reference page.