Given is a Python program that connects to a sqlite database and has one table called writers with two columnns:

• name - the name of a writer
• num - the number of works the writer has written

The writers table originally has the following data:

name, num

Jane Austen,6

Charles Dickens,20

Ernest Hemingway,9

Jack Kerouac,22

F. Scott Fitzgerald,8

Mary Shelley,7

Charlotte Bronte,5

Mark Twain,11

Agatha Christie,73

Ian Flemming,14

J.K. Rowling,14

Stephen King,54 Oscar Wilde,1

Update the Python program to ask the user if they want to update entries or add new entries. If the name entered already exists in the writers table then the database record is updated, overwriting the original contents. If the name does not exist in the writers table, then add a new record with the writer's name and number of works. The following TODO sections must be completed.

• Check if a writer exists in the writers table
• If the writer exists in the table, locate an entry to be updated by writer's name and update the writer's value for num
• If the writer does not exist in the table, add a new entry in the writers table and provide the value for name and num

Ex: If the input is:

y

J.K. Rowling 30

y

Elton John

y

62

n

What is output. Getting nothing but errors with existing help. Again, this is for Python3

Please provide step by step detailing on how i should do this assignment. In Angel, you will find a class called Employee. This class should include a constructor which sets name to blanks and salary to $0.00 and a constructor which sets name to a starting name and salary to a set amount. Additionally, the class should include methods to set the name and salary and return the name and salary. Create another method to return the name and salary nicely formatted as a string (hint – research the toString method). You will create a new class called Manager that inherits from the class Employee. Add a field named department of type String. Supply a method toString that prints the manager's name, department, and salary. Remember, you may not change anything in the Employee class. You will then create a test class that uses the Manager class. The test class should prompt the user to enter name, department and salary. This information should be stored in an array. Upon entry of 3 employee records, the program should output the information you entered. Your program should be able to handle a maximum of 3 entries. You may write the program as a console application or using dialog boxes. Also, please provide explanation on how to create each class on java eclipse so that the code can run successfully. Please provide description for everything, I’m a beginner trying to do this assignment.

Consider the following relational database schema:

            employee(employee-name, employee-id, street, e-city)

            works(employee-id, company-id, salary)

            company(company-name, company-id, c-city)

            manages(employee-id, manager-id)

Specify the following queries on this database schema using the relational operators we discussed in class. Write your answers on a separate sheet of paper in the order that they are specified below.

1. Retrieve the name and address of employees who work for First Bank Corporation.

2. Retrieve the name, street address, and city of residence of all employees who work for Thrifty Industries and earn more than $10,000 per year.

3. Retrieve the name of all employees who live in the same city as the company for which they work.

4. Retrieve the name of all employees who live on the same street and in the same city as do their managers.

5. Retrieve the name of all employees who do not work for First Bank Corporation.

6. Retrieve the name of all employees who earn more than every employee of Small Bank Corporation.

7. (Assume that companies may be located in several cities) Retrieve all companies located in every city in which Thrifty Industries is located.

8. For each company, find the average salary of employees working for that company.

9. For each city, find the number of employees who work for at least one company in that city.

1)  Write a python program that opens a file, reads all of the lines into a list of strings, and closes the file. Use the Readlines() method. Test your programing using the names.txt file provided.
2) Convert the program into a function called loadFile, that receives the file name as a parameter and returns a list of strings.
3) Write a main routine that calls loadFIle three times to load the three data files given into three lists. Then choose a random element from the title list, two from the name list, and one from the descriptor list to generate a name. Print the name be in the form shown (you have to add the "the"):
title name name the descriptor
For example:
King Ludovicus Botolf the Bowman
Print the name to the screen.   
Submit your python file (.py) to Sakai

Part 2: Writing Files (Optional Extra Credit 20 pts)
Modify the program to generate 10 names and store them in a list.
Write a function, dumpFile that writes the list to a file called "CharacterNames.txt" There should be one Character Name on each line in the file.
Test the program to be sure it works

Im stumped at number 2

here is what i have for number 1

f = open('names.txt', 'r')
lines = f.readlines()
for line in range(len(lines)):
lines[line] = lines[line].rstrip()
print(lines)
f.close()

Create a for which will have the following controls.

1. Label for First Name and TextBox for the First Name

2. Label for Last Name and TextBox for the Last Name

3. Label for bank account balance and TextBox for the bank account balance (assume $1000 in the bank account)

4. Create a button Name. The user will click the button and the first name and last name will be displayed on the label. You will create a label called lblFirstLastName to display the First and last Name.

