This assignment consists of two parts. Part A requires you demonstrate the normalization process by first discussing the first, second, and third normal form, then drawing a dependency diagram among the attributes. Part B requires you to create three tables, populate data into these tables, and write queries. Part B of the assignment gives you hands-on experience on writing Oracle SQL statements. Use the following as references when you work on the assignments.

• SQL Exercise: Write SQL commands to create and modify the structure of a table.
• Query Exercise: Write SQL commands to query from one and more than one table.
• Normal Form Conversion Exercise: Draw functional dependencies diagrams and convert into a set of tables to satisfy the third normal form.

Case Assignment

Download the Module 3 Assignment worksheet and answer the questions in the downloaded document. When you are done with the assignment, submit the file to the Case 3 Dropbox.

Assignment Expectations

• Finish both part A and part B of the assignment.
• Apply what you have learned in this module to address the questions.

a. Write a Java program that is reading from the keyboard a value between 111 and 900 and is printing on the screen the prime factors of the number.

Your program should use a cycle for validating the input (if the value typed from the keyboard is less than 111 or bigger than 900 to print an error and ask the user to input another value).

Also the program should print the prime factors in the order from smallest to biggest. 

For example,

for the value 128 the program should print 128=2*2*2*2*2*2*2 

for the value 122 the program should print: 122=2*61

b. change the program at a. to print one time a prime factor but provide the power of that factor:

for the value 128 the program should print 128=2^7

for the value 122 the program should print: 122=2^1*61^1

  Review the attached file. Suzie has an issue. She can either move to NY or FL and needs to review some data that her agent gave her. The agent reviewed house prices and crime ratings for houses that Suzie would be interested in based on her selection criteria.  She wants to live in an area with lower crime but wants to know a few things:

1. Is it more expensive or less expensive to live in FL or NY?
2. Is the crime rate higher in FL or NY (Note a low score in crime means lower crime)?
3. Is the crime rate higher in lower or higher house price areas?

Using the R tool, show the data in the tool to answer each of the questions.  Also, show the data visualization to go along with the summary.

