Monthly Archives: June 2023

Attached Files:

 data2.zip   (8.919 MB)  Restoring_Postgres.txt   (996 B)Go to this  site to install PostgreSQL and pgadmin.

Here is a video tutorial on how to install Postgres on the Mac.

Extract the data.dump file from the attached data.zip file and use the psql command to create the sqlda database (see attached file)

Go to this site (https://www.python.org/downloads/) to install the latest Python distribution. 

Go to this site (https://www.r-project.org/) to install the R programming language and this site to download the free R Studio development environment.

After watching this video, install Git and Github. 

Submit one document with five screen shots from your computer. Include enough of the screen so the viewer can see that the image is of your computer.

1. sqlda tables in pgadmin

2 use l to show a list of your PostgreSQL databases

3. An Idle page with a hello World script (tutorial here and here)

4. Github

5. R Studio

Please make sure that your images are large enough and high enough resolution for the reader to see the text in your queries and the results. 

Please note that all code assignments must be submitted as a screenshot with a slice of your desktop showing the timestamp.If the time and date are not visible, you will be graded 0. 

Using PGAdmin4 create the database sqlda. Then, use the psql command line tool available in the Postgres 12 program folder to restore the database. 































































































































Here is the sample text that I used. 

c:Program FilesPostgreSQL12bin>psql -U postgres -d sqlda -f "C:UsersdavepOneDriveDesktopdata2.dump"







In the cmd window, navigate to the foler where psql.exe resides. You can see above where it resides on my Windows computer after a default installation. 



Execute the psql command tool and input these responses to the questions posed as follows: 



c:Program FilesPostgreSQL12bin>psql



Server [localhost]: localhost



Database [postgres]: postgres



Port [5432]: 5432



Username [postgres]:postgres



Password for user postgres: 



You can list your databases in the command line with l



You can connect to the sqlda database with c



Then you can list the database tables with dt



You can also check in PFAdmin4 for the new database (you may need to refresh).

Deadline ASAP

1: Explain how two-dimensional arrays are passed to functions. In your explanation include a two-dimensional array declaration and initialization, a function prototype that receives a two dimensional array, and a function header with an empty body that matches the function prototype. Demonstrate how a two dimensional array is passed to the function as an argument.

2: Given a two-dimensional array named number of three rows and four colums of type int, write the single code statement that will both declare and initialize the array such that the first row is initialized to 0,1,2,3; the second row is initialized to 4,5,6,7; and the third row is initialized to 8,9,10,11.

3: Explain what constructors do and when they are executed. Explain the two types of constructors. Provide an example class that includes both types of constructor functions and demonstrate how an object would be instantiated using both types of constructors.

4: Discuss what the difference is between an interface file and an implementation file and provide file name examples for both if a class Insect is to be created using them.
SOLUTION:

5: Write and explain the definition composition and how it is useful in writing object-oriented programming. Also, explain how it is different from inheritance and how both inheritance and composition are useful in developing object-oriented programs.

6: Explain how access privileges affect members of the derived class and the objects created from them.

7: If a class is derived protected from a base class, explain how this affects the inheritance of all public, protected, and private members of the base class by the derived class.

8: Why are comments and comment blocks important to programming?

Use only 50-words  per topic to discuss and present your answer. The discussion questions this week are from Chapter 14  (Jamsa, 2013).You are required to use at least two sources (besides your textbook) to answer the above questions.

1. Describe how web pages differ from apps and how apps differ from widgets.

2. Discuss why developers say that HTML5 will drive mobile solutions.

Assignment Content

1. Projects that conform to the Agile methodology often use something called a scrum board. You can think of a scrum board as a digital whiteboard containing yellow “stickies,” each listing a task, posted beneath categories such as “to do,” “in process,” in testing,” etc. Using a scrum board in this way allows all project members to see where important tasks are in the overall project process quickly and easily.  

   For this Learning Team assignment, you will collaborate with your team members to create an Agile scrum board based on the Global Treps project from the Wk 2 Team assignment (see below).

   Note that in an industry situation, you would most likely use a specialized software tool to manage your scrum board such as Jira, Rally, Asana, or Basecamp. However, in this course, you will be using a tool that you may already be familiar with—Microsoft Excel—to create your scrum board and other deliverables. It is the organization and assignment of tasks that is important about a scrum board, not the specific software tool you use to create and manage it. 

   To complete this Learning Team assignment: 

   Reread the Global Treps Scenario that you read in the Wk 2 Team – Apply assignment.

   Review the Learning Team Scrum Board Example spreadsheet. (Note: Click the Board tab that appears at the bottom of the spreadsheet to see the scrum board example.) 

   Create a scrum board in Microsoft Excel format, similar to the linked example, to align with the project scoping document your team created in Wk 2. Ensure that your finished scrum board incorporates a project budget.  

   Submit the team assignment. 

Write a python program to extract all the blocks where value for ChecksWarning is more than 0. Attached is the JSON data.

To address hacking, Congress enacted the Computer Fraud and Abuse Act (CFAA) in 1986 as an amendment to the first federal computer fraud law. Over the years, it has been amended several times, most recently in 2008, to cover a broad range of conduct far beyond its original intent. The CFAA prohibits intentionally accessing a computer without authorization or in excess of authorization, but fails to define what “without authorization” means. With harsh penalty schemes and malleable provisions, it has become a tool rife with opportunities for abuse and use against nearly every aspect of computer activity.

https://www.carltonfields.com/insights/publications/2020/us-supreme-court-computer-fraud-abuse-act

 (Links to an external site.)

Describe how, as technology advances, the use of the criminal law to regulate conduct using such technology also advances.

Write a paper articulating the leadership models, the pros and cons of each, and examples of leadership that comprise each model.

Text

Title: Managing Project Stakeholders 

ISBN: 9781118504277 

Authors: Tres Roeder 

Publisher: John Wiley & Sons 

Publication Date: 2013-04-22

I have attached the questions in Word document for pivot tables and two python programs along with the additional excel data related to the question for pivot.

Every Milestone needs to be a separate Word file.

• Milestone #2 – Project title and an annotated bibliography of your sources. You may change your bibliography before the final paper is due, but this preliminary reference list should present a complete view of your topic. You need at least three references for your paper (in addition to your textbook). The reference page is an annotated bibliography that includes a synopsis of the reference.  Use the APA annotated bibliography template for this deliverable! 

• Milestone #3 – An abstract and an outline. The abstract is one paragraph that states the contents of your paper so that potential readers can decide whether or not to continue reading. Your outline doesn’t need to be complete, however should include sufficient detail to show the structure of your paper. Purdue Owl is a good reference for sample outlines. 

• Milestone #4 – Complete your report’s first draft. Write it as if it’s going to company executives. You should fully explain any technical terms used. You’ll also need to present your paper to your fellow students via the Discussion Board. The other students will give you feedback on your writing, ideas, information, and conclusions. Then, submit your paper to turnitin.com for a plagiarism check.

• Milestone #5 – The final version of your Business Report. Your final paper should be 10 – 12 pages in length (not including the title and reference pages) and follow APA or MLA formatting. It is worth 50% of the overall grade for the paper (100 points). Make any desired changes to your paper based on the discussions with your fellow students, make sure that your paper passes a plagiarism check via turnitin.com, and then submit it to your instructor.