Part 2: – Project Implementation – due Nov 20st @ 11:00 pm:

Report 2 Contents:

1) Project goals.

2) Database description: A general description of the database, what data is stored in the database.

How the database will benefit the users.

3) Data model & design:

o Completed ER/EER diagram; 8 tables 

 MUST use https://www.draw.io to draw the ER diagram, and then take a

snapshot.

 Include a snapshot of the diagram in the report.

o Business rules.

o Data dictionary: For each one of the tables, list columns, data types, column restrictions,

column descriptions.

4) Implementation:

o Use MySQL Server and MySQL Workbench to create the database/tables.

 Include a snapshot of the SQL code in your report

o Populate the each table with a minimum of 20 rows of sample data. Make sure the

entered data is descriptive (not just random numbers and letters.

 Include a snapshot of the SQL code in your report.

o Use MySQL Server and MySQL Workbench to write/run the SQL queries below. For

each query, provide the following in Report 2:

 Snapshot of the code and the output in the report.

 In about 2 lines, explain what the query returns.

Queries:

 1 trivial query. Simple select with ordering.

 2 medium difficulty queries. Queries that use composite condition for selection,

computations, aggregate function and grouping.

 1 query that uses subquery.

 2 queries that uses join (1 inner join, 1 left or right outer join).

 1 view (query must use join – hint: you can use one of the queries from the

previous question).

 1 query that uses union.

 1 custom stored function.

 1 custom stored procedure.

There are TWO tasks that you would need to do( they are separate): 

Task 1 (Minimum 250 words): 

–   Discuss why Goldman Sachs was a disciple of Albert Carr’s theory of “business is a poker game and we are all bluffing.” 

– Minimum two references. 

TASK 2:

Write a reply to the two responses in the attached document ( Response 1 and Response 2) with 250 words for each. 

There should be no plagiarism. Attach a plagiarism report with 0 % similarity index.

 For this assignment, you are asked to locate any company privacy policy. Some of the more popular ones might include GOOGLE, APPLE, or MICROSOFT, but you may elect to review another agency. In 3- 4 paragraphs, explain what you find to be the most interesting information contained in that privacy policy. At the end of your report, please include a LINK to the policy you have reviewed. 

You need access to Microsoft Project software. If you don’t have it installed in your computer you can at least download a trial version.

Go to Appendix on page 139 Microsoft Project and create a file as directed and enter the information from pages 139-145 on your Microsoft Project based on chapter 7.

Provide screen shots to show your work (i.e. tasks, resources, network diagram).

What did you learn from chapter 4 as you apply the concepts on chapter 4 to the Microsoft Project software?

write 3 pages on Cloud based data warehousing.

Need all discussions in individually page as a separate doc 

Discussion 1 : 

Complete this assignment in a Microsoft Word document, APA formatted and then submit it by midnight, Day 7. Your assignment should be about 2-3 pages, double spaced.

A computer company produces affordable, easy-to-use home computer systems and has fixed costs of $250. The marginal cost of producing computers is $700 for the first computer, $250 for the second, $300 for the third, $350 for the fourth, $400 for the fifth, $450 for the sixth, and $500 for the seventh.

• Create a table that shows the company’s output, total cost, marginal cost, average cost, variable cost, and average variable cost.
• At what price is the zero-profit point? At what price is the shutdown point?
• If the company sells the computers for $500, is it making a profit or a loss? How big is the profit or loss? Sketch a graph with AC, MC, and AVC curves to illustrate your answer and show the profit or loss.
• If the firm sells the computers for $300, is it making a profit or a loss? How big is the profit or loss? Sketch a graph with AC, MC, and AVC curves to illustrate your answer and show the profit or loss.

Solved Word_Intro_Cap1_National_Sales_Meeting

Project Description:

In this project, you will apply skills you practiced from the Objectives in Word Chapters 1-3. You will assist Irene Shviktar, the Vice President of Marketing, to edit and create documents for a National Sales Meeting that will precede a Winter Sports Expo sponsored by Front Range Action Sports. The documents include a cover letter from the vice president to the company president. The letter will accompany a packet of materials for the meeting and the expo, which includes a brief resume for the guest speaker, a flyer that will announce the expo, a newsletter for employees, and a research paper on the history and development of skis.

1

Open the Word document Student_Word_Cap1_National_Sales_Meeting.docx   downloaded with this Project. Be sure that the rulers and formatting marks   display.

2

On the letter on Page 1, select   the first paragraph—Front Range Action   Sports—and increase the Font Size to 28 pt. Change the Font Size of the   next four paragraphs—the address lines and website—to 12 pt.

3

Select the first five paragraph   lines that you just formatted, change the Font to Arial, and then with the   text selected, display the Borders and Shading dialog box. Create a 6 pt,   Automatic-colored border on the left side of the selected text.
 

  In the paragraph that begins If you   have any, select the second sentence and move it to the beginning of the   paragraph. Adjust spacing as necessary so that there are no extra blank   spaces at the end of the paragraph.

4

On Page 2, in the newsletter,   select the second paragraph of text, which begins with Employee Newsletter. Display the Borders and Shading dialog box,   and then add an Automatic-colored, 3 pt line below the paragraph.

5

Starting with the paragraph that   begins National Sales Meeting, select   all of the text from that point to the end of the page, including the   paragraph mark after the word event. Do   not select the Page Break. Change the Spacing After to 6 pt, format the text   in two columns, and apply the Justify alignment.

6

At the top of the first column,   select the paragraph National Sales   Meeting. From the Font dialog box, change the Font Size to 20, apply   Bold, and add the Small caps effect. Then Center the paragraph. Apply the   same formatting to the paragraph Winter   Sports Expo.

7

On the same page, in the blank   line above the last paragraph of the newsletter, insert the picture from your   downloaded files wCap1_Powder_Skiing.jpg.   If necessary, set the Width of the picture to 3″ and apply a 10 pt   Soft Edges effect.

8

In the blank paragraph at the   top of Page 3, insert a 2×3 table. In the first cell of the table, type the   following four lines, pressing ENTER after each line:
 

Robert   Lewis
1227   Aspen Lake Trail
Vail,   CO 81657
www.boblewisskis.com

9

In the second row of the table,   in the first cell, type CAREER HIGHLIGHTS and then press TAB. In the second cell of the   second row, insert the text from the downloaded file wCap1_Career_Text.docx and then press BACKSPACE to remove the   blank line at the bottom of the inserted text.

10

In the third row of the table,   in the first cell, type EDUCATION and then in the cell to the right, type Mr. Lewis’   educational information as follows, pressing ENTER after each line:
University   of Colorado
Ph.D.   in Psychology
University   of Colorado
M.S.   in Psychology
University   of Minnesota
B.S.   in Psychology

11

Insert a new row at the bottom   of the table. In the first cell of the new row, type CONSULTANT and then in the cell to the   right, type the following, pressing ENTER after each line:
U.S.   Junior Ski Team
U.S.   National Ski Team
Special   Olympics

12

Apply Bold to the headings CAREER HIGHLIGHTS, EDUCATION, and CONSULTANT. Drag the vertical border between the two columns to   the 1.5-inch mark on the horizontal ruler.

13

In the first row, merge the two   cells, and then Center the text. Select Robert   Lewis, increase the Font Size to 24 pt, apply Bold, and then add 24 pt   space Before the text. Select the web address and add 18 pt space after the   text.

14

Create a bulleted list, using   solid round black bullets, for the items below SKIING and below COACHING. Apply   Bold to the name of each university, and then apply 12 pt spacing after to   the name of each college degree.

15

Select the table, and then   remove all borders. From the Borders and Shading dialog box, add a 3 pt solid   border to the top of the table.

16

Near the top of Page 4, in the   paragraph that begins The use of skis, in   the third line, position the insertion point to the right of the period   following wood, and then insert the   following footnote: The oldest known ski and pole is more   than 4,000 years old.

17

Modify the footnote style by   changing the Font Size to 11 pt, add a First Line Indent of 0.5″, and   set Line spacing to 2.0 (double).

18

In the paragraph that begins The use of skis, position the   insertion point to the left of the period at the end of the paragraph. Using   the MLA format, add the following Book citation:
  Author: Huntford, Roland
  Title: Two   Planks and a Passion: The Dramatic History of Skiing
  Year: 2008
  City: New   York
  Publisher: Continuum Press
 

  In the text, select the Huntford citation   and add the page numbers 4-6

19

On Page 6, in the blank line   below the Works Cited title, insert   the built-in Bibliography. Select the two references, change the line spacing   to 2.0 and change the Spacing After to 0 pt. Center the Bibliography title. After the bibliography is entered and   formatted, delete the Works Cited   paragraph.

20

On Page 7, select the two   paragraphs below the title that begin Friday   and Saturday, and then change   the Spacing After to 0.

21

Select the three paragraphs below the title—the dates—and then from   the Borders and Shading dialog box, apply a Box border using theme color   Blue, Accent 1 (fifth column, first color) and a 3 pt border. Click the   Shading tab, and add Shading using theme color Blue, Accent 1, Lighter 80%   (fifth column, second color).

22

Click after the colon at the end   of the line that precedes the bulleted list. Insert the downloaded picture wCap1_Downhill_Skiing.jpg. Change the   Height of the picture to 3.5″, and then set the wrapping to Square.

23

Position the picture so that the   Horizontal Alignment is set to Right relative to Column and the Vertical   Alignment is set to Top relative to Line. Apply a Picture Style using the   Soft Edge Rectangle.

24

At the bottom of the flyer,   click in the second blank paragraph below the last paragraph of text. Insert   a Basic Process SmartArt (first style under Process). Click the outer   rectangle surrounding the SmartArt to select it, and if necessary, change the   wrapping style to In Line with Text. On the Format tab, set the Height of the   SmartArt graphic to 1″ and the Width to 6.5″. Add the following   text, in order, to the three shapes:
Exhibits
Speakers
Workshops
 

  To the SmartArt graphic, apply the 3-D Polished style.
 

25

Save and close the file, and   then submit for grading.

Assignment 7

Hide Assignment InformationTurnitin™This assignment will be submitted to Turnitin™.Instructions

Assignment Instructions:

• Congratulations are in order, your company’s network is up and running and everything seems to be working great.
• Now, you have been given a key task, the CTO is due to retire from ACME, Inc. and you are on the finalist list for your excellent work.
• The CEO has decided that he wants a forward thinking individual in the CTO spot, so he has asked the finalist to provide him a report.
• The report, which should be in a Word document, is your vision for the Network in 1 year, 3 years, and 5 years down the road. Some of the items to include are listed below.
  • What is the expected lifespan of our current network (hint: the one you have worked on the past few weeks)?
  • What is the standard lifespan for networks?
  • What upgrades would you do at each of the intervals listed?
  • What technologies should we be aware of coming down the pipeline?

Assignment Grading Criteria

Assignment Grading Criteria

Maximum Points

Appropriate use of terms, correct spelling and grammar

 1

Uses external resources validating position with applicable knowledge

 1.5

Completion of required tasks

 2

Compliance with APA Style Formatting

 .5

 Total Points:

5.0

Virtual private networks, or VPNs, offer a secure mechanism for accessing a network. Often, they are a convenience to access an organization’s infrastructure. VPNs also need to be considered in an organization’s business continuity plan. As an example, many organizations had not planned for the COVID-19 pandemic. Many had to convert their operations to a work-from-home structure, and infrastructures may not have been set up to handle the traffic. 

locate and integrate at least two quality, academic resources (in addition to your textbook) on mitigating the security risks associated with VPNs. You may also use government websites, such as Cybersecurity from the National Institute of Standards and Technology.

Please respond to the following in a post of at least 200 words: