Module 05 Course Project – Create Missing Policies

The changes you recommended in Module 03 have been approved by management.

For this week, you have been asked to review the document and update the End User Information Security Policy document with policies you have deemed to be missing.

For this submission, you will:

• Modify the existing policy with policies you believe need to be modified or added.
• Make changes directly to the document prior to submission.
• Update the revision history in the beginning of the document with exactly what changes have been made.
• Maintain the same format as the original.
• Use professional language, proper grammar and spelling.

SQL Programming
 

4. Create an INVOICE_2 table from the INVOICE table using a select statement.
 

5. Rename the INVOICE_2 table to INVOICE_3.
 

6. Add a comment to the INVOICE_3 table definitions describing the tables.
 

7. Drop the ITEMID column from the INVOICE table.
 

8. Create an INVOICE_4 table using a subquery based on the structure of the INVOICE table. Include only the ORDID, DESCRIPTION, PRODID and QTY columns. Name the columns in your new table INV ID, DESCRIPT, PROD ID and QUANTITY, respectively.
 

9. Add a first row of data to the INVOICE table with data of your own choosing. Do not list the columns in the INSERT clause.
 

10. Populate the INVOICE table with the sample data. You are to create the values to enter into the table. This time, list the columns explicitly in the INSERT clause.
 

ORDID, DESCRIPTION, ITEMID, ACTUALPRICE, QTY, ITEMTOT, PRODID
 

11. Create a script named LOAD_DATA_(your initials).sql to load rows into the INVOICE table interactively. Prompt the user for the values . Specify a default value for the QTY.
 

12. Populate the table with the four rows of sample data by running the script that you created.
 

13. Change the value for one of the DESCRIPTIONS.
 

14. Create a PRIMARY KEY constraint on the INVOICE table using the ORDID column. The constraint should be named at creation as a named table level constraint.
 

15. Add a named table level foreign key reference on the INVOICE table that will ensure that the PRODID is not assigned to a nonexistent PRODUCT.
 

16. Modify the INVOICE_3 table. Add an ORD_DATE column of DATE datatype.
 

17. Modify the INVOICE table. Add a CHECK constraint to prevent any ACTUALPRICE greater than what you think is a reasonable level.
 

18. Modify the INVOICE table by making one of the columns NOT NULL.
 

19. Create a view called INVOICE_View based on four columns in the INVOICE table. Use SQL*PLUS formatting commands to create column headings for the four columns.
 

20. Using your view INVOICE_View, enter a query to display values for three of the four columns included in the view.
 

21. Create a view named INV_VIEW_QUERY that does not allow an invoice DESCRIPTION to be changed through the view.
 

22. Create a sequence to be used with the primary key column of the INVOICE table. The sequence should start at 1000 and have a maximum value of 2000. Have your sequence increment by a single number. Name the sequence INVOICE_SEQ. Do not allow the sequence to cycle or cache.
 

23. Write an interactive script to insert a row into the INVOICE table. Name your script
Be sure to use the sequence that you created for the primary key column. Create a customized prompt to enter the DESCRIPTION. Execute your script.
 

24. Create a synonym for the INVOICE table.
 

25. Write a query to display the three columns of data for all employees with the same MANAGER_ID as Grant .
 

26. Create a query to display the employee number, last name and hire date for all employees who have a salary greater than the average salary. Sort the results in descending order of salary.
 

27. Create a report containing the employee name, address, city, and each employee’s salary. Label the columns with a different name than the column name. Break on the individual department numbers. Create a spool file for this problem.

Python (Count consonants and vowels) Write a program that prompts the user to enter a text filename and displays the number of vowels and consonants in the file. Use a set to store the vowels A, E, I, O, and U.

powerpoint theme , responds to peer based on the following response minimum of 100 words : In every large group meeting I have attended whether at a new job, my kid’s school, open houses, etc. There were PowerPoint presentations. This program is a particularly effective way to get a lot of information to a group of people effectively and in a timely manner. Truthfully, at some points in Power Point slide shows, especially long ones, my eyes tend to glaze over, and I zone out and lose focus.  

I think some key considerations you must have when developing your slide show are how engaging it is and how effectively you are communicating the information you must give. Paying close attention to what the prestation look like from the viewer’s standpoint rather than the presenter’s would be an excellent way to approach it. Are the slides cohesive? Easy to follow? Having different elements (I.e.. Bullets, photos, color schemes, varying font sizes, etc.) would be a plus too because it keeps your audience from just staring at paragraph after paragraph thus keeping their attention. 

 Exp19_Word_Ch01_ML1 – Water 1.2 

Word Chapter 1 Mid-Level 1 – Water 

 Exp19 Word Ch01 ML1 Water 1.2 

Project Description:

Your student organization has adopted the cause of supplying clean drinking water to developing nations as a fundraising effort. You design an informational handout, formatting a draft document so that it is attractive and informative.

Start Word. Download and open the file named Exp19_Word_Ch01_ML1_Water.docx. Grader has automatically added   your last name to the beginning of the filename.

Change the   orientation to Portrait. Display nonprinting characters. Delete the first two   lines (Water for Life and Changing Lives Daily).

Change margins to   Moderate. Insert a page break at the beginning of the document.

At the beginning of   the document, insert text from Title.docx.

