FOLLOW PROJECT ONE DOCUMENT BELOW!!!! Use others as resources if needed! In this project, you will demonstrate your mastery of the following competencies:Apply cloud-based development principles and best practices in application developmentDevelop applications that run on cloud-based frameworksScenarioYou are a developer for QnA, a startup company. You just completed the development of a full stack web application and watched app usage take off after the implementation of in-house servers. It’s an exciting time for the company. The company is growing, and you can feel the growing pains. The company is expecting a drastic increase in customers. You notice that the once-fluid office environment that allowed customers to choose their favorite devices and platforms has led to major limitations in collaboration. Development has become siloed, and sometimes only one key person can manage certain aspects of the application. To continue to allow your application to expand with the growing company, you need a solution for moving the application to a cloud-based framework.In this project, you will explore cloud development frameworks for leveraging cloud infrastructure to support your application. This project will allow you to migrate your web application from the desktop to a cloud-based environment. All of these iterations will show you how the cloud is designed to make scaling up and growing your business more efficient. The IT team has determined that Amazon Web Services (AWS) provides a Platform as a Service capability that allows you to minimize system management and efficiently run services by dynamically scaling an application’s capacity to run up and down. You will be leveraging the principle of elasticity.DirectionsSpecifically, your web application must demonstrate your ability to do the following:Frontend: Establish an S3 server to host a static Angular website.Prepare the client-side and web server setup, and apply the principles of serverless web hosting by moving frontend-Angular to the cloud.Prepare S3 storage buckets and objects and IAM security settings.Now that you have created your containers, you can see there are benefits and pitfalls to this approach. Your director wants to ensure that your site is elastic, is secure, can process data quickly, and can keep up with the amount of traffic and transactions as the number of customers increases. Her thought is to utilize more AWS products and move the frontend to S3, a serverless solution.You will be running your application in a serverless environment using a cloud-based database solution and detaching the Angular frontend and running it in the cloud, removing the need for the original server.Backend and API: Migrate all of the server-side business logic.Demonstrate how Lambda containers can be used to distribute functionality in a serverless environment.Migrate all of the server-side business logic; apply principles of serverless API by writing code.Establish IAM security policy updates to protect the website and database.Change the API Gateway to connect the Lambdas.As you explore native cloud services you will discover best practices that simplify the work of a developer, leaving them focused on developing rather than continuously working on maintaining the existing infrastructure.In the final phase, you will deconstruct the full stack application APIs and turn them into microservices, making them fully cloud-native applications. This involves adding CRUD functionality and API Gateway using Lambdas to eliminate the need for the original MEAN server.What to SubmitTo complete this project, you must submit the following URLs to Brightspace:API URL / Endpoint: This is the backend of the project running.S3 URL / Endpoint: This is the project fully running.

