Hello, I need assistance with an assignmnt in Python. I have attache the instructions below as well as the worksheet that should be used at the very bottom!

Thanks in advance!!!

_____________________________________________________________________________________________

Instructions

General Description

In this assignment, you will warm up your coding skills with one python project example. This example is very important because all the following assignments and final project are based on this project. Next, I will lead you to download this project and run it. You need to repeat all the steps and submit your work by using the attached Assignment 1 template.

Computer Requirements

Before we start, you have to make sure you have successfully installed Python, Python IDE (I recommend PyCharm), and PostgreSQL Database.

I believe you have learned how to set up Python, here is the link for PostgreSQL Database: https://www.postgresql.org/download/

If you never used a Python IDE, you need to see the tutorial: https://www.jetbrains.com/pycharm/learn/

You can choose any Python IDE if you are a Python Developer.

Now Let’s start

Setting Up a Database

To get started, you’re going to set up a fresh PostgreSQL database and populate it with data. Throughout the tutorial, you’ll use this database for witnessing firsthand how Python SQL injection works.

Step 1. Install PostgreSQL

You can download the installer from https://www.postgresql.org/download/

In the installation process, you will create a database “postgres” for user “postgres” by default if you didn’t change the names.

Step 2. Open the SQL Shell Tool

Step 3. Check your user and password

Input nothing for Server, Database, and Port. Just press Enter.

Input “postgres” in Username Enter

Input your password in Password for user postgresEnter

Then you will see the following in your window

Step 4. Add a User Table

Input the following command then you will see the following picture

psycopgtest=# CREATE TABLE users (

username varchar(30),

admin boolean);

Step 5. Add two users

Input the following command then you will see the following picture

Change one of the users to your name and set false (non-admin user)

psycopgtest=# INSERT INTO users

(username, admin)

VALUES

(‘ran’, true),

(‘YourName‘, false);

Step 6. Check all the users in Database

Input the following command then you will see the following picture

psycopgtest=# SELECT * FROM users;

Setting Up Python Environment

Step 7. Make sure you have installed Python

Check your python version with the command: python –version

If you have python set up on your computer, you will see a version number. If not, you need to install Python first. I believe you have learned how to do it in programming class.

Step 8. Install psycopg2

Use the command: sudo pip install psycopg2-binary

If you have error like the following picture, you need to update your pip by using the command: pip install –upgrade pip

After the upgrade, re-try: sudo pip install psycopg2-binary

If you still failed, you may need to re-install your python.

Run Python Code

Step 9. Download and run the python file “DatabaseInjectionExample.py”

• Open the downloaded file in any IDE or editor.
• [Only if you changed default database name and username] Change the database name and username to your database name and username
• Change the password to your password.
• Change the name “yan” in line 30 to your name used in Step. 5

Then, you will see the printout:

Step 10. Check an un-defined user

Change the name in line 30 to “foo”, then, you will see the error because there is no user “foo” in the database.

Step 11. Try database Injection attack

Change the name in line 30 to “‘; select true; –“

The code of line 30 will become to

print(is_admin(“‘; select true; –“))

Then run to see the output:

True? What happened? You hacked your Database!!

Step 12. Change your “username” to admin user illegally.

Add the following code after line 30. Don’t forget to change “Yan” to your username.

True? What happened? You hacked your Database!!

print(is_admin(“‘; update users set admin = ‘true’ where username = ‘yan’; select true; –“))
print(is_admin(“yan”))

Then you will see the output shows you are the admin user now!!

__________________________________________________________________________

https://kennesaw.view.usg.edu/d2l/le/dropbox/23998…

(worksheet that should be used)

Requirements:

• Two data sources are combined correctly
• Any reference to revenue correctly calculates (or identifies) deposits and monthly payments.
• Each participant should construct at least One Visual (minimum, 3 visuals for presentation)
• The final notebook should show the visuals in line with text in the markdown cells articulating:
  • What this graph is showing
  • Why it is important
  • What it means for the business
  • Any action items the business should take with this knowlege
• The data work and code to process each step should be in separate .py files
• The final project notebooks should call each (if more than one) .py file to execute the code for each step

Upload 2 files: the program as a “.py” file. A copy of its execution as a notepad or word file

Write and execute a Python program for the following problem where a few simple statistics for a soccer league week will be computed.

Each team plays one match. Each match has a winner and a loser. In a match, one team is the home team, and one team is the visiting team. At least one goal is scored in any match.

Data will be read in the following order, one match after the other:

Name of home team

Score of the home team

Name of the visiting team

Score of the visiting team

…………

Enter “done” when there is no more matches.

Calculate and display the following results.

Number of games

Number of wins by the home teams, number of wins by the visiting teams.

Total number of goals and average scored by the home teams, by the visiting teams

Total number of goals and average conceded by the home teams, by the visiting teams

Total and average goal differential for the home teams

Total and average goal differential for the winning teams

