The following are the information for Chun Equipment Co. for 2018. (Hint: Some of the items will not appear on either statement, and ending retained earnings must be calculated.)

Required

Prepare a multistep income statement and balance sheet for Chun Equipment Co. for 2018.

Prepare a multistep income statement for Chun Equipment Co. for 2018.

Prepare the balance sheet for Chun Equipment Co. for 2018. (Be sure to list the assets in the order of their liquidity.)

Consider the following code:

import java.util.Scanner;

public class Main {

   public static void main(String[] args) {

   Scanner in = new Scanner(System.in);

String input = "";

System.out.println("Enter the first number: ");
  
input = in.nextLine();
int a = 0;
int b = 0;
  
a = Integer.parseInt(input);
  
System.out.println("Enter the second number: ");
input = in.nextLine();
  
b = Integer.parseInt(input);
  
int result = 0;

result = a/b;
  
System.out.println("a/b : " + result);

   }

Copy the code to your Main.java file and run it with the following inputs:
34 and 0;
‘Thirty-four’ as the first input.

What prevented the program from running successfully?

Update the code, so that it can handle cases a) and b).

Please note the following:
You have to use try-catch to handle exceptions.
To determine exception classes, that you need to catch, use error message from the respective case (a) and b)). Hint: to handle String-to-integer conversion, use NumberFormatException;
Exceptions should be caught so that:
Code never crashes due to non-numeric input (both for first and second values);
Code never crashes due to division by zero;
If non-numeric value is entered for a or b, program should output "Error: entered value is not an integer number. Exiting..." and exit (use System.exit(0); to exit);
If zero value is entered for b, program should output " Error: cannot divide by zero. Exiting..." and exit (use System.exit(0); to exit);
Hints: Use 3 try-catch blocks in total. Try block should only contain the command, that can throw an exception.

Assignment 1: Build a simple class called DBTester.java. This class should have only one method, main method. In the main method you should read in all of the rows of data from the Instructors Table in the Registration Database, then print out this data. Follow the steps outlined in class. Remember to use try-catch blocks for all database access code. The example in the book does not use Try-catch blocks, but you should

Create a program in visual basic that allows the user to manage vehicle information including: • License plate number • Owner name • Owner phone number The user interface will be GUI-based providing the following capabilities: • Add up to 100 vehicles • Remove specified vehicles • View a sorted list of all known license plates • View the data for a specified vehicle • Save the database contents into a file • Load a saved database from a file

After reading the required resources for this module and reviewing the database you just designed for your final project, think about what security considerations should be taken with the design. Write these considerations in the form of a database design security checklist that includes your top six to eight security implications for the database design.

A security assessment checklist is a common practice in the industry and proves to a CIO or IT auditor that you are following best practices in securing a database. It also serves as a living document to assist you in your design process. For example, on the networking side of IT, Cisco provides this checklist for small and medium business to evaluate their network infrastructure. You will use the information from this website to assist you in creating your own checklist.

For this discussion, you will develop something similar, but for databases. Post your checklist to the discussion forum. You will not see your peers’ initial posts until you have posted your own checklist.

Upon reviewing your classmates’ checklists, provide substantive responses to at least two of your classmates on their checklist. Your responses should include items such as whether their checklist will manage risk appropriately and whether the checklist will maintain the databases’ confidentiality, integrity, and availability.

Using WORKBENCH:

1. Create the database below via an ER Diagram in Workbench (take screen shots of the diagram)

2. Go to the database table view and take a screen shot of the table(s)

3. Go to the data entry tool and enter at least three lines of data (in each table). Take screen shots.

Create a database that is in third normal form for the following:

You are a nerd and have decided to organize your comic books in a database.

You have decided to create categories for the books. The categories a a separate table because it includes the category name and a description of the category. The names might not be unique.

You also want to keep track of the size (width and length) of each book (I did say you were a nerd..LOL). Since several books are the same size, you decide to also keep this in a separate table.

You have books from several publishers, so you decide to create a publishers table. In the table you have the publisher and the address of their home office.

Finally, of course, you have the books table. The books table (of course) includes the name and author but also links to the other tables.

Be creative!

Make sure to populate all tables!

Write a GUI that allows the user to do the following:

Create a new Patient Database if it doesn’t exist yet by the click of a button.

Create a second button that populates the database with the appropriate Asset table if it does not exist yet, and fill the table with at least 10 patients.

Connect to the Patient Database and display all current patients in a List by default. You will have to create a Patient Class. This class needs at a minimum the following attributes: Name, Id, Age, Gender, Blood type, Weight, Height. Use appropriate data types. (use UUID for the Id property).

Next to the list displaying the patients, create at least three ways to filter that list. For instance, you only want to display patients over the age of 30. Or only patients who are "Female". Or only patients with weight above 200 lbs. Be creative in which filters would make real sense and use appropriate JFoeniX controls for them. Make sure the controls you use send the appropriate SQL Query to the database and display the results in the patients list view.

It needs to be in Java and JavaFX. Does not have any files provided. Just need it in code. Especially for the Patient class

There is no GUI specification. Just a simple one will do.

Metal Holdings Inc.

You have been assigned the task of creating a simple relational database using SQLite database by the owner of “Metal Holdings” who is in the business of selling industrial metals to customers (mostly wholesale suppliers) who buy from the company.

Your goal is to design and build a database that would be responsible for:

