Exception handling

All Exceptions that can be thrown must descend from this Java class:

The getMessage( ) method is inherited from this class?

What are the two broad catagories of Exceptions in Java?

If an Exception is not a checked exception it must extend what class?

What is the difference between a checked Exception and an unchecked Exception?

What are the two options a programmer has when writing code that may cause a checked Exception to be thrown? Can a try block contain code that would cause more than one type of Exception to possibly be thrown?

Is it true that a try block can only be followed by ONE catch block?

What is the purpose of the finally block?

When is the code in the finally block executed?

What happens when a try block throws an Exception object? Is an Exception the same thing as a syntax or logic error?

A bag of cookies contains 40 cookies. The calorie information printed on the bag claims that there are 8 servings in each bag and that a single serving equals 300 calories. Design and write a C++ program that prompts your user for the number of cookies that he or she ate and then displays the calories they consumed.

Use variables to represent the given information, such as the number of cookies in each bag and the number of calories in each serving. Compose statements using the given variables to calculate the number of calories in each cookie. Use the number of cookies and the number of calories per cookie to determine how many calories were consumed. The use of magic is not permitted in computer programming. You, as the programmer must compose steps that store given information in variables and then use these variables to determine values such as the number of calories in each cookie.

CODE IN C++

Guidelines: Please take note!

(a) Name your program Question1_1 for the queue structure and Question1_2 for the stack structure

(b) The Java Programmer is required to include screenshots from a JGrasp IDE which displays their commented code and the output and also indicates their laptop date and time of code execution, the screenshot of the code needs to be error-free and must not produce any logic errors!

E20.13 (LO 1, 2, 4) (Computation of Actual Return, Gains and Losses, Corridor Test, and Pension Expense) Erickson Company sponsors a defi ned benefi t pension plan. The corporation’s actuary provides the following information about the plan. January 1, December 31, 2020 2020 Vested benefi t obligation $1,500 $1,900 Accumulated benefi t obligation 1,900 2,730 Projected benefi t obligation 2,500 3,300 Plan assets (fair value) 1,700 2,620 January 1, December 31, 2020 2020 Settlement rate and expected rate of return 10% Pension asset/liability $ 800 $ ? Service cost for the year 2020 400 Contributions (funding in 2020) 700 Benefi ts paid in 2020 200 Instructions a. Compute the actual return on the plan assets in 2020. b. Compute the amount of the other comprehensive income (G/L) as of December 31, 2020. (Assume the January 1, 2020, balance was zero.) c. Compute the amount of net gain or loss amortization for 2020 (corridor approach). d. Compute pension expense for 2020.

E20.14 (LO 1, 2, 4) (Worksheet for E20.13) Using the information in E20.13 about Erickson Company’s defi ned benefi t pension plan, prepare a 2020 pension worksheet with supplementary schedules of computations. Prepare the journal entries at December 31, 2020, to record pension expense and related pension transactions. Also, indicate the pension amounts reported in the balance sheet.

only E20.14

QUESTION 1

For the salesdb tables loaded in your environment, the table specifications are below:

CUSTOMER (custno, lname, fname, mname, email, mobile, addrln1, addrln2, addrln3, city, state, zip, status)

PRODUCT (prodno, sku, unit, long_desc, short_desc, unitprice, qty_on_hand, qty_on_order)

SALES (salesno, saledate, custno, prodno, salesqty, unitprice, lineamount, taxable, taxrate, discountrate)

Write SQL that will list the sales to custno=11, Eva Santis. The resultset should include:

custno, fname, lname, salesno, prodno, long_desc, product unitprice, salesqty, totalcost for each line item.

Test your SQL and upload the SQL to this question.

QUESTION 2

For the salesdb tables loaded in your environment, the table specifications are below:

CUSTOMER (custno, lname, fname, mname, email, mobile, addrln1, addrln2, addrln3, city, state, zip, status)

PRODUCT (prodno, sku, unit, long_desc, short_desc, unitprice, qty_on_hand, qty_on_order)

SALES (salesno, saledate, custno, prodno, salesqty, unitprice, lineamount, taxable, taxrate, discountrate)

Write SQL that will create a mailing list for a flyer that will be sent to residents of Harlem. The resultset should include:

fname, lname, addrln1, addrln2, addrln3, city, state, zip