1. If you were Suzie, where would you move based on the questions above?
2. After you gave Suzie the answer above (to #4), she gave you some additional information that you need to consider:
   1. She has $100,000 to put down for the house.
   2. If she moves to NY she will have a job earning $120,000 per year.
   3. If she moves to FL she will have a job earning $75,000 per year.
   4. She wants to know the following:
      1. On average what location will she be able to pay off her house first based on average housing prices and income she will receive?
      2. Where should she move and why?  Please show graphics and thoroughly explain your answer here based on the new information provided above.

      Note: The screenshots should be copied and pasted and must be legible.  Only upload the word document.  Be sure to answer all of the questions above and number the answers.  Be sure to also explain the rational for each answer and also ensure that there are visuals for each question above. Use at least two peer reviewed sources to support your work.  

 Discuss some of the critical issues in preparing a budget for a multinational enterprise (MNE) and global enterprises? 

 As technology revolutionizes the manufacturing operations, what are some of the adjustments needed to be made (if any) to standard-costing system to remain as an effective measure in today’s business environment? 

 The CEO of Pride Company wants to understand when the company should use a conventional flexible budget or activity-based flexible budget. As the company’s cost accountant, describe to the CEO the similarities and differences, advantages and disadvantages of conventional and activity-based flexible budget 

Exp19_PowerPoint_Ch02_CapAssessment_Food

Project Description:

Your school’s Culinary Club is raising money for the local food bank. You volunteer to create a slide show that will be shown at a potluck fundraiser put on by the club. In this activity, you will create a presentation that meets slide show design principles, and has shapes, animation, video, and audio.

Start   PowerPoint. Download and open the file named Exp19_PPT_Ch02_CapAssessment_Food.pptx.   Grader has   automatically added your last name to the beginning of the filename

Replace Student Name in the subtitle placeholder on Slide 1 with Carl   Patterson Change   the title font size to 54.

Click Slide 2. Change the title font size to 48. Change the subtitle font   size to 32.

Click Slide 3. Change the title   to sentence case. Change the title font size to 54. Change the bulleted text   to 32.

Click Slide 4. Change the title   font size to 48. Change the bulleted text to 32.

Click Slide 5. Change the title   font size to 48. Change the subtitle font to 27.

Click Slide 4 and insert a heart   shape. Size it to a height of 2.5” and a width of 2.75” . Apply Colored Fill – Red, Accent 1, Darker   25%. Apply a shape outline in Black, Text 1. Apply Preset 2 as a shape   effect. Position the shape horizontally at 10.35” from the Top Left Corner.   Position the shape vertically at 4.9” from the Top Left Corner.

Click Slide 2. Select the   subtitle text and add the Zoom Entrance animation. Click After Previous in the Start box.   Adjust the Duration to 01.75 and the Delay to 00.50.

Click Slide 3. Select the first   text bullet and apply the Fade Entrance effect. Set the animation to start   After Previous with a Duration of 02.00 and a Delay of 01.75. Click the   Animation Pane, and then click the arrow for the first bullet. Select Effect Options   to access the Fade dialog box. Set the After Animation to Orange (sixth from   the left) on the Effect tab.

Select the second text bullet   and apply the Fade Entrance effect. Set the animation to start After Previous with a Duration of 02.00 and a   Delay of 01.75. Click the arrow for the second bullet in the Animation Pane.   Select Effect Options to access the Fade dialog box. Set the After Animation   to Orange (sixth from the left) on the Effect tab.

Select the third text bullet and apply the   Fade Entrance effect. Set the animation to start After Previous with a   Duration of 02.00 and a Delay of 01.75. Click the arrow for the last bullet   in the Animation Pane. Select Effect Options to access the Fade dialog box.   Set the After Animation to Orange (sixth from the left) on the Effect tab.

Click Slide 4 and select the   heart shape. On the Animations tab, in the Animations group, click More and   add the Pulse Emphasis effect. Set the animation to start After Previous with   a Duration of 01.00 and a Delay of 0.25. Click the arrow for the shape in the   Animation Pane. Select Timing and set Repeat to Until End of Slide and click   OK.

Click Slide 1 and add the Fade   transition. Set the Duration at 01.00. Set the slides to advance   automatically after 00:07.00. Set it to apply to all.

Click Slide 5. Insert the   downloaded video file Veggies.mp4. 

Apply the Rounded Diagonal   Corner, White moderate video style.

Set the video to start Automatically. Change the Video   Options to Hide While Not Playing and to Rewind after Playing. Compress the media in the   presentation using the Standard setting. Mac users, compress all pictures in   the presentation using the On-screen setting.

Save and close Exp19_PPT_Ch02_CapAssessment_Food.pptx.   Exit PowerPoint. Submit the file as directed.

need the complete homework answers

Complete the following assignment in one MS word document: 

Chapter 3 –discussion question #1-4 & exercise 12

When submitting work, be sure to include an APA cover page and include at least two APA formatted references (and APA in-text citations) to support the work this week.
All work must be original (not copied from any source).

 1. How do you describe the importance of data in analytics? Can we think of analytics without data? Explain. 

2. Considering the new and broad definition of business analytics, what are the main inputs and outputs to the analytics continuum? 

3. Where do the data for business analytics come from?  What are the sources and the nature of those incoming data? 

4. What are the most common metrics that make for analytics-ready data? 

Exercise-12:

  Go to data.gov—a U.S. government-sponsored data portal that has a very large number of data sets on a  wide variety of topics ranging from healthcare to education, climate to public safety. Pick a topic that you are most passionate about. Go through the topic-specific information and explanation provided on the site.  Explore the possibilities of downloading the data, and use your favorite data visualization tool to create your own meaningful information and visualizations. 

Excel 1G Regional Sales

#Excel_1G_Regional_Sales

Change the Theme to Retrospect. (If the Retrospect theme is not  available on your computer, in the Themes gallery, click Browse for  Themes, and then select the theme from your downloaded project files.)  Set the width of column A to 80 pixels and the width of columns B:H to  110 pixels. If any columns are too narrow to display all the data, apply  AutoFit to the column.
Mac users: Set column A to 68 pixels and columns B:H to 95 pixels. If  any columns are too narrow to display all the data, apply AutoFit to the  column.

Merge and center the title across the range A1:H1, and then apply the  Title cell style. Merge and center the subtitle across the range A2:H2,  and then apply the Heading 1 cell style.

Select the seven column titles, apply Center formatting, and then apply the Heading 4 cell style.

By using the Quick Analysis tool, Sum the Quarter 1 sales, and then  copy the formula across for the remaining Quarters; the Quick Analysis  tool formats totals in bold.
Mac users: Instead of the Quick Analysis tool, use the AutoSum button, and then apply 
bold formatting to the results. 

Select the Northeast sales for the four quarters, and then display  the Quick Analysis gallery for Totals. Click the second Sum option—the  sixth item in the gallery—which displays the column selection in yellow.  Copy the formula down through cell F7; recall that the Quick Analysis  tool formats sums in bold.
Mac users: Instead of the Quick Analysis tool, use the AutoSum button, and then apply Bold formatting to the total.

Apply the Accounting Number Format to the first row of sales figures  and to the total row. Apply the Comma Style to the remaining sales  figures. Format the totals in row 7 with the Total cell style. Increase  the column widths as needed.

888

Insert a new row 6 with the row title Midwest and the following sales figures for each quarter: 110985.45 and 118674.91 and 100548.50 and 120621.17 Copy the formula in cell F5 down to cell F6 to sum the new row.

669

Using absolute cell references as necessary so that you can copy the  formula, in cell G4 construct a formula to calculate the Percent of  Total Sales for the first region. Copy the formula down for the  remaining regions.

101010

To the computed percentages, apply Percent Style with two decimal places, and then center the percentages.

6811

Insert Line sparklines in the range H4:H7 that compare the quarterly  data. Do not include the totals. Show the sparkline Markers and apply a  style to the sparklines using the second style in the second row.
 

Note, Mac users, select the first style in the second row.

5.6812

To compare the quarterly sales of each region visually, select the  range that represents the sales figures for the four quarters, including  the quarter names and each region—do not include any totals in the  range. With this data selected, by using the Recommended Charts command,  insert a Clustered Column chart with the regions as the category axis  and the Quarters as the legend.

Apply Chart Style 8. Change the colors by applying the third row of  colors under Colorful. Position the upper middle sizing handle of the  chart on the line between column D and column E and just below row 9.

Change the Chart Title to Regional Sales to Fitness Clubs

Deselect the chart. Change the page orientation to Landscape. Center  the worksheet horizontally on the page, and then insert a Footer with  the File Name in the left section.

Show the document properties. As the Tags, type fitness clubs, regional sales In the Subject box, type your course name and section number. Be sure your name displays as the Author.

Save and close the workbook, and then submit for grading

1. Phase 4 of the Final Project is a proposal to provide a comprehensive security plan for your organization.
2. As the final step of this proposal, you will prepare a comprehensive Security Awareness and business continuity plan (taking what you did in Assignment 5.3 and expanding upon the summary) that will be used throughout the organization. The plan should address awareness from the perspective of employee expectations. The business continuity plan should address the requirements needed to recover from potential disasters, whether through natural causes (weather, fire, etc.) or a security breach. The paper should be outlined as follows:
   1. Executive Summary/Introduction
   2. Threat Analysis (Assignment 2.4)
   3. Mitigation Strategies (Assignment 4.4)
   4. Business Continuity Plan (Assignment 5.3 was an overview)
   5. Security Awareness Program Plan/Overview
   6. Conclusion
3. Provide transitions between these six sections. The total length of the paper should be at least 10 pages. You may use graphics or other features within your paper; however, these do not count toward the 10 page total.
4. Make sure the paper is double-spaced and in  APA format. The paper should have a minimum of five references, which should be cited correctly within the paper as well as on the Reference page using APA format.

You have been hired as the CSO (Chief Security Officer) for an organization. Your job is to develop a very brief computer and internet security policy for the organization that covers the following areas:

• Computer and email acceptable use policy
• Internet acceptable use policy

Make sure you are sufficiently specific in addressing each area. There are plenty of security policy and guideline templates available online for you to use as a reference or for guidance. Your plan should reflect the business model and corporate culture of a specific organization that you select. Include at least 3 scholarly references in addition to the course textbook.  The UC Library is a good place to find these references. At least two of the references cited need to be peer-reviewed scholarly journal articles from the library.Your paper should meet the following requirements:

• Be approximately 2-4 pages in length, not including the required cover page and reference page.
• Follow APA7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
• Support your answers with the readings from the course and at least three scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.
• Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.