5. Create a button bankbalance. The user will click the button and the balance will be displayed on the label. You will create a label called lblBankbalance to display the bank balance.

6. Create a Cancel button to cancel the form

------------------------------------------------------------------------------------------------

package swing;
import javax.swing.*;
public class SwingInheritance extends JFrame
{
   private static final long serialVersionUID = 1L;
   SwingInheritance()
   {
       JTextField userName = new JTextField();
       //userName.setBounds(x, y, width, height);
       userName.setBounds(80,100,100, 40);
       userName.setText("Hello");
       JLabel lblText = new JLabel();
       lblText.setBounds(80,150,300, 40);
       lblText.setText("You Entered: " + userName.getText());
       JButton button=new JButton("click");
       //create button
       button.setBounds(80,200,100, 40);
       JButton close = new JButton("Close");
       close.setBounds(80,250,100, 40);
       close.addActionListener(e ->
       {
           dispose();
       });
       //add to JFrame
       add(button);
       add(close);
       add(userName);
       add(lblText);
       //set frame properties
       setSize(400,500);
       setLayout(null);
       setVisible(true);
       }
   public static void main(String[] args)
   {
       new SwingInheritance();
   }
}

JAVA Program

Create a class called SoccerPlayer

Create 4 private attributes: First Name, Last Name, Games, and Goals

Have two constructors

Constructor 1 – default constructor; all values to "NONE" or zero

Constructor 2 – accepts input of first name, last name, games and goals.

Create get and set methods for each of the four attributes

Create a method the returns a double that calculates the average goals per game

This method checks for zero games played:

If there are zero played, display an error and set average to 0;

If greater than zero, do the math and set average to result of calculation

Create a test program that allows you to set the first name, last name, number of games and number of goals. Call it SoccerPlayerTest.

Create two instances of players.

The first should use the default constructor and the set methods to fill the attributes

The second should use the other constructor to set the attributes

Display the info about the players including the average goals per game.

Use the same SoccerPlayer class you created in CE-SoccerPlayer

Create a test program that allows you to enter in the first name, last name, number of games and number of goals. Call it SoccerPlayerTest.

Create an array of players. There should be three players.

Create a loop and ask for the information about each player.

Create a loop and display the info about the players including the average goals per game

2. Write python code for the below instructions (don’t forget to use the keyword “self” where appropriate in your code):

A. Define a Parent Class called Person

a. Inside your Person class, define new member variables called name, age, and gender.   Initialize these variables accordingly.

b. Define the constructor to take the following inputs: name, age, and gender.   Assign these inputs to member variables of the same name.

B. Define Child Class called Employee that inherits from the Person Class

a. Inside your Child class, define new member variables called title and salary.   Initialize these variables accordingly.

b. Define the constructor to take the following inputs: name, age, gender, title, and salary.   Assign these inputs to Class member variables of the same name. Note, you will need to specifically call the Parent constructor method inside the Child constructor, passing the appropriate inputs to the Parent constructor.

C. Instantiate an Employee object called George with the following inputs: name = “George”, age = 30, gender = “Male”, title = “Manager”, and salary = 50000.

D. Print out the object’s name, age, gender, title, and salary in one print statement to the console window. Your output should look like:

“George's info is: Name is George, Age is 30, Gender is Male, Title is Manager, and Salary is 50000”

1. Solve the following questions in excel using the skills from class.

1. Lindner is considering an investment with an initial cost of $122,400 and salvage value of 63,600 with the following cash flows over the next 6 years:

The discount rate is 14.8%. Find the NPV and IRR, what is the decision and what was the criteria for each rule?

2. You want to analyze the impact of a new project that will cause its cash flows to increase 12,000 over last year’s, and continue to grow at a constant rate of 7% per year for the foreseeable future. The discount rate is 13.5%. Analyze the project in three ways:
   1. Calculate the NPV and IRR of this project based on an initial investment cost of $97,000 and the change in cash flows each year, assuming the growth continues forever.
   2. Find the NPV and IRR of this project if the project only generates cash flows for 17 years.
   3. Use an embedded function in Excel to calculate the NPV of the project if the cash flows had zero growth, and the project only generates cash flows for 35 years.

UC Inc. has predicted unlevered free cash flows (FCF) of $19,800, $21,540, $25,300, and $28,900 for the next 4 years. Find the average growth rate using the predicted values. Then, assuming the growth rate persists forever at this rate, find the present value of the terminal value. Finally, find the total enterprise value. The discount rate is 18%.