Test your SQL and upload the SQL to this question.

QUESTION 3

For the salesdb tables loaded in your environment, the table specifications are below:

CUSTOMER (custno, lname, fname, mname, email, mobile, addrln1, addrln2, addrln3, city, state, zip, status)

PRODUCT (prodno, sku, unit, long_desc, short_desc, unitprice, qty_on_hand, qty_on_order)

SALES (salesno, saledate, custno, prodno, salesqty, unitprice, lineamount, taxable, taxrate, discountrate)

Write SQL that will list the SKU, and LONG_DESC of items where the quantity on hand is 20 items or less so that it can be ordered from the supplier. The resultset should include:

SKU, UNIT, LONG_DESC, QTY_ON_HAND

Test your SQL and upload the SQL to this question.

QUESTION 4

For the salesdb tables loaded in your environment, the table specifications are below:

CUSTOMER (custno, lname, fname, mname, email, mobile, addrln1, addrln2, addrln3, city, state, zip, status)

PRODUCT (prodno, sku, unit, long_desc, short_desc, unitprice, qty_on_hand, qty_on_order)

SALES (salesno, saledate, custno, prodno, salesqty, unitprice, lineamount, taxable, taxrate, discountrate)

Write SQL that will report the total sales amount for all the data in the sales table. The resultset should include:

SUM of unitprice from the product table times sales quantity from the sales table.

Note: relate the prodno of SALES with prodno of PRODUCT.

Test your SQL and upload the SQL to this question.

/*salesdb Exercise to create salesdb

Connect to MySQL using your root account. In MySQL, we only use root account which has all the privileges.
*/

create database salesdb;

/* Set default schema to salesdb, then create the following tables: */

use salesdb;
create table customer
( custno int(9)
, lname varchar(30)
, fname varchar(30)
, mname varchar(30)
, email varchar(35)
, mobile varchar(10)
, addrln1 varchar(30)
, addrln2 varchar(30)
, addrln3 varchar(30)
, city varchar(30)
, state varchar(2)
, zip varchar(10)
, status varchar(10)
);

alter table customer add primary key (custno);
create unique index cust_ix on customer (email);

create table product
( prodno int(9)
, sku varchar(10)
, unit varchar(10)
, long_desc varchar(30)
, short_desc varchar(15)
, unitprice decimal(16,2)
, qty_on_hand int(9)
, qty_on_order int(9)
);

alter table product add primary key (prodno);
create unique index prod_ix on product (sku);

create table sales
(
salesno    int(9)
,saledate timestamp
,custno       int(9)
,prodno       int(9)
,salesqty   int(16)
,unitprice decimal(16,2)
,lineamount decimal(16,2)
,taxable   char(1)
,taxrate   decimal(5,2)
,discountrate decimal(5,2)
);

alter table sales add primary key (salesno);
use salesdb;
alter table sales add constraint sales_cust foreign key (custno) references customer (custno);
use salesdb;
alter table sales add constraint sales_prod foreign key (prodno) references product (prodno);

/*
Inserting data
*/

insert into customer
( custno
, lname
, fname
, mname
, email
, mobile
, addrln1
, addrln2
, addrln3
, city
, state   
, zip   
, status
) values
(1,'Doe','John','M','[email protected]','2125551212','1 Main St.','Apt 1','','New York','NY','10000','A');

insert into customer
values
(2,'Doe','Ann','F','[email protected]','2125551313','2 Main St.','Apt 2','','New York','NY','10000','A');

insert into customer
values
(3,'Smith','Bill','A','[email protected]','2125551413','4 Grove St.','','','Brooklyn','NY','11231','A');

insert into customer
values
(4,'Consuelo','Cristina','A','[email protected]','7185551213','543 86 St.','1F','','Brooklyn','NY','11209','A');

insert into customer
values
(5,'Chu','Coney','C','[email protected]','7185551555','43 72 Ave.','3F','','Woodbridge','NY','11101','A');

insert into customer
values
(6,'James','Bob','L','[email protected]','7185552255','580 Smith Ave.','','','Floral Park','NY','11040','A');

insert into customer
values
(7,'Brick','Gib','B','[email protected]','7185556655','25 Delaware Ave.','','','Floral Park','NY','11040','A');

insert into customer
values
(8,'Hussein','Jimmy','B','[email protected]','7185557775','300 Fields Ave.','','','Rockaway','NY','11430','A');

