The purpose of this project is to provide you with practice using conditional statements, loops, and functions. Your task is to write a program that allows a user to display a simple graphic shape using text symbols. Five basic shapes are allowed: V-shape, Hat-shape, X-shape, Right-Arrow-shape, and the Left-Arrow-shape. The shapes are defined as follows:

Type Parameters Limitations Sample Input Sample

Output

V-shape Number of rows

(n)

0 < n < 30 V 4 * *

* *

* *

*

Hat-shape Number of rows

(n)

0 < n < 30 H 4 *

* *

* *

* *

X-shape Number of rows

(n)

0 < n < 30

and

n is odd

X 5 * *

* *

*

* *

* *

Rightarrowshape

Number of rows

(n)

0 < n < 30

and

n is odd

R 5 *

**

***

**

*

Left-arrowshape

Number of rows

(n)

0 < n < 30

and

n is odd

L 5 *

**

***

**

*

Your project should provide an interactive menu system that allows a user to select the type of object to display.

The following menu items must be provided: V, H, X, R, L, and Q. The meanings of these items are:

V – V shape

H – Hat shape

X – X shape

R – Right arrow shape

L – left arrow shape

Q — quit.

The letter indicates which shape to display and will always be followed by a space and an integer value

representing size of the shape. Valid input can be uppercase as well as lowercase characters. All other letters

entered as command inputs are considered invalid. Provide a mechanism to allow a user to recover from an error.

For example, if the user enters a Z, do not terminate the program. Inform the user that an error has occurred,

display an error message, and discard the erroneous information i.e. if an incorrect command is detected, make

sure to flush the input buffer using cin.ignore(80,’n’).

A valid shape command code will always be followed by an integer valued size. The value provided may not be

acceptable based on the limitations outlined in the table. If you detect an invalid size, display a meaningful error

message, reject the command, and allow the user to enter a new command.

Program Design:

To solve this program, you need to decompose the problem into manageable pieces. Fortunately, the program

naturally breaks into functional units based on the different shapes. Design your solution so that your main

program calls functions to complete the various tasks. For example there should be functions to display each

shape, and there should one or more functions to get a valid command code.

1.9 LAB – Query execution plans (Sakila)

This lab illustrates how minor changes in a query may have a significant impact on the execution plan.

MySQL Workbench exercise

Refer to the film, actor, and film_actor tables of the Sakila database. This exercise is based on the initial Sakila installation. If you have altered these tables or their data, your results may be different.

Do the following in MySQL Workbench:

1. Enter the following statements:

USE sakila;



SELECT last_name, first_name, ROUND(AVG(length), 0) AS average

FROM actor

INNER JOIN film_actor ON film_actor.actor_id = actor.actor_id

INNER JOIN film ON film_actor.film_id = film.film_id

WHERE title = "ALONE TRIP"

GROUP BY last_name, first_name

ORDER BY average;

1. Highlight the SELECT query.
2. In the main menu, select Query > Explain Current Statement.
3. In the Display Info box, highlighted in red below, select Data Read per Join.

Workbench displays the following execution plan:

The execution plan depicts the result of EXPLAIN for the SELECT query. The execution plan has seven steps, corresponding to the red numbers on the screenshot:

1. Access a single film row using the idx_title index on the title column.
2. Access matching film_actor rows using the idx_fk_film_id index on the film_id foreign key.
3. Join the results using the nested loop algorithm.
4. Access actor rows via the index on the primary key.
5. Join actor rows with the prior join result using the nested loop algorithm.
6. Store the result in a temporary table and compute the aggregate function.
7. Sort and generate the result table.

Refer to MySQL nested loop documentation for an explanation of the nested loop algorithm.

Now, replace = in the WHERE clause with < and generate a new execution plan. Step 1 of the execution plan says Index Range Scan. The index scan accesses all films with titles preceding "ALONE TRIP", rather than a single film.

Finally, replace < in the WHERE clause with > and generate a third execution plan. Step 1 of the execution plan says Full Table Scan and accesses actor rather than film.

zyLab coding

In the zyLab environment, write EXPLAIN statements for the three queries, in the order described above. Submit the EXPLAIN statements for testing.

The zyLab execution plans do not exactly match the Workbench execution plans, since this lab uses a subset of film, actor, and film_actor rows from the Sakila database.

NOTE: In submit-mode tests that generate multiple result tables, the results are merged. Although the tests run correctly, the results appear in one table.

GO16_AC_CH03_GRADER_3F_AS – Contractor Services

GO16_AC_CH03_GRADER_3F_AS – Contractor Services

Project Description:

In this project, you will use a database to track facility and contractor services for an open house for prospective college students. You will create reports, modify a report in Layout view and Design view, group data in a report, and keep grouped data together for a printed report.

Start Access. Open the downloaded   file named go_a03_grader_a2_Contractor_Services.accdb and then enable the content.   View the relationship between the Contractors table and the Facility Services   table. One contractor can provide many facility services. Close the   Relationships window.

Use   the Report tool to create a report based on the Setup and Tear Down Job Costs   Query object.

With   the report displayed in Layout view, apply the Facet theme to only the   report. Delete the Job ID and Contractor ID fields from the report. Change   the width of the Contractor Last Name and Contractor First Name text box   controls to 2   inches. Change the width of the Category text box controls to 1.25 inches.

