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”

Fitting Logistic Reegression (depedent varaible(Employed), Independent variables (Age, Race.Ethnicities, Education.Attainment, gender)

dataset

in JAVA, Hash table

The goal is to count the number of common elements between two sets. Download the following data sets, and add them to your project:

• girlNames2016.txt
• boyNames2016.txt

These files contain lists of the 1,000 most popular boy and girl names in the US for 2016, as compiled by the Social Security Administration. Each line of the file consists of a first name, and the number of registered births that year using that name.

Your task is to determine which names appeared on BOTH the boys list and girls list. We want a list of the most popular baby names that could be used for either a girl or a boy (ex. Alex or Drew).

Create a Driver class, and in the main method, use the following algorithm:

1. Read each girl name as a String, ignoring the number of namings, and add it to a set girlNames.
2. Read each boy name as a String, ignoring the number of namings, and add it to a set boyNames.
3. Calculate the intersection of these sets and place the result into a new set unisexNames.
   1. Build this set by iterating through one set, and checking whether the other set contains that element. If so, this element belongs to both sets and should be added to unisexNames.
4. Print all elements in unisexNames.

girlName2016.txt:

boyName2016.txt

In this project, you will create a Visual Basic solution to perform customer billing at the Cyberian Internet Cafe. Please see below for the detailed instructions. You will create the project and then design a form using the image provided here. Then, add the necessary code to do the billing calculation and display the amount due.

Instructions

In this case, you will create a Visual Basic solution that performs customer billing for the Cyberian Internet Café. The Cyberian Internet Café provides Internet access to its customers on an hourly basis. One hour of Internet access costs $12.00. You will create a solution with a splash screen, which is an application that calculates the total cost for a customer, using the image file included in the downloaded files.

Step 1: Create the Project:

Create a Visual Basic Project using the project name “InternetCafe”.

Step 2 – Design the Form:

Design the form shown in Figure 1. You will need three button controls, three text boxes, one picture box control, and five label controls. Name your controls as shown in Table 1, and set the properties as indicated.

Table 1 – MainForm Controls and Their Property Values

Step 3 – Add the image to the project’s Debug folder:

Copy the image files (J0195384.jpg) that you downloaded as part of this Case’s files into the following folder of your project:

C:\InternetCafe\ InternetCafe\bin\Debug

(If your drive letter is different than C:, use your drive letter.)

Step 4 – Add code to perform the calculation and display the amount due:

1. In the form’s Declarations section, declare a constant named HOURLY_RATE and set its value to be 12.00.
2. In the clearButton’s Click event, add code to clear all of the text box controls and the amountDueLabel control.
3. In the calculateButton’s Click event, declare two Single variables named hours and amount, and a Boolean variable name isConverted. Use the TryParse method to assign the value in the hoursTextBox control to the hours variable, storing the result from the TryParse method in the isConverted variable. Do the calculation using the hours and the hourly rate, and store the result in the amount variable. Display the amount value, formatted as currency, in the amountDueLabel control.
4. In the exitButton’s Click event, add code to end the program.

Step 5 – Create a splash screen

Create a splash screen using the Project menu - Add Windows Form. Select the Splash Screen form template.

Also change the splash window title to "Internet Cafe". reference : textbook page 114.

Set project properties:

Set the project’s startup form to be MainForm.   Set the project’s splash screen to be SplashScreen.

Step 6: Save and run

Save all files, then start the application. Try entering data and using the Calculate button. Is the result formatted as currency?