insert into customer
values
(9,'Jamal','Joey','J','[email protected]','718555875','34 89th Ave.','','','Rockaway','NY','11430','A');

insert into customer
values
(10,'Desantis','John','J','[email protected]','2125554445','544 152th St.','','','Harlem','NY','10032','A');

insert into customer
values
(11,'Santis','Eva','J','[email protected]','2125555451','644 152th St.','','','Harlem','NY','10032','A');

insert into customer
values
(12,'Yates','Tony','T','[email protected]','2125552221','663 148th St.','','','Harlem','NY','10032','A');

insert into product
( prodno
, sku   
, unit
, long_desc
, short_desc
, unitprice
, qty_on_hand
, qty_on_order
)
values
(1,'123-000-10','QTY','Stainless Steel 9in Pan w/ Lid','SS 9in Pan wLid',35.50,10,0);
insert into product
values
(2,'150-020-20','QTY','8 oz Glass Tall','8 oz Glass Tall',2.50,100,0);
insert into product
values
(3,'160-030-10','QTY','5 oz Glass Short','5 oz Glass Sh',2.50,100,0);
insert into product
values
(5,'150-010-20','QTY','Place Mat','Place Mat',12.75,200,0);
insert into product
values
(17,'170-050-20','QTY','Flower Vase','Vase',15.25,10,0);
insert into product
values
(21,'210-000-20','QTY','Long Broom','L Broom',8.50,20,0);
insert into product
values
(22,'220-000-21','QTY','Vacuum Cleaner','Vac Cl',55.00,10,0);
insert into product
values
(23,'230-000-23','QTY','Table Lamp','Tab Lamp',35.00,20,0);
insert into product
values
(24,'240-000-24','QTY','Ligh Bulbs','Light Bl',5.00,20,0);
insert into product
values
(25,'250-000-25','QTY','Wall Clock','Wall Bl',15.00,10,0);
insert into product
values
(29,'290-000-01','BOX','24 Piece Dining Set','24 Pc DN Set',85.00,24,0);
insert into product
values
(30,'300-000-02','DOZ','Cloth Rose Flowers','Cloth Rose',85.00,24,0);
insert into product
values
(101,'600-101-01','SET','Combination Box Wrench','Box Wr Comb',65.00,100,0);
insert into product
values
(102,'600-102-01','SET','Screwdriver Set','ScrwDrvr Set',35.00,100,0);
insert into product
values
(103,'600-103-01','SET','Pliers Set','Pliers Set',25.00,100,0);
insert into product
values
(150,'600-150-01','BOX','2 Inch Nails','2in Nails',7.00,1000,0);
insert into product
values
(151,'600-151-01','BOX','2 Inch Drywall Screws','2in Dryw Scrw',7.00,1000,0);
insert into product
values
(152,'600-152-01','BOX','1 Inch Nails','1in Nails',7.00,1000,0);
insert into product
values
(153,'600-153-01','BOX','1 Inch Drywall Screws','1in Dryw Scrw',7.00,1000,0);
insert into product
values
(2001,'700-200-01','QTY','Large Down Pillow','Dwn Pillow LG',16.00,100,0);
insert into product
values
(2002,'700-200-02','QTY','Medium Down Pillow','Dwn Pillow MD',14.00,100,0);
insert into product
values
(2003,'700-200-03','QTY','Small Down Pillow','Dwn Pillow SM',12.00,100,0);
insert into product
values
(2011,'700-201-01','QTY','Large Pillow Case','Pillow Cs LG',11.00,100,0);
insert into product
values
(2012,'700-201-02','QTY','Medium Pillow Case','Pillow Cs MD',10.00,100,0);
insert into product
values
(2013,'700-201-03','QTY','Small Pillow Case','Pillow Cs SM',9.00,100,0);