• Managing a product table containing all metals which at a minimum should provide information such as name, description and price of each metal sold by the company.

• Manage a list of customers who would be purchasing metals from the company. The owner is interested in name, location, contact as well as whether the customer is a retail or wholesale buyer.

• Manage and maintain a complete inventory of all orders shipped by the company to customers.
  
• The owner wants to maintain the following information about each order at a minimum, but not limited to:
  • Date of the OrderShipping information such as date and status.
  • Product purchased and Quantity ordered.
  • Customer Information.
  • Each customer can purchase 1-to-many products (metals) in a single order.

The following is a list of metals sold by the company (these below metals should be available in your uploaded SQLite database):

• Copper
• Aluminium
• Silver
• Steel
• Bronze
• Brass
• Lead
• Nickel
• Titanium
• Magnesium

Use the following to answer questions 7-15:

1999 2000

Sales $2900 $3300

Cogs $2030 $2310

Interest $410 $420

Dividends $56 $79

Depreciation $290 $330

Cash $250 $150

Receiviables $242 $412

Current liabilities $900 $1100

Inventory $1015 $900

Long Term Debt $3200 $3100

Net Fixed Assets $6000 $5700

Tax Rate 34% 34%

      7.   What are earnings before interest and taxes for 2000?

            A) $112

            B) $158

            C) $580

            D) $660

            E)   $780

      8.   What is net income for 2000?

            A) $112

            B) $158

            C) $580

            D) $660

            E)   $780

      9.   What is operating cash flow for 2000?

            A) $   248

            B) $   662

            C) $   908

            D) $1.072

            E)   $1,375

    10.   What is net working capital for 2000?

            A) $   362

            B) $   473

            C) $   519

            D) $   607

            E)   $1,060

    11.   What is cash flow to stockholders for 2000?

            A) $ 79

            B) $189

            C) $445

            D) $524

            E) $603

    12.   What is cash flow to creditors for 2000?

            A) $100

            B) $320

            C) $420

            D) $520

            E)   $720

    13.   What is net capital spending for 2000?

            A) -$ 10

            B) $ 30

            C) $300

            D) $530

            E)   $630

    14.   What is the change in net working capital during 2000?

            A) -$245

            B) -$125

            C) $362

            D) $607

            E)   $904

    15.   What is cash flow from assets for 2000?

            A) $   428

            B) $   540

            C) $   633

            D) $   923

            E) $1,123

(C++) Write a program to read from a grade database (data.txt). The database (text file) has students names, and grades for 10 quizzes.Use the given function prototypes to write the functions. Have main call your functions. The arrays should be declared in main() and passed to the functions as parameters. This is an exercise in parallel arrays, int and char 2 dim arrays.

Function prototypes:

1. int readData(ifstream &iFile, int scores[][10], char names[][30]);
   This functions takes the file stream parameter inFile by reference, after the file is open. It reads from the text file into the names array and the scores array. It essentially populates the array with data from the file and returns an int which is the count of the number of items in the array.

2. void findLowestEach(int scores[][10], char names[][30], int size);

   This function takes the 2 parallel arrays and an int size and prints each students’ names

   and lowest score on separate lines.

3. void findHighestEach(int scores[][10], char names[][30], int size);

   This function takes the 2 parallel arrays and an int size and prints each students’ names

   and highest score on separate lines.

4. void calcAverage(int scores[][10], char names[][30], int size); This functions take the 2 parallel arrays and an int size, and calculates the average score of each students and puts it in a new array called average[]. The average array can be a local variable double average[CAP]; Print the students name and average at the end of this function.

5. int main()​should declare two 2-dim arrays, one for students names, ​char names[CAP][30];​ and ​int scores[CAP][NUM_GRADES];​ ​CAP ​is an ​int constant = 100, and ​NUM_GRADES​ is an ​int ​constant = 10. You should also declare a file stream variable ​inFile ​and open the file. Then, main should call ​readData​, and load the data from the text file. Then main should call ​findLowestEach​(.....), and then

findHighestEach​(.........), and print the values. Then main should call calcAverage​(...) and print the students’ names and their average.

data.txt

Bob 56 67 83 76 84 94 68 86 78 56
John 76 89 95 64 78 34 99 89 104 98
Joe 65 68 89 78 45 69 98 101 99 89
Amy 86 77 89 76 94 54 78 89 78 66
Nick 76 69 95 94 78 64 99 89 110 88
Alex 95 88 89 78 95 69 88 101 99 89
Marga 96 67 89 76 64 94 98 83 78 56
Mike 76 89 95 64 78 34 99 89 104 98
Bella 85 68 89 78 45 69 98 101 99 89
Priya 86 77 89 76 94 94 78 89 78 96
Karen 78 69 95 94 78 94 99 89 110 88
Amit 95 88 79 78 95 89 88 101 99 89

Please see sample output on the next page. Sample Output:

Here is the grade database:
Name 1 2 3 4 5 6 7 8 9 10 Bob 56 67 83 76 84 94 68 86 78 56 John 76 89 95 64 78 34 99 89 104 98 Joe 65 68 89 78 45 69 98 101 99 89 ....
....
....
....
Bob’s highest grade is: 94
Bob’s lowest grade is: 56
John’s highest grade is: 104
....
....

The average of their grades is as below: Bob 74.8
John 82.6
....

....

Please help.

Thank you.