C# (Thank you in advance)

Create an Employee class with five fields: first name, last name, workID, yearStartedWked, and initSalary. It includes constructor(s) and properties to initialize values for all fields.

Create an interface, SalaryCalculate, class that includes two functions: first,CalcYearWorked() function, it takes one parameter (currentyear) and calculates the number of year the worker has been working. The second function, CalcCurSalary() function that calculates the current year salary.

Create a Worker classes that is derived from Employee and SalaryCalculate class.

• In Worker class, it includes two field, nYearWked and curSalary, and constructor(s). It defines the CalcYearWorked() function using (current year – yearStartedWked) and save it in the nYearWked variable. It also defines the CalcCurSalary() function that calculates the current year salary by using initial salary with 3% yearly increment.

Create a Manager class that is derived from Worker class.

• In Manager class, it includes one field: yearPromo and constructor(s). Itincludes a CalcCurSalary function that calculate the current year salary by overriding the base class function using initial salary with 5% yearly increment plus 10% bonus. The manager’s salary calculates in two parts. It calculates as a worker before the year promoted and as a manager after the promotion.

Write an application that reads the workers and managers information from files (“worker.txt” and “manager.txt”) and then creates the dynamic arrays of objects. Prompt the user for current year and display the workers’ and managers’ current information in separate groups: first and last name, ID, the year he/she has been working, and current salary.

**Following is the content of the text files**

________________

manager.txt :

3
Sam
Reza
M000411
1995
51000
2005
Jose
Perez
M000412
1998
55000
2002
Rachel
Pena
M000413
2000
48000
2010

_______________

worker.txt :

5
Hector
Alcoser
A001231
1999
24000
Anna
Alaniz
A001232
2001
34000
Lydia
Bean
A001233
2002
30000
Jorge
Botello
A001234
2005
40000
Pablo
Gonzalez
A001235
2007
35000

1. Name 3 new tax law changes as it relates to Individual Tax Payers?
2. Name 3 new tax law changes as it relates to Corporate Tax Payers?
3. What is the new “Pass thru” tax deduction? Which entities does it apply to?
4. Do you think that by reducing the corporate tax rate it will help or hurt the United States?

Name two ways a bank minimizes credit risk before a loan is made. Name two ways it does this after the loan is made.

Name and describe (please describe)  5 threats to biodiversity of herps and name three things you could do to reduce them? (of course the challenge is always the inconvenience of sticking to principles)

1. Create a table ‘StudentInfo’ with following fields:
   1. ID
   2. First Name
   3. Last Name
   4. SSN
   5. Date of Birth
2. Create a table ‘ClassInfo’ table:
   1. ID
   2. Class Name
   3. Class Description
3. Create a table ‘RegisteredClasses’ table:
   1. StudentID
   2. ClassID

The RegisteredClasses table should have a foreign key relationship to StudentInfo and ClassInfo tables for the respective IDs. Also the IDs in StudentInfo and ClassInfo need to be primary keys.

When you submit the file your email should also contain the following SQL Queries:

1. Query to show all records from StudentInfo whose first name is John
2. Query to show all records from StudentInfo whose last name is Doe
3. Query to delete all records from from ClassInfo where class name starts with ‘ISAM'

1. Name three products that have completed their life cycles.

2. Name a product you use that will soon be on the decline of its life cycle. Why is it on the way out?

3. Why can't you afford to say "that's not my job" anymore?

DO NOT COPY PREVIOUS ANSWERS!!!

Design and implement a C++ Application that:

Interactively input:

• Employee First Name
• Employee Last Name
• Employee id
• Employee hours worked per week
• Employee Pay Rate

Menu with Option to:

• Print out Employee Report in the following report format
• Search for an Employee
• Display the Report in Sorted based on Last Name or ID
• Calculate the Pay
• Quit

Criteria:

• Be sure to use Parallel Arrays to Store the Employee Information
• Output must be formatted and line up with the column header
• It must support interactive data input
• output displays on the screen for different reports

Use this data for input:

• Brian Adams 612366 36
• David Eisenhower 957654 38
• Kathy Jones 123456 43
• Janet Williams 245695 39
• Steve Bradford 245690 39

MARKETING COMPANY REPORT PROGRAM

FIRST NAME LAST NAME ID HOURS WORKED Hourly Rate Total Pay
Brian Adams 612366 36
David Eisenhower 957654 38
Kathy Jones 123456 43
Janet Williams 245695 39
Steve Bradford 245690 39

Average Hours Worked: 39 Hrs/Week

We plan to develop customer’s database that stores customer’s number (ID), first name, last name and balance. The program will support three operations: (a) reading and loading customer’s info from the text file, (b) entering new customer’s info, (c) looking up existing customer’s info using customer’s number(ID), (d) deleting the customer’s info and (e) the updated database will be stored in the text file after the program terminate.

Customer’s database is an example of a menu-driven program. When the program begins to execute, it first read the text file and upload customer’s info. Then it presents the user with a list of commands. The user can enter as many commands as desired, in any order. The a command prompts the user to enter customer’s number (ID), first name, last name and balance, which are then stored in the program’s database. The f command prompts the user to enter a customer number and then display the corresponding record on the screen. The q command saves the information in the database to the file specified by the user and terminate program.

Based on the project description, please design classes and their corresponding methods. You need describe each method and write API for each method (Leave method body blank) (Hint: you need design one driver class, one database class and one customer record class). Based on your design, please draw the UML diagram as well.

database.txt

12345 Sebastian vanDelden 123.22
11111 Sarah Smith 45.89
22222 Sue Johnson 7765.98
33333 Billy Hunts 374.99

Based on your design/code, please draw a simple but detailed UML diagram as well? (This is the question that needs to be answered!) the code isn't needed for this.