Computer Science Homework Help

Part 1

Referring back to your Reading and any other resources you have found, write a 2-page descriptive paper that addresses the following:

1. What is the cloud?
2. What are at least three potential benefits of the cloud?
3. How can virtual environments reduce the need for new hardware?
4. Would virtualization technology be beneficial to start with versus cloud resources? Why or why not?
5. 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 technologies

Be sure to also include the following within your submission:

• Screenshots demonstrating experience installing and configuring a virtual environment.

Part 2

Explore 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 Instructions

You 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 Express

Microsoft SSMS

The 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 Script

It 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 Data

Once 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 Diagram

Your 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 Output

Problem 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 Output

Problem 3: List suppliers with names starting with “G” in alphabetical order.

Expected Output

Problem 4: Display the full names of all Employees in FirstName, “ ” , LastName format.

Expected Output

Problem 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 Output

Problem 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 Output

Problem 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 Output

Problem 8: Select all of the cities where there are employees with no duplicates values displayed. Show the cities in alphabetical order.

Expected Output

Problem 9: List first and last names for employees who live in London, Seattle, or Redmond. Show the employee’s city in the output.

Expected Output

Problem 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 Output

Task 2 – Modifying Database Data

You 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 Diagram

Your 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 Output

Problem 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 Output

Problem 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 Output

Problem 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 Output

Problem 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 Output

Problem 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 Output

Problem 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 Output

Problem 8: A new supplier needs to be added to the Northwind database. Generate an SQL statement to insert the following details:

Company Name: Acme Enterprises
Contact Name: Wylie Coyote
Contact Title: Executive Manager
Address: 123 Main Street
City: Las Vegas
Region: NV
Postal Code: 89108
Country: USA
Phone: (702) 555-9876

Note: You do not need to provide a SupplierID for this record.

Expected Output

Problem 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 Output

Problem 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