Part 1Referring back to your Reading and any other resources you have found, write a 2-page descriptive paper that addresses the following:What is the cloud?What are at least three potential benefits of the cloud?How can virtual environments reduce the need for new hardware?Would virtualization technology be beneficial to start with versus cloud resources? Why or why not?How would you respond to your manager from the scenario above?Make sure your paper covers the following topics:Infrastructure-as-a-Service (IaaS)Platform-as-a-Service (PaaS)Software-as-a-Service (SaaS)Virtualization technologiesBe sure to also include the following within your submission:Screenshots demonstrating experience installing and configuring a virtual environment. Part 2Explore Data Manipulation Language (DML) statements to manage data within schema objects.In business, things change, and data in an organization’s database must be modified to reflect those changes. In this module assessment, you will insert new data into the Northwind database, and you will then update a table in the database.You are also asked to develop SQL DML statements to retrieve data addressing several business inquiries. You must use the Northwind database for this assessment.Assessment InstructionsYou will need to install and use Microsoft SQL Server Express and Microsoft SQL Server Management Studio (SSMS) for this Assessment. You can download the latest versions of these free software products here:Microsoft SQL Server ExpressMicrosoft SSMSThe module assessment consists of two tasks, and you will generate a Microsoft Word report from the completed work. You will use the Northwind database for both tasks. Deploy the Northwind database into your Microsoft SQL Server instance by executing the following script in a Microsoft SQL Server Management Studio (SSMS) query window:Northwind Database Deployment ScriptIt is very important that you watch the module videos associated with DML prior to completing the assessment. Navigate to the Academic Tools area of this Module and select Library then Required Readings to access your texts and videos.Task 1 - Developing SQL Statements to Query Existing DataOnce the Northwind database is successfully deployed, generate SQL statements to address the problems below. Use the following database design diagram as a guide in forming your statements:Northwind Database Design DiagramYour assessment report needs to show both the generated SQL statements and confirmatory screenshots verifying task completion.Problem 1: Display the product records with unit prices equal to or greater than $100.Expected OutputProblem 2: Present the unit value minimum, maximum, average, and standard deviation for current and discontinued products. Group the results based on the “Discontinued” attribute.Expected OutputProblem 3: List suppliers with names starting with “G” in alphabetical order.Expected OutputProblem 4: Display the full names of all Employees in FirstName, “ ” , LastName format.Expected OutputProblem 5: Display all of the supplier names and HomePage values where the HomePage value is null. Present the results in alphabetical order by supplier name.Expected OutputProblem 6: Get the number of Northwind customers in each country that has five or more customers. Present the results in alphabetical order by country name.Expected OutputProblem 7: Get the total product costs (i.e., multiplying the unit price by quantity) for ProductID = 20 along with the associated orders IDs from the OrderDetails table. Provide the results in ascending order based on the order ID.Expected OutputProblem 8: Select all of the cities where there are employees with no duplicates values displayed. Show the cities in alphabetical order.Expected OutputProblem 9: List first and last names for employees who live in London, Seattle, or Redmond. Show the employee’s city in the output.Expected OutputProblem 10: Display all product IDs and names for out-of-stock products having a unit price in the range of $20 to $25. Show the units-in-stock value in the results.Expected OutputTask 2 - Modifying Database DataYou will use the Northwind database for this task. Leverage the following database design diagram as a guide in forming your DML statements for the problems specified below:Northwind Database Design DiagramYour assessment report needs to show both the generated SQL statements and confirmatory screenshots verifying task completion.Problem 1: Use an SQL INSERT statement to populate the Categories table with a new category called “Fresh Produce” and a description of “Fresh Fruits and Vegetables.” There is no picture for this record insert. Remember, the CategoryID field auto populates so you do not include this in your insert statement. After you have added the category, select all records in the Categories table to see if the record was added.Expected OutputProblem 2: Use the SQL INSERT command to add a new region to handle customers in the Midwest. In this case, the RegionID field does not auto populate so you should first find how many regions are in the table before adding the new region and RegionID. Use a query after completing this to verify that the new region has been added.Expected OutputProblem 3: Northwind has decided to change the employee title that is now called “Sales Representative” to “Sales Specialist.” Use the SQL UPDATE statement to reflect the change in the Employees table. After you have updated the Employees table, select all records in the Employees table to see if the update was performed correctly.Expected OutputProblem 4: The Sales department has realigned and before they implement the new “Midwest” region you added, they noted that it really should be called the “Southeast” region. Change the “Midwest” region name to “Southeast” and show the regions again to confirm this change.Expected OutputProblem 5: An order needs to be deleted. The order number is 11071. However, before you can delete the order, you must delete the order details. Delete all records in the OrderDetails table that references order number 11071. Then execute a query against the OrderDetails table to show that the records associated with order number 11071 have been removed.Expected OutputProblem 6: Delete order number 11071 from the Orders table. Then execute a query against the Orders table to show that the record was removed.Expected OutputProblem 7: An employee named Margaret Peacock just received a 5% raise from Northwind. Update Ms. Peacock’s employee record to reflect this change. In order to do this, her current salary needs to be multiplied by 1.05 in the update statement.Expected OutputProblem 8: A new supplier needs to be added to the Northwind database. Generate an SQL statement to insert the following details:Company Name: Acme EnterprisesContact Name: Wylie CoyoteContact Title: Executive ManagerAddress: 123 Main StreetCity: Las VegasRegion: NVPostal Code: 89108Country: USAPhone: (702) 555-9876Note: You do not need to provide a SupplierID for this record.Expected OutputProblem 9: A customer just purchased 40 units of a product called “Boston Crab Meat” from Northwind. Reduce the current UnitsInStock value in the Products table by 40 for this product.Expected OutputProblem 10: A final call has come in from the Sales Department. After presenting the new regional alignment to the board, the board has rejected this part of the reorganization plan. Please DELETE that new region that was added earlier in Problem 2 and then changed in Problem 4 of this assessment task.Expected Output

Please see the attachment below for assignment instructions, this is a 5-6 page paper with Micro Visio and Project charts