Using the Northwind database, write a SQL SELECT statement that will retrieve the data for the following questions:

•.Display the character constant ‘Greeting’ with a column heading of ‘Hello.’

•                           1 row returned.

•.Display all data from the categories tables without specifying the names of the table columns. Order the results by CategoryName.

•                           8 rows returned.

•.Display all employees’ names, last name first, and then first name, hire date and home phone number. Order the results by employee name, last name first, and then first name.

•                           9 rows returned.

•.Modify query 3 so that the column headings are as follows: ‘Last Name,’ ‘First Name,’ ‘Date of Hire,’ and ‘Home Phone Number.’

•                           9 rows returned.

•.Display the product name and quantity per unit, units in stock, and unit price for all products that have a unit price greater than $50. Order the results by unit price in descending order.

•                           7 rows returned

•.Display the Name of all U.S.-based suppliers. Order the results by Name in ascending order.

•                           4 rows returned.

•.Display the Order Id, ShipName, Order Date, and Freight of all orders that have a freight >/= 50 and </= 100; a ship country of Austria, Brazil, or France; and a Ship City that starts with an ‘S.’ Use, BETWEEN, IN, and LIKE for the WHERE clause conditions. Order the results by ShipName in ascending order.

•                           13 rows returned.

•.Rewrite query 7 to remove the use of BETWEEN and IN, and replace with the equivalent use of =, <, >, </=, >/= and AND and OR expressions.

•                           13 rows returned.

•.Select the Employee’s First Name, concatenated to the Last name, separated by a space. Call the column ‘Employee Name,’ the length of this employee name Length, the location of the first ‘a’ in the name ‘A Location,’ and the 5–9 characters from the name ‘Substring.’ Order the results by the Employee Name using the alias.

•                           9 rows returned.

•.For each customer, show the number of orders placed, and the largest, smallest and total freight ordered. Only show those customers who have placed more than 15 orders.

9 rows returned.

Term Paper: Networking
Due Week 10 and worth 160 points

Select one (1) of the following topics in which you will base your responses in the form of a term paper:

Write a ten to fifteen (10-15) page paper in which you:

1. Compose an executive summary highlighting the paper’s contents and reasoning for your chosen topic.
2. Conduct a SWOT analysis by analyzing the strengths, weaknesses, application opportunities, and threats from competitors of the chosen topic.
3. Evaluate the current ethical and legal concerns surrounding your topic.
4. Select one (1) ethical or legal concern surrounding your topic, take a position on the issue, and provide rationale.
5. Analyze the improvements over the last two (2) years to your communication technology topic, and suggest an improvement based on its current usage.
6. Predict the future role of the communication technology you’ve selected for both personal and commercial use.
7. Create a diagram that illustrates the communication structure of your chosen technology in Visio or its open source alternative software. Note: The graphically depicted solution is not included in the required page length.
8. Use at least eight (8) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required page length.

The specific course learning outcomes associated with this assignment are:

• Evaluate the ethical concerns that communication networks raise in a global context.
• Use technology and information resources to research issues in communication networks.
• Write clearly and concisely about communication networks using proper writing mechanics and technical style conventions.

Click here to view the grading rubric.

Grumheed Corporation

Dallas/Fort Worth Facility

Grumheed Corporation (GC), a world leader in advanced tactical drones, plans to open a facility in the Dallas-Fort Worth metroplex.  While having not settled on an exact location, ideally the facility will be within two miles of the Dallas-Fort Worth International Airport via major highway. While maintaining our original facility in Boston, the new campus will become the primary location for research and demonstration of equipment and sales.  Since our company produces state-of-the-art military equipment, this new complex must have all possible security measures.  Visitors, potential customers, current customers, support staff, design engineers and demonstration staff will all be housed in this 100,000 square foot facility. For BC/DR purposes the data warehouse will be duplicated to the Boston facility nightly.

This is a list of requirements facility:

·         Controlled access to the building for everyone.