With   the report displayed in Layout view, sort the records in ascending order by   the Date field. Change the width of the Job Cost text box controls to 0.75 inch.

At   the bottom of the report and in Layout view, change the height of the   calculated control that displays $1440   to 0.25 inch. For the page number control, set   the Left property to 2.75   inches.

With   the report displayed in Layout view, select the title of the report and   change the font size to 16. In the title, change the word Query to Report.   In the body of the report, select the Date field name and set the Left   property to 0.25   inch (the Date text box controls move to the right, and all of the other fields   also move to the right). Save the report as Setup and Tear   Down Job Costs Report, close the Property Sheet, and then   close the report.

Use   the Report Wizard to create a report based on the Facility Services table.   Add the following fields (in this order) to the report: Category, Service   Description, and Job Cost. Group the records by the Category field.

Sort   the records in ascending order by the Service Description field. Summarize   the report by summing the Job Cost field.

Be   sure the layout is Stepped and the orientation is Portrait. Name the report Job Cost by Category Report, and then finish the wizard.

Display   the Job Cost by Category Report in Layout view. Apply the Wisp theme to this   report only. Select the title of the report, change the font size to 16, and   then apply bold. Apply bold to the three label controls that display the   field names.

With   the Job Cost by Category Report displayed in Layout view, delete the control   that begins with Summary for ‘Category’. Change the width of the Service   Description text box controls to 2.75   inches and the height to 0.375   inch. Save the report.

With   the Job Cost by Category Report displayed in Layout view, select the Job Cost   label control, the Job Cost text box controls that display a truncated #   symbol, and the calculated controls for the total Job Cost that display a   truncated # symbol, and the calculated control for the Grand Total that   displays a truncated # symbol. Change the width of the selected controls to 1 inch, and set the Left property to 6 inches. Save the report.

With   the Job Cost by Category Report displayed in Layout view, change the text in   the label control that displays Sum to Total Job Cost by   Category.   For the same control, set the Left Property to 3.5   inches and the width to 2.1.   At the bottom of the report, change the width of the Grand Total label   control to 1   inch. Close the Property Sheet, and save the report.

Display   the Job Cost by Category Report in Design view. Select the following two   controls: the Total Job Cost by Category label control (in the Category   Footer section) and the Grand Total label control (in the Report Footer   section). Align the right edges of the two selected controls. Save the   report.

Display   the Job Cost by Category Report in Print Preview as two pages, and notice how   the groupings break across the pages. Display the report in Layout view, and   then open the Group, Sort, and Total pane. Set the grouping option so that   each group of category records is kept together on one page when the report   is printed, and then close the Group, Sort, and Total pane. Display the   report in Print Preview, and notice that the groupings are not split between   pages. Save the report, and then close the report.

If   necessary, close all database objects and open the Navigation Pane. Close   Access and submit the database as directed.

Fundamentals of Data Science

Discussion – 300 Words

Assignment – 2 pages

1. Please share your thoughts about Threats and Vulnerabilities.

2. Please define and explain 5 most common Security Threats and Vulnerabilities.

How would you describe Apple’s pricing strategy, are they skimming pricing, penetration pricing, or target costing? Why? Justify your answer. (300 words) (10 points)

Chapter 16 – The CEO of Pride Company has asked you (the management accountant) if it is true that the discount rate is inversely related to the present value of the future cash flow. Explain your answer. (300 words) (10 points)

Chapter 17 – As a newly hired cost accountant of Pride Company, you overheard the business consultant said to one of the managers that “evaluating profitability when there are joint products should be based on the fact that joint costs do not change the degree of profitability for individual joint products.” Do you agree with this statement? Justify your answer. 

 Wk 8 Discussion

Keystroke logging, often referred to as keylogging or keyboard capturing, is the action of recording (logging) the keys struck on a keyboard, typically covertly, so that the person using the keyboard is unaware that their actions are being monitored. Explain a situation where using a keyloggers may be used in either a legitimate (legal) way or used as a tool for criminals.

 An initial post must be between 250-300 words 

Week 8 Discussion

Describe some ways that an organization can recover it’s IT resources from a natural disaster (fire, flood, hurricane, tornado etc.). What controls should have been in place in order to be able to retrieve this data?

An initial post must be between 250-300 words

Wk 8 Research Assignment

Locate an article on a system breach (Target stores, Sony Pictures, US Government, and many more).In 2-3 paragraphs, briefly explain the situation and what kind of information was compromised. How large was the breach and how long did it take to find the problem. Include a link to any of your Internet resources. 

2-3 paragraphs

 After almost a year of this pandemic, do you believe that your organization is more prepared than before? 

see attachment. No Plagarism

 Discuss the pros and cons of technical ability as a manager in two paragraphs.  In your first paragraph, discuss one reason why technical ability is crucial to an Information Security manager’s job.   In your second paragraph, discuss one reason why technical ability is a potential problem for an Information Security manager’s job. 

 500 words.  I am not looking for a deep research project, just your thoughts on the topic.  Do not use the APA format for this discussion post , except for citations and references.     This must be your own work.  I will look for plagiarism.