Team with the largest number of goals scored, team with the largest goal differential (if several teams have the same value, pick any one). Indicate if home team or visiting team.

Execute the program on the following data (each data must be on separate line, not like here). Do not use advance features such as lists, tuples, arrays. Data must be inputted by execution of the program, they must not be “hard-coded” in the program)

AA 4 Bb 0

Cix 2 Doe 6

Elo 1 PSG 7

OM 3 As 0

MU 10 Mc 3

Rm 1 Bar 8

Losc 5 Br 14

done

Use the breast cancer dataset available in sklearn package. You are required to show the steps in loading the data set, perform exploratory data analysis, identify the algorithm (from what has been covered in the seminars) suitable for detecting breast cancer. Present appropriate performance metrics. 

PLEASE USE SCRIPT COMMAND TO RECORD ALL STEPS. PLEASE SEND SCREEN SHOTS OF ALL SCRIPTED COMMANDS.

1.Download the file “make_samples” attached

2. Run the script command on your Unix/Linux command line terminal to start capturing, name the typescript file as ‘Makefiles_codeproject.typescript’.

3. Follow the tutorial, run the commands as shown in the tutorial to capture the transactions

4. Download “Programming assignment 1” file.

5. On a command line terminal run the script command to start capturing into a file name PA_makefile.typescrip

6. Display the content of the makefile for PA1.

7. Compile your programs for PA1to make the executable using make command

8. Make some changes to the program (e.g. add comments, etc…)

9. Run make again

10. Add a module named version (e.g. version.c or version.cpp) that has a single function: displayVersion() that simply displays “Current version is 1.2” where 1.2 is the value of a static global variable named version declared in the main module when gets called. Change you main module to add the version variable and modify the main function to call displayVerison() at the beginning.

11. Rebuild your executable for PA1using make, Run the program to confirm that version is displayed.

12. Register with github to create your own free account. Create repositories for your programming assignment 1

13. On a command line terminal run the script command to start capturing into a file name PA_GitHub.typescript

14. Create repositories for your programming assignment 1(PA1)

15. Show status of your local repository

16. Push your repositoryfor PA1 to your GitHub repositories

17. Show status of your remote repositories

18. Make some changes to your PA1program, show status of your local repositories

19. Push the changes to your remote repositories

20. Show status of your remote repositories

Please Submit files containing your makefiles, and your typescript files.

undefinedPython CRASH COURSE, Project 1: Alien Invasion (Chapter 12: A Ship that Fires Bullets、Chapter 13: Aliens!、Chapter 14: Scoring）, Please read these three chapters to answer the following questions.

0.Software and Libraries required for this project implementation.

1. What Python files, classes, and functions were used in Project 1: Alien Invasion?

2.Write the purpose and roles of each of the Python files, classes, and functions used in Project 1: Alien Invasion. (This part is very important, please analyze in detail.)

3. Explaining the Logic of each classes/functions?

4.What import modules were used in Project 1: Alien Invasion?

5. What is the purpose, function, and role of each module used in Project 1: Alien Invasion?

6. High level activities or Major functional implementation of this project.

Assignment Title: Laboratory Project 5 –

Creating a Simple Website Using Notepad & HTML Project Description:

This project requires you to create your personal website applying the knowledge you have acquired in class. You will use normal Notepad as a text editor ( or Notepad++) to create the web pages. The website will have a start (home) page. Create a new folder in C: directory and name it as your name.html ◆ Save the file as about.html in the created directory c:your name.html ◆ Test / View / Edit using your browser ◆ It will also have the following pages as links on the home (start) page. } A link to the PVAMU Website. Clicking the link must open the University website. } A link to your favorite educational site (only one site). The project is due on Tuesday, April 27, 2021. You must submit it electronically through CANVAS.

Ms. Chavez is interested in seeing what tracking information in a database would look like, rather than relying on Excel spreadsheets. She heard it was easier and would cut down on data redundancy. She has given you a list of music CDs that she owns and would like you to create a database using that information. She also wants to hear, briefly, your thoughts on why you chose the primary key you did and what all you did as you created the database.

You will come up with the following information to use in the database:

• Fifteen album Names (real or fake) – You can use the table below as needed. 
  • Of those fifteen albums, there should be at least two types of music (genres). These can be anything from hip-hop to classical.
  • Each of the fifteen albums should have their format recorded as well (CD, cassette, or recordOnce you’ve created that information, do the following:
    • Create a database to track the data.
    • Create at least 2 related Tables.
    • Create a Query showing all the music in one of the genres (for example: Jazz). Name it after that genre of music (for example: Jazz query).
    • Choose what your primary key will be.
    • Create a Report based on the Query created in the previous step.
    • Create a Form, using the Form Wizard to enter the information for each CD.

I’m studying for my C Programming class and don’t understand how to answer this. Can you help me study?

explain the code for each line what does each line do?