·         A lobby, conference area, and sales area that needs controlled access

·         A highly secure area for system designers

·         An extremely secure area to house the data center.

·         Secure transfer of archival data between Dallas and Boston

·         Secure access to the Internet for employees

Please present a detailed proposal of your recommendations for physical, technical and administrative security measures for our new facility. In your proposal please recommend categories of countermeasures and the associated risks that the countermeasures mitigate. You are not expected to recommend a specific brand/model of a countermeasure. Please include a section detailing additional risks that have not been mitigated by your proposal.  Your proposal should be a minimum of 1500 words and properly site all references.

Assignment 2: Database Systems and Database Models
Due Week 2 and worth 90 points

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server.

Imagine that you have been hired as a consultant to assist in streamlining the data processing of an international based organization that sells high-end electronics. The organization has various departments such as payroll, human resources, finance, marketing, sales, and operations. The sales department is the only department where employees are paid a commission in addition to their yearly salary and benefits. All other departments compensate their employees with a yearly salary and benefits only. Commission is paid by multiplying the employee’s commission rate by the total amount of product units sold. You have access to the following data sets:

• Employee (EmpNumber, EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID)
• Invoice (InvNumber, InvDate, EmpNumber,  InvAmount)
• InvoiceLine (InvLineNumber, InvNumber,  ProductNumber, Quantity)
• Product (ProductNumber, ProductDescription, ProductCost)
• Department (DepartmentID, DepartmentDescription)
• Job (JobID, JobDescription)

Write a two to three (2-3) page paper in which you:

1. Design a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December. Note: You will need to generate the tables described above (Employee, Invoice, InvoiceLine, Product, Department, and Job) in order to compare and validate your code. Validated query code must be part of your paper.
2. Compare the code of the query you designed in Question one (1) to one that would show how much total compensation is paid to each employee for the same month.
3. Determine and explain the factors necessary to ensure referential integrity.
4. Create an object-oriented model to show how the tables are interrelated through the use of graphical tools. Make sure that you are able to show the relationship types such as 1:M, 1:1, or M:1. Additionally, remember to include the determined factors from the previous assignment requirement. Note: The graphically depicted solution is not included in the required page length.
5. Identify which data components are the entities and attributes, and the relationship between each using an object representation diagram through the use of graphical tools. Note: The graphically depicted solution is not included in the required page length.
6. Describe how Big Data could be used to assist in the productivity and forecasting of the organization’s products and resources. 

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams / charts must be imported into the Word document before the paper is submitted.

The specific course learning outcomes associated with this assignment are:

• Describe the role of databases and database management systems in managing organizational data and information.
• Design and implement a database solution to solve a proposed business problem.
• Use technology and information resources to research issues in the strategic implications and management of database systems.
• Write clearly and concisely about topics related to the strategic planning for database systems using proper writing mechanics and technical style conventions.

Click here to view the grading rubric. 

Consider a scenario where the contingency planning management team (CPMT) of your organization has designated you as the disaster recovery team leader, and the preparation and planning of this component of the security program is now under your purview with a team of 11 employees including yourself.

Write a two to three (2-3) page paper in which you:

1. Detail the DR team roles, responsibilities, and sub teams that would be implemented, and construct an organizational chart for the team through the use of graphical tools in Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.
2. Describe the proper procedures and policies that would be implemented specific to the DR team personnel as well as special equipment that would be required.
3. Draft an executive summary to the DR plan and explain the purpose of the plan and high-level specifics for upper management.
4. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources. 

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Include charts or diagrams created in Visio or Dia. The completed diagrams / charts must be imported into the Word document before the paper is submitted.

The specific course learning outcomes associated with this assignment are:

• Develop a disaster recovery plan for an organization.
• Compare and contrast the methods of disaster recovery and business continuity.
• Develop techniques for different disaster scenarios. 
• Use technology and information resources to research issues in disaster recovery.
• Write clearly and concisely about disaster recovery topics using proper writing mechanics and technical style conventions