Insert a footer   containing a page number. The page number should be placed at the Current   Position and as a Plain Number. Ensure that the footer does not show on the   first page. Close the footer.
  Note, Mac users, insert the default page number in the footer, aligned to the   left.

Insert the word adversely   between   the word that and the word affect in the first line of the second   page. Ensure that a space precedes and follows the inserted word. Replace the   words As long as in the second   paragraph on the second page with the word When.

Use the thesaurus to   replace the word reliable in the   third paragraph on the second page with a synonym beginning with the letter d.

Add Flyer   for Water for Life in the Comments box in Document Properties.

Insert a header. Type   Subject: and press SPACEBAR. Include the contents of the   Comments section in Document Properties. Use the Quick Parts command on the   Header & Footer Tools Design tab to include the information. Close the   header.
  Note, Mac users, use the Field button to add the Comments to the header.

Check spelling and   correct any errors that are identified.

Check for   accessibility, correcting for any alerts that are shown.

Save and close Exp19_Word_Ch01_ML1_Water.docx. Exit   Word. Submit the file as directed.

Review Section 2.3 of NIST SP 800-37 revision 1 (http://nvlpubs.nist.gov/nistpubs/SpecialPublications/NIST.SP.800-37r1.pdf (Links to an external site.)) and IATF v3.1, Appendix H, (located in your Module 1 Resources folder) and produce a system boundary for an enterprise-level information system.  Be sure to identify the system components within the boundary and any interfaces to external systems (through the system boundary).  If needed, refer to IATF v3.1, Chapter 3 (available in your Module 2 Resources folder) for additional information on system design. 

Your deliverable should be between 3 to 5 pages excluding your title page and reference list. 

Create an HTML document that has a form with the following controls:

1. A collection of textboxes to collect the following information:
   • student first name. Assume that first name has a max length of 25 characters.
   • student last name. Assume that last name has a max length of 25 characters.
   • student Email ID.
   • student Phone Number.
   • student address which include:
     • street address: use text box.
     • city: use text box.
     • state: use a menu so user can select state from set of available states (you need only to list up to 5 states). Make NY as default value.
     • zip code: use text box.
2. Two radio buttons that are labeled as male and female.
3. Four checkboxes that represent courses students can register, one each for the following items:
   • MAC172
   • MAC110
   • MAC101
   • MAC190
4. Two buttons named submit and reset button.  When the user clicks reset button, all data from above controls should be cleared.

Now do the following:

1. Put your code in a word document.
2. Add screen shoots to the results when you run the code into your word document as a prove you are able to run the code.
3. post your word document by replaying to this discussion board.

 What is a programming language?

What are the different types of programming languages?

Explain each of them with an example?

What are the benefits of programming languages?

Importance of programming languages?

How programming languages are helpful to a person?

APA format. No plagiarism. 20 pages and 10 slides of PPT.

Project Part 4: Business Impact Analysis (BIA) and Business Continuity Plan (BCP)

Senior management at Health Network has decided they want a business impact analysis (BIA) that examines the company’s data center and a business continuity plan (BCP). Because of the importance of risk management to the organization, management has allocated all funds for both efforts. Your team has their full support, as well as permission to contact any of them directly for participation or inclusion in the BIA or BCP. Winter storms on the East Coast have affected the ability of Health Network employees to reach the Arlington offices in a safe and timely manner. However, no BCP plan currently exists to address corporate operations. The Arlington office is the primary location for business units, such as Finance, Legal, and Customer Support. Some of the corporate systems, such as the payroll and accounting applications, are located only in the corporate offices. Each corporate location is able to access the other two, and remote virtual private network (VPN) exist between each production data center and the corporate locations. The corporate systems are not currently being backed up and should be addressed in the new plan. The BCP should also include some details regarding how the BCP will be tested. For this part of the project:

1. Research BIAs and BCPs.
2. Develop a draft BIA plan for the Health Network that focuses on the data center. The BIA should identify:
   1. Critical business functions
   2. Critical resources
   3. Maximum acceptable outage (MAO) and impact
   4. Recovery point objective (RPO) and recovery time objective (RTO)
3. Develop a draft BCP that could recover business operations while efforts are ongoing to restart pervious operations. You may use or repurpose a BCP template you find online. Include a description of how you would test the plan.

Submission Requirements

• Format: Microsoft Word (or compatible)
• Font: Arial, size 12, double-space
• Citation style: Your school’s preferred style guide

Refer to the AWS Customer Success web page where you can read case studies. You can search case studies by Company Type or by Solution to find studies for this assignment.

GTR is pleased with the report you submitted, which addressed many of the concerns with AWS. They are getting closer to moving forward with the decision to adopt AWS for their cloud computing; however, they are interested in finding out if/how other large retailers have used AWS to solve challenges. As the IT Architect, prepare a summary of at least 3 or 4 case studies with citations, to help them see how other retailers were able to use the cloud technology.

Write a 2- to 3-page summary of 3 or 4 case studies including: 

• Define performance architecture.
• Describe the issue or challenge the retailer wished to solve in each case study.
• Discuss how they used the technology and their outcome. 
• Discuss common challenges among the retailers and how the solutions may relate to GTR. 
• Explain how you think AWS can help GTR create performance architectures based on outcomes for the retailers in the case studies.

Cite the study and any other sources using APA guidelines and provide attribution, where appropriate.