insert into sales
values (1,'2020-10-15',1,1,1,0,0,'Y',8.25,0);
insert into sales
values (2,'2020-10-15',1,2,6,0,0,'Y',8.25,0);
insert into sales
values (3,'2020-10-15',1,25,1,0,0,'Y',8.25,0);
insert into sales
values (4,'2020-10-15',1,5,1,0,0,'Y',8.25,0);
insert into sales
values (5,'2020-10-14',6,29,1,0,0,'Y',8.25,0);
insert into sales
values (6,'2020-10-14',6,22,1,0,0,'Y',8.25,0);
insert into sales
values (7,'2020-10-15',2,21,1,0,0,'Y',8.25,0);
insert into sales
values (8,'2020-10-15',2,5,1,0,0,'Y',8.25,0);
insert into sales
values (9,'2020-10-14',10,102,1,0,0,'Y',8.25,0);
insert into sales
values (10,'2020-10-14',10,103,1,0,0,'Y',8.25,0);
insert into sales
values (11,'2020-10-14',10,150,1,0,0,'Y',8.25,0);
insert into sales
values (12,'2020-10-14',10,24,2,0,0,'Y',8.25,0);
insert into sales
values (13,'2020-10-14',10,153,4,0,0,'Y',8.25,0);
insert into sales
values (14,'2020-10-12',12,24,4,0,0,'Y',8.25,0);
insert into sales
values (15,'2020-10-12',12,23,4,0,0,'Y',8.25,0);
insert into sales
values (16,'2020-10-15',11,29,1,0,0,'Y',8.25,0);
insert into sales
values (17,'2020-10-15',11,22,1,0,0,'Y',8.25,0);
insert into sales
values (18,'2020-10-15',11,24,1,0,0,'Y',8.25,0);
insert into sales
values (19,'2020-10-12',12,5,1,0,0,'Y',8.25,0);
insert into sales
values (20,'2020-10-11',3,2001,1,0,0,'Y',8.25,0);
insert into sales
values (21,'2020-10-11',3,2011,1,0,0,'Y',8.25,0);
insert into sales
values (22,'2020-10-11',3,3,6,0,0,'Y',8.25,0);
insert into sales
values (23,'2020-10-11',3,2,6,0,0,'Y',8.25,0);
insert into sales
values (24,'2020-10-11',10,22,1,0,0,'Y',8.25,0);
insert into sales
values (25,'2020-10-11',10,24,1,0,0,'Y',8.25,0);
insert into sales
values (26,'2020-10-11',10,101,1,0,0,'Y',8.25,0);
insert into sales
values (27,'2020-10-11',10,103,1,0,0,'Y',8.25,0);
insert into sales
values (28,'2020-10-11',10,102,1,0,0,'Y',8.25,0);
insert into sales
values (29,'2020-10-11',9,17,1,0,0,'Y',8.25,0);
insert into sales
values (30,'2020-10-11',9,30,1,0,0,'Y',8.25,0);

A company with fixed manufacturing costs of $500,000 produces 100,000 units in 2020 and 125,000 units in 2021. The company sells 90,000 units each in both years. Other costs and selling price are unchanged for 2020 and 2021. Assume that there was no beginning inventory in 2020. Which of the following is true? Variable costing income will be greater in 2020 than in 2021. The dollar amount of ending inventory will be greater in 2020 than in 2021. Variable costing income will be the same in 2021 and 2020.

The 21st-century auditor requires knowledge of technology and accounting information systems in addition to his / her understanding of accounting concepts and guidelines. The degree of knowledge in technology and AIS will vary with each auditor. Recommend the top-five technology and AIS skills that the 21st-century auditor should have. Justify your recommendations.

Now, recommend a series of actions that need to be taken by auditors and their firms to ensure that the auditors maintain their skills.

Simply put, a blockchain can be considered to be a distributed ledger which contains the relevant
details for every transaction that has ever been processed. Conduct a desktop research and based
on this research:

i. Define blockchain technology, including its basic structure;
ii. Describe the current and potential uses of this technology by business;
iii. Given (i) and (ii) above, what impact will this technology have on the traditional audit process?  

Explain how has technology changed the learning system? It has to be an argumentative essay. Need argumentative details for 3 body paragraph's and

Also need a introduction

Introduction to how technology got introduced to schools and students.

.

ASAP!!!

Thesis: The importance of technology in the classroom can increase educational productivity by accelerating the rate of learning, reducing costs associated with instructional materials or program delivery and, and better-utilizing teacher time.

1. Cite an instance when you should consider "making" new technology
2. Cite an instance when you should consider "buying" new technology
3. Cite an instance when you should consider "modifying" existing technologies to create a new one.

In your citations, include the following:

1. What technology do you wish to develop?
2. What are the resources available or lacking which would make consider this option?