Homework

 (1. You need to write carefully considered, grammatically correct, thoughts, Use references where appropriate, Do not plagiarize!! The result of your work will be contained in one word document that contains timestamped screen shots when appropriate. It will be run through safeassign to detect plagirism. Plagiarism will be rewarded with a zero score.)

Normal Forms:

  1. Explain why normal forms were defined. What problems are solved by using them?
  2. Provide an example table that violates at least one normal form and explain how you would rebuild this table to make it comply with it. (Hint: you can use any online tool and take screen shots.)

Foreign Keys:

  1. Explain why foreign keys are used. What problems can be solved by using them? (25 points)
  2. Identify a foreign key from the “classic models” tutorial and:
    1. explain how it works, i.e., which tables does it connect, etc. (12 1/2 points)
    2. what would be the practical implication of removing this foreign key relationship that you chose. Things to consider include: data duplication, data inconsistency, orphaned data, etc. (12 1/2 points)

Discussion 1

After reading Chapters 1 and 2 of the Preece text, what does interaction design mean to you? You are required to write a statement that is  LIMITED to 150 words . This is an opinion question; therefore, research is not required. Should you cite the work of others, please provide the source of your opinion in APA format.

HW

 

Literature Review

(Outcome 3,4): 4 hours

· Critique quality of the literature reviews conducted for two different types of studies- a quantitative and qualitative research.

· Identify and discuss the research questions, sampling and sampling sizes, research designs (qualitative vs. quantitative), hypothesis, data collection methods, and research findings.

· Discuss the credibility of the sources and the research/researchers findings.

· 400-word minimum/550-word maximum without the references.

· Minimum of 3 references (the course textbook must be one of the references) in APA format, must have been published within last 3-5 years.

Practical Connection

  Provide a reflection of at least 500 words of how the knowledge, skills, or theories of this course(Info Tech & Mobile Application) have been, or could be applied, in a practical manner to your current work environment (Currently working as Software Quality Analyst). If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study.   

Proof of Concept Report

 

This week, you will complete your proof of concept and submit the report. This is the final report to management before the actual cloud deployment process begins.

Use the Proof-of-Concept Report Template to prepare a report that shows the steps and results for the proof of concept. In the template, you will see specific instructions. Delete the instruction text before you submit the project.

Your report should:

  • Be between five to seven pages (plus an appendix for screenshots, cover page, and table of contents)
  • Address the topics listed in the Proof-of-Concept Report Template
  • Include the following screenshots from the “Build a Virtual Private Cloud and Launch a Web Server” activity:
    • Start Lab page
    • AWS Management Console Name with your name visible from user drop-down
    • Task 1: Create Your VPC
    • Task 2: Create Additional Subnets
    • Task 3: Create a VPC Security Group
    • Task 4: Launch a Web Server Instance

SECURE CLOUD ARCHITECTURE

Business case:  Bule Sky Airport (second improvement of the project ) 

Migrating to the Cloud: You were tasked to improve the performance of the Bule Sky Airport IT system.  

There are three databases:

  • The passenger database will record and authenticate each passenger in the airport
  • The employee database will record and authenticate each employee in the airport
  • The flight database will record each flight in the airport

After having meetings with the airport owners and managers, the following IT-related system comments will be moved to the cloud.

Database and Database management systems are on premises for all three (Passenger, Employee, and Flights). Therefore, current data related to Passengers and data related to Flights data will be on preemies.  Cloud storage will be used for long-term data storage.  Week-old Passenger data will be stored on the cloud and Week-old Flight data will also be stored on the cloud as well.  The airport IT system will not keep old Passenger and Flight data on the premises.

Data related to Employees will be kept on the premises always.

The Airport company’s specific privacy requirements

  • Security certifications ISO 27001, NIST CSF, and FedRAMP should be met by the cloud service provider(s). 
  • The Payment Card Industry Data Security Standard (PCI DSS) should be met by the cloud service provider(s). 

Answer the airport owners’ questions about cloud migration.

Question 1:  What would be the System Requirements that you look for in the cloud service provider.?

Question 2: How would you protect your data before cloud migration? You should consider the company’s specific privacy requirements

Question 3: What are the Budget factors of the current data center before cloud migration? What would be the impact of the cloud migration on the budget in long term?

Problem 2- Planning

Problem

1. Identify a major public infrastructure project that is either underway, complete, or proposed in your region. This could be a bridge, road, building, or something of that nature. For the project you have identified, think of as many stakeholders and stakeholder groups as you can. Create a three-column table. In column 1, list the stakeholders. In column 2, list what each stakeholder wants to get from the project. In column 3, list the influence each stakeholder has over the project.
2. How can the stakeholders change over the course of a project? Give examples of changes in who the stakeholders are, and also in how their interests or influence over the project might change throughout the term of the project.

Text

Title: Project Management Subtitle: https://opentextbc.ca/projectmanagement/ Authors: Adrienne Watt Publisher: BCcampus Open Education Publication Date: 2019 Edition: 2nd Edition 

Purpose: The purpose of this assignment

  

Purpose: The purpose of this assignment is to give you exercise to

Become familiar with tree, binary tree

Become familiar with linked binary tree structure and array-based binary

tree structure

Exercise 1:

For the following tree, answer following questions:

a. Which node is the root?

b. What are the internal nodes?

c. How many descendents does node cs016/ have?

d. How many ancestors does node cs016/ have?

e. What are the siblings of node homeworks/?

f. Which nodes are in the subtree rooted at node projects/?

g. What is the depth of node papers/?

h. What is the height of the tree?

Exercise 2:

1. Draw a (single) binary tree T such that:

a. Each internal node of T stores a single character

b. A preorder traversal of T yields EXAMFUN

c. An in order traversal of T yields MAFXUEN

2. Assume the above binary tree is arranged in a Linked binary tree structure, draw a figure to represent the binary tree [hint: take a look at figure 7.14]

3. Discuss the pros and cons of the array-list representation of a binary tree.